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).
