Problem Set #5: Statistical Analysis of Charlotte-Rock Hill Air Quality Data

Individual work required.  Show all work to receive credit. 

Download dataset1 on the course syllabus page. The data set consists of ozone, NO, CO, and hydrocarbon ambient air measurements for several days during a recent ozone season in the Charlotte-Rock Hill Metropolitan Statistical Area.

Complete the following exercises:

1.      In newy inserted and clearly-label rows above the data set; determine the mean, median, standard deviation, standard error, variance, CV, geometric mean, and range for each of the variables (columns) listed in the data set.

 

2.      For CO readings, calculate the 90% confidence interval.

 

3.      Use a normal statistical model from the data to predict the % of the time that the eight-hour ozone reading would be expected to be above 80 parts-per billion (ppb). Then compare this prediction with the actual % of readings that were above 80 ppb.

 

4.      For the aromatics readings, assume that these data are lognormally distributed and then calculate the 95% confidence interval for the readings.