HW 4 Exemplar (Prob 3.19)

HW 4 Exemplar (Prob 3.19) - Exemplar for the Excel Homework...

This preview shows pages 1–3. Sign up to view the full content.

Exemplar for the Excel Homework Problem from Chapter 3 Required for Homework #4 Problem 3.19 AQI = air quality index Excel calculations: stat Ponoma AQI ranked x dev dev^2 28 28 -20.33 413.3089 42 42 43.5 = Q1 -6.33 40.0689 58 45 -3.33 11.0889 48 48 -0.33 0.1089 45 49 = median 0.67 0.4489 55 50 1.67 2.7889 60 55 56.5 = Q3 6.67 44.4889 49 58 9.67 93.5089 50 60 11.67 136.1889 0.03 742.00 = SOS 92.75001 = s^2 count 9 9 9.63 = s mean 48.33 48.33 median 49 49 mode no mode no mode midrange 44 44 midquartile 50 50 Q1 43.5 43.5 Q3 56.5 56.5 IQR 13 13 range R 32 32 IQR/R 0.406 0.406 s^2 92.75 s 9.63 CV 0.199 a. Range = 60 - 28 = 32 IQR = Q 3 - Q 1 = 57.5 – 43.5 = 14 HW 4 exemplar: Prob 3.19 1 © Harvey Singer 2010

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
b. x = = 435 9 48 33 . 2 ( ) 742 i x x Σ - = 2 2 ( ) 742 92.75 1 8 i x x s n Σ - = = = - 92.75 9.63 s = = c. The average air quality is about the same (on average). But, the variability is greater in Anaheim. (F or Anaheim, CV = 11.66/48.5 = 0.240, which is greater than CV = 9.63/48.33 = 0.199 for Pomona.) Additional questions: a. Of the sampled data, what value is expected? For Pomona, expect an AQI of 48.33. (For Anaheim expect an AQI of 48.5.) b. In general, what value is expected for the population that was sampled? (Asking for μ , which is unknown. So use xbar to estimate μ , xbar ~ μ .) For Pomona, generally expect an AQI of 48.33. (For Anaheim, generally expect an AQI of 48.5.)
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/19/2011 for the course OM 210 taught by Professor Singer during the Spring '08 term at George Mason.

Page1 / 4

HW 4 Exemplar (Prob 3.19) - Exemplar for the Excel Homework...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online