Open the small Excel database that you have been using each week.
With that database, create a 95% confidence interval for age—both by hand and using Excel to calculate the pieces you need to perform the calculation.
Also, assuming that the distribution of age has a normal shape, determine the age percentile of the 72-year-old male in the data set – both by hand and using Excel to calculate the pieces you need to perform the calculation.
