HW 4 Exemplar (Prob 3.19)

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

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
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.)
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

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 Right Arrow Icon
Ask a homework question - tutors are online