Question;2. 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 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. Use StatTools to generate 10 simple random sames 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. We want random samples to be representative of the population in terns of various demographics. For each of the samples in part c, find each of the proportions requested n part a. Do these samples appear to be representative of the population 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?8. 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 miss 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?
Paper#61618 | Written in 18-Jul-2015Price : $27