# Question: The Excel file titled states xlsx contains the median income

The Excel file titled states. xlsx contains the median income in 2011 for all 50 states and the District of Columbia.

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.

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.

**View Solution:**## Answer to relevant Questions

According to the Bureau of Labor Statistics, the average workweek for an adult in the United States in February 2013 was 34.5 hours. Assume the population standard deviation for the number of hours worked per week is 5.0 ...Negative equity is defined as a situation where the mortgage on a property is more than the market value of the property. During the recent financial crisis, market values of most homes declined resulting in an increase in ...The National Center for Health Statistics reported that 34% of Americans were obese recently. The Center for Disease Control estimated that obese people spent an average of $ 1,429 more for medical goods and services than ...The caloric consumption of 32 American adults was measured and found to average 2,157. Assume the population standard deviation is 260 calories per day. Construct confidence intervals to estimate the mean number of calories ...Construct an 80% confidence interval to estimate the population mean when = 125 and σ = 32 for the following sample sizes: a. n = 30 b. n = 60 c. n = 90Post your question