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

Aat level 3 syllabus - Discuss: Why is it critical for company managers to have a clear strategic vision regarding their organization? - Adulterants in sugar pdf - Top 100 companies in nigeria 2019 - Cre form 3 questions and answers - 1300 word review. split into 300, 300, 300, then 400 (no more than 400 on the last part) based on YOUR KIDS AT RISK 2007 BY MEEKER - Bigger biceps athlean x - Engineering in the water environment good practice guide - Star river electronics case solution - How to calculate biorhythms by hand - SMGT 501 - Forum Discussion 3 - Pr 6 2b lifo perpetual inventory - Jean watson caring theory in practice - Cisco asa logging timestamp - Data driven graphic design pdf - Paper - Brain games pay attention answers - Is Affordable Assignment Help Worth It? - Week 3 Assignment- data mining - Middle english pronunciation guide - Cwa cauliflower pickle recipe - Case study - Nicks fish and chips wodonga - Shadow health musculoskeletal transcript - Cuyahoga valley christian academy - City of everett washington v mitchell - Jason benjamin twin falls - Bbc talk french videos - Does capacity only measure liquid - Right sided ecg placement - Trial 1 meiotic division without crossing over pipe cleaners diagram - Insert a function in cell h5 to display the amount of down payment for the first client. - 100 point vehicle inspection checklist pdf - Christ as good shepherd mausoleum of galla placidia - Film review - Joey graceffa fantasy craft ep 18 - Experiment 1: effects of ph on radish seed germination - Markel technical communication 11th edition pdf - Carol gilligan pointed out that existing studies on moral development are biased because - Cultural diverdity - Neobehaviorists - English Comp 2 week 9 - Asc 605 45 revenue recognition principal agent considerations - Chapter 1 homework financial accounting - Common, perpectual,nuerologic, or cognitive issue - Heart rate response nasm - Budget & Stress for Police Officers - A Raisin in the Sun Structuralism Project - Welding symbols australian standard - Medicare item number 00023 - How to make a bindi dot - Cpap in neonates ppt - Theory Critique - Selected currently preferred) specialty and second-preferred specialty - Graduate Education Assistance - Sounds of the day norman maccaig analysis - Is 59 a prime or composite number - How to bake a cake speech - A0 width and height - Fiberglass reinforced epoxy conduit - Performance Improvement Plan - Seven steps to writing success - Tourism ESSAY + POSTER - 132 148 124 2000 login mobilemis - Echtgeld online Casino Spiele – welche Vorteile haben Sie? - Managing employee benefits ppt - Single pickup wiring diagram - Cigarette lighter without fluid - Use case diagram game project - Calculate the cost of equity using the dcf method - Nrma accident report form - Mental planet annihilating rhythm - A clean well lighted place thesis - Kingsgate student lock in - Act 5 scene 1 othello - Matlab state space simulation - Contemporary literature - Classical argument position paper - Hours per patient day formula - A 2.5 cm diameter horizontal water jet - Darling v charleston community memorial hospital - Statue of poseidon neptune alongside dolphin - Panic disorder severity scale - Microeconomics HW - Crystal structure ppt presentation - Communication - Medieval social system crossword - Operation anaconda analytical essay - E lucevan le stelle testo canzone - Where are mars factories located - Active file recovery ultimate - Principle of anticipation real estate - Maximum data rate of a channel - Sap ariba procurement training - In pdm which of the following relationships is rarely used - Qlik sense exclude values from dimension - Naidoc week 2015 theme - Sustainability and Natural resources - Essentials of business communication 9th edition pdf chapter 2 - Summary and Descriptive Statistics