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:
Answer rating: 66% (6 reviews)
One example a b c d As the sample size increases the sampling error in absolute value of the ...View the full answer
Answered By
Ashington Waweru
I am a lecturer, research writer and also a qualified financial analyst and accountant. I am qualified and articulate in many disciplines including English, Accounting, Finance, Quantitative spreadsheet analysis, Economics, and Statistics. I am an expert with sixteen years of experience in online industry-related work. I have a master's in business administration and a bachelor’s degree in education, accounting, and economics options.
I am a writer and proofreading expert with sixteen years of experience in online writing, proofreading, and text editing. I have vast knowledge and experience in writing techniques and styles such as APA, ASA, MLA, Chicago, Turabian, IEEE, and many others.
I am also an online blogger and research writer with sixteen years of writing and proofreading articles and reports. I have written many scripts and articles for blogs, and I also specialize in search engine
I have sixteen years of experience in Excel data entry, Excel data analysis, R-studio quantitative analysis, SPSS quantitative analysis, research writing, and proofreading articles and reports. I will deliver the highest quality online and offline Excel, R, SPSS, and other spreadsheet solutions within your operational deadlines. I have also compiled many original Excel quantitative and text spreadsheets which solve client’s problems in my research writing career.
I have extensive enterprise resource planning accounting, financial modeling, financial reporting, and company analysis: customer relationship management, enterprise resource planning, financial accounting projects, and corporate finance.
I am articulate in psychology, engineering, nursing, counseling, project management, accounting, finance, quantitative spreadsheet analysis, statistical and economic analysis, among many other industry fields and academic disciplines. I work to solve problems and provide accurate and credible solutions and research reports in all industries in the global economy.
I have taught and conducted masters and Ph.D. thesis research for specialists in Quantitative finance, Financial Accounting, Actuarial science, Macroeconomics, Microeconomics, Risk Management, Managerial Economics, Engineering Economics, Financial economics, Taxation and many other disciplines including water engineering, psychology, e-commerce, mechanical engineering, leadership and many others.
I have developed many courses on online websites like Teachable and Thinkific. I also developed an accounting reporting automation software project for Utafiti sacco located at ILRI Uthiru Kenya when I was working there in year 2001.
I am a mature, self-motivated worker who delivers high-quality, on-time reports which solve client’s problems accurately.
I have written many academic and professional industry research papers and tutored many clients from college to university undergraduate, master's and Ph.D. students, and corporate professionals. I anticipate your hiring me.
I know I will deliver the highest quality work you will find anywhere to award me your project work. Please note that I am looking for a long-term work relationship with you. I look forward to you delivering the best service to you.
3.00+
2+ Reviews
10+ Question Solved
Related Book For
Question Posted:
Students also viewed these Mathematics questions
-
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...
-
The Excel file titled gasoline prices.xlsx lists the average monthly price per gallon of regular gasoline in the United States from August 1990 to January 2013 from the U.S. Energy Information...
-
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....
-
Consider a two-stage compression refrigeration system operating between the pressure limits of 0.8 and 0.14 MPa. The working fluid is refrigerant-134a. The refrigerant leaves the condenser as a...
-
Refer to Example 5-13. Create a single spreadsheet that calculates PW, FW, AW, IRR, and ERR for the proposed investment. Assume that = MARR = 20% per year. Does your recommendation change if the...
-
Suppose a sample yields estimates \(\widehat{\theta}_{1}=5, \widehat{\theta}_{2}=3\), se \(\left[\widehat{\theta}_{1} ight]=2\), and se \(\left[\widehat{\theta}_{2} ight]=1\) and the correlation...
-
Revenue Recognition and Matching} Securit performs security services for local businesses. During 2018, Securit performed \(\$ 915,700\) of security services and collected \(\$ 930,000\) cash from...
-
Spielberg Companys general ledger shows a checking account balance of $22,970 on July 31, 2015. The July cash receipts of $1,885, included in the general ledger balance, are placed in the night...
-
Uptown Construction is comparing two different capital structures. Plan I would result in 16,000 shares of stock and $160,000 in debt. Plan II would result in 18,000 shares of stock and $110,000 in...
-
Measurements are made on the length and width (in cm) of a rectangular component. Because of measurement error, the measurements are random variables. Let X denote the length measurement and let Y...
-
The average number of days a house was on the market in Austin, Texas, in 2018 was 61 days (realyaustin. com). Assume the time on the market follows an exponential probability distribution. a. What...
-
According to the National Association of Theater Owners, the average price for a movie in the United States in 2017 was $8.97. Assume the population standard deviation is $0.50 and that a sample of...
-
Use the information provided in BE12-7. Assume that the fair value of the division is estimated to be $750,000 and the implied goodwill is $350,000. Prepare Waters journal entry, if necessary, to...
-
How does the espoused values versus enacted values dichotomy within organizational culture impact employee perceptions, behaviors, and organizational outcomes ?
-
How does each factor in PESTEL affect Airbnb's new service Airbnb trips entry into the market?
-
What type of parenting approach (portfolio, synergy, or development) can better explain and help understand what Alphabet is doing? Why
-
What process requires the company to set specific goals that both the employee and employer agreed upon, and therefore employees know what is expected of them?
-
It is important to note that different banks may have unique strategies and approaches when it comes to logistics and customer accommodation. It would be beneficial to conduct further research and...
-
What are two types of mobile biometrics?
-
Suppose that the electrical potential at the point (x, y, z) is E(x, y, z) = x + y - 2z. What is the direction of the acceleration at the point (1,3,2)?
-
A grocery store has 18 two liter bottles of diet cola on the shelf, four of which have exceeded their shelf life date. You randomly select three bottles of diet cola without checking the expiration...
-
The following table shows the discrete probability distribution for the number of bedrooms per house in a certain community: Number of Bedrooms Probability 3 0.23 4 0.57 5 0.14 6 0.06 a....
-
An IRS agent has 19 tax returns on her desk, of which 14 were filed using the short form (1040A). She randomly chooses eight returns to audit. Determine the probability of the following: a. All eight...
-
Exercise 9 - 9 ( Static ) Prepare a Report Showing Revenue and Spending Variances [ LO 9 - 2 ] Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near...
-
Market research conducted by Kauai Ltd revealed great potential for a new energy drink. To produce the product would require R 1 1 0 0 0 0 0 in new equipment. The equipment is expected to have a...
-
Penelope was recruited to serve as the Chief Human Resources Officer (CHRO) of Epsilon Corporation, a privately-held company in the automotive industry, effective June 1, 2022. Throughout the fiscal...
Study smarter with the SolutionInn App