Excel Instructions: Five-Number Summary
To open the actor's age dataset, click here and it will automatically download the file to your computer. Find the downloaded file (usually in the Downloads folder) and double-click it to open it in Excel.
Now use Excel to calculate the numerical measures of a distribution:
- min
- Pick a cell outside of column A, and type min.
- Then, in the next cell to the right, type =min(A2:A33).
- Q1
- In the cell undermin, type Q1.
- Then, in the next cell to the right, type =quartile(A2:A33,1).
- Median
- In the cell underQ1, type Median.
- Then, in the next cell to the right, type =median(A2:A33).
- Mean
- In the cell underMedian, type Mean.
- Then, in the next cell to the right, type =average(A2:A33).
- Q3
- In the cell underMean, type Q3.
- Then, in the next cell to the right, type =quartile(A2:A33,3).
- Max
- In the cell underQ3, type Max.
- Then, in the next cell to the right, type =max(A2:A33).