CHAPTER 71 7.4 The Central Limit Theorem 305 The Excel file titled states.xiss c
ID: 3333760 • Letter: C
Question
CHAPTER 71 7.4 The Central Limit Theorem 305 The Excel file titled states.xiss contains the median income in 2008 for all 50 states and the District of Columbia. a) Use Excel to draw a simple random sample 7.5 consisting of 4 states, and then calculate the sampling error for the sample. b) Use Excel to draw a simple random sample consisting of 8 states, and then calculate the sampling error for the sample. Use Excel to draw a simple random sample consisting of 12 states, and then calculate the c) sampling error for the sample. d) Compare the sampling error for parts a, b, and c a explain the reason for the differences. 6 The Excel file titled verizon.xlsx contains daily rev for the past year earned from cell phone accessorie (Bluetooth headsets, memory cards, and so on) so local Verizon retail store in Delaware. a) Use Excel to draw a systematic sample cons 10 days, and then calculate the sampling en sample. lnou a systematic sample coExplanation / Answer
2.8) P(X < 85) = P((x - mean)/(SD/sqrt(n)) < (85 - 80)(15/sqrt(10))
= P(Z < 1.05)
= 0.8531
2.9)P(X > 23) = P(Z > (23 - 24)/(15/sqrt(32))
= P(Z > -0.38)
= 1 - P(Z < -0.38)
= 1 - 0.3520 = 0.648