Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Simple random sampling in excel

27/11/2021 Client: muhammad11 Deadline: 2 Day

The file P02_07.xlsx includes data on 204 employees at the (fictional) company Beta Technologies. For this problem, consider this data set as the population frame.

a. Using the method in this section (not StatTools), generate a simple random sample of size 20 from this population.

b. Use StatTools to generate 10 simple random samples of size 20 from this population.

c. Calculate the population mean, median, and standard deviation of Annual Salary. Then calculate the sample mean, median, and standard deviation of Annual Salary for each of the samples in parts a and b. Comment briefly on how they compare to each other and the population measures.

The file P07_02.xlsx contains data on the 1995 students who have gone through the MBA program at State University. You can consider this the population of State University’s MBA students.

a. Find the mean and standard deviation for each of the numerical variables in this population. Also, find the following proportions: the proportion of students who are male, the proportion of students who are international (not from the USA), the proportion of students under 30 years of age, and the proportion of students with an engineering undergrad major.

b. Using the method in this section (not StatTools), generate a simple random sample of 100 students from this population, and find the mean and standard deviation of each numerical variable in the sample. Is there any way to know (without the information in part a) whether your summary measures for the sample are lower or higher than the (supposedly unknown) population summary measures?

c. c. Use StatTools to generate 10 simple random samples of size 100. For each, find the mean of School Debt and its deviation from the population mean in part a (negative if it is below the population mean, positive if it is above the population mean). What is the average of these 10 deviations? What would you expect it to be?

d. d. We want random samples to be representative of the population in terms of various demographics. For each of the samples in part c, find each of the proportions requested in part a. Do these samples appear to be representative of the population in terms of age, gender, nationality, and undergrad major? Why or why not? If they are not representative, is it because there is something wrong with the sampling procedure?

A manufacturing company’s quality control personnel have recorded the proportion of defective items for each of 500 monthly shipments of one of the computer components that the company produces. The data are in the file P07_07.xlsx. The quality control department manager does not have sufficient time to review all of these data. Rather, she would like to examine the proportions of defective items for a sample of these shipments. For this problem, you can assume that the population is the data from the 500 shipments.

a. Use Excel to generate a simple random sample of size 25 from the data.

b. Calculate a point estimate of the population mean from the sample selected in part a. What is the sampling error, that is, by how much does the sample mean differ from the population mean?

c. Calculate a good approximation for the standard error of the mean.

d. Repeat parts b and c after generating a simple random sample of size 50 from the population. Is this estimate bound to be more accurate than the one in part b? Is its standard error bound to be smaller than the one in part c?

The manager of a local fast-food restaurant is interested in improving the service provided to customers who use the restaurant’s drive-up window. As a first step in this process, the manager asks his assistant to record the time it takes to serve a large number of customers at the final window in the facility’s drive-up system. The results are in the file P07_08.xlsx, which consists of nearly 1200 service times. For this problem, you can assume that the population is the data in this file.

A. Use Excel to generate a simple random sample of size 30 from the data.

b. Calculate a point estimate of the population mean from the sample selected in part a. What is the sampling error, that is, by how much does the sample mean differ from the population mean?

c. Calculate a good approximation for the standard error of the mean.

d. If you wanted to halve the standard error from part c, what approximate sample size would you need? Why is this only approximate?

Calculate the following probabilities using Excel. (If you have Excel 2010 or later, we suggest using its new functions.)

a. P(t10 ≥ 1.75), where t10 has a t distribution with 10 degrees of freedom.

b. P(t100 ≥ 1.75), where t100 has a t distribution with 100 degrees of freedom. How do you explain the difference between this result and the one obtained in part a?

c. P(Z ≥ 1.75), where Z is a standard normal random variable. Compare this result to the results obtained in parts a and b. How do you explain the differences in these probabilities?

d. P(t20 ≤ −0.80), where t20 has a t distribution with 20 degrees of freedom.

e. P(t3 ≤ −0.80), where t3 has a t distribution with 3 degrees of freedom. How do you explain the difference between this result and the result obtained in part d?

The file P08_05.xlsx contains salary data on all NFL players in each of the years 2002 to 2009. Because this file contains all players for each of these years, you can calculate the population mean for each year if population is defined as all NFL players that year. However, proceed as in the previous chapter to select a random sample of size 50 from the 2009 popula- tion. Based on this random sample, calculate a 95% confidence interval for the mean NFL total salary in 2009. Does it contain the population mean? Repeat this procedure several times until you find a random sample where the population mean is not included in the confidence interval.

The manager of a local fast-food restaurant is inter- ested in improving the service provided to customers who use the restaurant’s drive-up window. As a first step in this process, the manager asks an assistant to record the time (in seconds) it takes to serve a large number of customers at the final window in the facil- ity’s drive-up system. The file P08_07.xlsx contains a random sample of 200 service times during the busiest hour of the day.

a. Identify the relevant population.

b. Construct and interpret a 95% confidence interval for the mean service time of all customers arriving during the busiest hour of the day at this fast-food operation.

c. If the manager wants to improve service, at least during the busiest time of day, does this confidence interval provide useful information? What useful information does it not provide?

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Top Grade Essay
Accounting & Finance Specialist
Finance Professor
Essay & Assignment Help
Online Assignment Help
Smart Accountants
Writer Writer Name Offer Chat
Top Grade Essay

ONLINE

Top Grade Essay

I have read your project description carefully and you will get plagiarism free writing according to your requirements. Thank You

$27 Chat With Writer
Accounting & Finance Specialist

ONLINE

Accounting & Finance Specialist

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$28 Chat With Writer
Finance Professor

ONLINE

Finance Professor

I will provide you with the well organized and well research papers from different primary and secondary sources will write the content that will support your points.

$35 Chat With Writer
Essay & Assignment Help

ONLINE

Essay & Assignment Help

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$45 Chat With Writer
Online Assignment Help

ONLINE

Online Assignment Help

I can assist you in plagiarism free writing as I have already done several related projects of writing. I have a master qualification with 5 years’ experience in; Essay Writing, Case Study Writing, Report Writing.

$43 Chat With Writer
Smart Accountants

ONLINE

Smart Accountants

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$45 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Nucblue live cell stain readyprobes reagent - Temple physics lab - Urgent engineering - A clothier makes coats and slacks - Empirical formula of oxalic acid - Hagesandros polydoros and athanadoros - Www projectmanagementdocs com human resources - Manual Code Review - Daynes and farris 2003 - Life cycle of starbucks company - Pelion mass effect 3 - Example of certainty in decision making - Unit 3 Discussion #5 Washington & DuBois or Wells - Comparison essay - Bus 599 peregrine exam - The extraordinary leader zenger folkman pdf - Press release - Beats by dre swot analysis - Electrical signs and symbols - Boneless ocean animal with testicles - Superman versus the ku klux klan sparknotes - Research Paper - Head heart lydia davis poem analysis - K3 fe c2o4 3 3h2o - Braveheart freedom speech analysis - Michael of juno 2007 crossword - Communicating at work 11th edition pdf download - Nitrogen trihydride lewis dot structure - Which of the following statements is true regarding gainsharing - Ps4 upload error ce 39896 5 - Organisational learning and change - Consider an air solar collector that is wide - Wk kellogg foundation evaluation handbook - Biology photosynthesis absorption spectrum for chlorophyll worksheet answers - Socio - Big skinny case study - What element makes protein different from carbohydrate and fat - Diablo 2 spider cavern location - The y intercept b0 represents the - Role of access control in protecting data privacy - Small essay - Nbn multi dwelling units - Http www homeschoolshare com lapbook templates php - Power in Relationships - Disadvantages of selective breeding - Fiction essay engl 102 - O yo no voy al viaje. o me compro unos zapatos. - Wisely and slowly they stumble that run fast - Does tantoo cardinal have a cleft palate - Grow a boyfriend kmart - Rise of Progressivism Discussion - Pro rata fee ignou - Hobbies lesson plan intermediate - Disadvantages of keeping animals in captivity - Heymann company bonds have 4 years left to maturity - Human Resource Management - Matlab state space simulation - Electrical engineering unsw handbook - Benchmark assignment business plan presentation - Dikw in nursing informatics - Let the frame of things disjoint - My safety commitment examples - Wgu c170 donut shop - Pricing strategy of coca cola company - The money demand curve has a negative slope because - Scientific method virtual lab middle school - Aj brown griffith university - Apa reference porth pathophysiology 9th edition - Analyzing managerial decisions bagby copy company - Math homework Online - Human capital case study practice - Ferrite rod antenna theory - Anthony kiedis personality type - Global Logistics and Supply Chain Management, case study Quastions.. - Specific Language Impairment - 107d8fr - In argumentation, criticism is __________. - What should be included in disaster planning for a large employer in Annapolis, Maryland, that is concerned about natural disasters such as floods and snowstorms that might shut down the company and parts of the city? - The global security policy cmgt 400 - Need assignment - Informative Outline - How is the non disposable razor market segmented - Toothpaste and toothbrushes are substitute goods. - Multiplication rule of probability matching worksheet answer key - East leake academy uniform - Business and society 15th edition pdf - School by kyoko mori questions and answers - Which of the following labels did columbia revive in the 1950s to explore new r&b markets? - Examples of critical analysis - American jerk by todd schwartz - Social identity theory in group out group - Situational leadership theory pros and cons - Zappos ethical challenges - Canvas sussex county community college - Think like a freak summary sparknotes - Week 2: Discussion: Data Visualization Workflow - Four Key Stages - Responsibility accounting and transfer pricing ppt - Followership and servant leadership compare and contrast army - Electrical separation shaver socket diagram - Assessing Client Families