Biostats

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