# Question: The file P07 02 xlsx contains data on the 1995 students who

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. 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. 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. 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. 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. 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?

**View Solution:**## Answer to relevant Questions

The file P02_35.xlsx contains data from a survey of 500 randomly selected households.a. Suppose you decide to generate a systematic random sample of size 25 from this population of data. How many such samples are there? What ...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 file DVD Movies.xlsx contains a large data set of 10,000 customer transactions for a fictional chain of video stores in the United States. Each row corresponds to a different customer and lists (1) A customer ID number ...Continuing Problem 5, generate a random sample of 50 players for each of the eight years in the P08_05.xlsx file. For each of these samples, construct a 95% confidence interval for the mean total salary for that year. What ...Starting with the data from problem 17 in the file P08_17.xlsx, restructure the data so that you have a table of counts. Then use StatTools on the counts to answer the same questions as in problem 17.Post your question