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

Question:

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.

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: 9780321925121

2nd Edition

Authors: Robert A. Donnelly

See More Books

Question Posted: Jul 17, 2015 03:18 AM

See More Questions

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...
The Excel file titled NBA. xlsx contains frequency distribution of the heights of the players in the National Basketball Association during a recent season. a. Calculate the mean and standard...
The Excel file titled airline performance. xlsx lists the status of 100 flights as either on time or late along with the airline for that flight. a. Construct a contingency table for these data. b....
Water is an essential resource. For that reason moral considerations exert considerable pressure to assure that everyone has access to at least enough water to survive. Yet it appears that equity and...
The American automobile industry is an archetypal oligopoly. Show why this statement is true.
A 10.0 m-long wire of mass 123 g is stretched under a tension of 255N. A pulse is generated at one end, and 20.0ms later a second pulse is generated at the opposite end. Where will the two pulses...
Does your marketing plan involve a marketspace presence for your product or service? If the answer is no, read no further and do not include this element in your plan. If the answer is yes, then...
Can anyone be trained to be a project manager?
Suppose a stock has generated the following annual returns: 11.4%, -7.9% and 5.4%. What was the standard deviation of its returns? Answer in percent, rounded to two decimal places (e.g., 4.32% =...
Let X 1 and X 2 be independent, each with unknown mean and known variance 2 = 1. a. Let 1 = X 1 + X 2 /2. Find the bias, variance, and mean squared error of 1 . b. Let 2 = X 1 + 2X 2 /3. Find...
In an effort to reduce health care costs, many companies are encouraging their employees to walk more. According to the Medicine & Science in Sports & Exercise Journal, Americans take an average of...
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...
Consider the following situations that generate a sequence. a. Write out the first five terms of the sequence. b. Find an explicit formula for the terms of the sequence. c. Find a recurrence relation...
Salmone Company reported the following purchases and sales of its only product. Salmone uses a perpetual inventory system. Determine the cost assigned to the ending inventory using FIFO. 1 Date...
A company may go through organizational change at various stages in its life cycle for a variety of reasons. Reasons can include a change in ownership as well as a change in the competitive...
6 (a) Below is a diagram of a rotating disc viscometer (FIGURE 4). Explain its operations and limitations as to use. If, in a similar works situation, it is necessary to make measurements on a...
As part of your role in the Business Analytics and Data Analytics team, you have been asked to forecast Food Retailing as part of a wider report being commissioned by the above collaboration - on...
You are three students who have together bought a business that makes snow. The customers consist of both large public enterprises and private individuals. The business is run all year round, but the...
Describe the process of valuing the entrepreneurs ownership interest in a two-stage investment. Refer to Tables 13.10 and 13.13. Data from table 13.10 Data from table 13.13 Market potential...
Using a graphing utility, graph y = cot -1 x.
Who is the audit client? Why is it important that the auditor understand who the true audit client is and why that party is the audit client?
Use the Mann-Whitney U test and a = .01 to determine whether there is a significant difference between the populations represented by the two samples given here. Sample 1 Sample 2 573 ..........547...
Use the Wilcoxon matched-pairs signed rank test to determine whether there is a significant difference between the related populations represented by the matched pairs given here. Assume = .05....
Use the Kruskal-Wallis test and a = .01 to determine whether the four groups come from differentpopulations. Group Group 2 Group 3Group 4 13 10 12 10 2 10
Berbice Inc. has a new project, and you were recruitment to perform their sensitivity analysis based on the estimates of done by their engineering department (there are no taxes): Pessimistic Most...
#3) Seven years ago, Crane Corporation issued 20-year bonds that had a $1,000 face value, paid interest annually, and had a coupon rate of 8 percent. If the market rate of interest is 4.0 percent...
I have a portfolio of two stocks. The weights are 60% and 40% respectively, the volatilities are both 20%, while the correlation of returns is 100%. The volatility of my portfolio is A. 4% B. 14.4%...

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

Question:

Step by Step Answer:

a b c d As the sample size increases the sampling error in absolute value of the Excel sampl...View the full answer

Business Statistics

Students also viewed these Statistics questions