week 3 statices

Open the small Excel database that you have been using each week.

  1. 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.
  2. 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. See example 5.13. in your text book for additional help.