The Excel file titled states.xlsx contains the median income in 2017 for all 50 states, the District

Question:

The Excel file titled states.xlsx contains the median income in 2017 for all 50 states, the District of Columbia and Puerto Rico.

a. Use Excel to draw a simple random sample consisting of four states, and then calculate the sampling error for the sample.

b. Use Excel to draw a simple random sample consisting of eight states, and then calculate the sampling error for the sample.

c. Use Excel to draw a simple random sample consisting of 12 states, and then calculate the sampling error for the sample.

d. Compare the sampling error for parts a, b, and c and explain the reason for the differences.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Business Statistics

ISBN: 9780134685267

3rd Edition

Authors: Robert A. Donnelly

Question Posted: