STEP-BY-STEP TECHNOLOGY GUIDE: Percentiles and Quartiles

TI-83/84

The quartiles are provided using the instructions for descriptive statistics shown on page 117.

EXCEL

  • Step 1 Enter the data into column A.
  • Step 2 Select Data > Data Analysis.
  • Step 3 Select Rank and Percentile and click OK.
  • Step 4 Click in the Input Range cell. Then highlight the data in column A. If the variable name is in the column, select Labels in First Row. Click OK.

MINITAB

The quartiles are provided using the instructions for descriptive statistics shown on page 117.

SPSS

  • Step 1 Enter the data in the first column.
  • Step 2 Click Analyze > Descriptive Statistics > Frequencies …
  • Step 3 Click the column name and the arrow to move it to the Variable(s) box.
  • Step 4 Click Statistics…. For quartiles, select Quartiles. For other percentiles, select Percentile(s), type in the desired percentile in the small box, and click Add. Click Continue, then OK.

JMP

  • Step 1 Click File > New > DataTable. Enter the data in Column 1.
  • Step 2 Click Tables > Summary.
  • Step 3 Click the variable name under Select Columns. For each desired percentile, enter its value in the For quantile statistics, enter value (%) box. Then select Quantiles from the Statistics drop-down menu. After all have been entered, click OK.

CRUNCHIT!

We will use the data from Example 26 (page 160).

  • Step 1 Click File, then highlight Load from Larose, Discostat3e > Chapter 3, and click Example 03_26.
  • Step 2 Click Statistics and select Descriptive statistics. For Columns, select Exports.
  • Step 3 In the Percentiles (comma-separated) cell, enter the percentiles that you would like to find. For example, to find the 5th and 95th percentiles, enter 5, 95.
  • Step 4 Click Calculate.