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

Week 1 question - Hyundai imax luggage space - What is a research framework. Write a 250 words APA format paper that explains your understanding. - Business - Maximum power transfer theorem - Environmental certification and sustainability - Management accounting exercises and solutions - Shaver manufacturing inc offers dental insurance to its employees - Apprehend harley quinn electric water - 3 reasons why college still matters - Operations Management Case Analysis and Excel - Classical liberalism focuses on the protection of - Blum minipress parts diagram - Commonlit the lost generation assessment answers - Material mix variance problems and solutions - Bloomberg foreign exchange cross rates - Essay - Hyundai iload leaf springs - Madam cj walker newspaper articles - Assignment - Management of Projects - E3 8 adjusting entries - Closing prayer after meeting - Right hand rule positive or negative - Louis sachar family tree - Each spot on the dna microarray in embedded with - Guinea bissau country code - Assignment 3 - Worksafe early intervention physiotherapy fee schedule - Latitude and longitude worksheets - Bargaining power of buyers netflix - Temperature in bacchus marsh - Issues and concerns about the use of portable devices - You have observed the following returns over time - External governance control mechanisms include - Configure chap authentication on s0 0 0 - Core concepts 3.3 word wise - Byte of accounting inc answers - Cylinder to cube strength - Galvanizing association of australia - Acas code of practice disciplinary - What objects tell the story of your life - What does poh measure - 488.0 nm wavelength of an argon laser - Configure ip address in packet tracer - Dissertation 2 - EH Week 3 p3 - An interesting person i know essay - Business Intellegence - Business & Society Discussion - Order # 9676 - How many orbitals are there in the seventh shell - First angle of projection - Experiment to determine the percentage of copper in brass - Mid fife local plan - Find an initial solution to the following transportation problem - Holts car paint stockists - EVIDENCE MIDTERM- STRICT DEADLINE - What happens if you drink from the river styx - Aunt martha incidents in the life of a slave girl - Master Dissertation - NURS340REPLY - CLA2 - CLO 1, CLO 2, CLO 3, CLO 4, CLO 5 - Knox shopping centre redevelopment - Barnsley federation of racing pigeons - What is “FOOTPRINTING” (or digital reconnaissance) is and how you would go about gathering the information you need to determine the location of a recently stolen late model car that was last seen in the parking lot of our college. - El doctor salinas caer radiografías - Avaya one x agent stuck on connecting - BPSC 021 - Fall 2020 - The news apply to the product desgin process and development tradeoff - Digestive system animation game - Sci 207 week 3 lab - Is the practice of tailoring products and marketing programs - Starbucks 10-K report - What best describes the underlined part of this sentence - To become more skilled at interpreting meanings associate with nonverbal communication, describe what your boss may communicate to you if they are reading texts and emails during an organizational meeting or in a one-on-one conversation. - Vba split system licence - Rifle company butterworth medal - It was an extraordinary gift for hope a romantic readiness - Popov v hayashi video - How many times has 3ds transformed industry - Philip chambon swansong music - Ato gov au fueltaxcreditcalculator - 25 magpie trail crawfordville fl - Dofoodsafely health vic gov au - A long walk to water chapter 2 - All the world's a stage theme - Narrative - Management skills audit template - Beer segmentation analysis - Encase manual - Comparing sculptures of ancient india and greece - Assessment of psychomotor domain of learning outcomes - Blizzard blinding white copy paper - How do the majority of potential customers find business websites - Transition to Adulthood - Chapter 17 preventative maintenance and service procedures - Cumberland infirmary consultant list - Roles of project manager - Christianity - world view