# Project #31907 - statistics for Managers Using Microsoft Excel

T1 (Required for 100 points): Assume the height and weight data is population data. Based on this population, construct 10 random samples with 15 students in each random sample (Click on this link to see how to do this in Excel http://www.youtube.com/watch?v=5XrJcFmbpWI). Then calculate the mean height for each of the 10 samples as well as the mean and variance of the 10 sample mean heights. Report your results in the following table.

 Sample1 Sample2 Sample3 Sample4 Sample5 Sample6 Sample7 Sample8 Sample9 Sample10 Student 1 Student 2 Student 3 Student 4 Student 5 Student 6 Student 7 Student 8 Student 9 Student 10 Student 11 Student 12 Student 13 Student 14 Student 15 Sample mean Mean of sample means Variance of sample means

Based on the above results and some additional calculations of the population mean and variance, explain the following:

• What is sampling distribution?
• What is the relationship between the mean of the sample mean heights and population mean height?
• What is the relationship between the variance of the sample mean heights and the population variance of height?

Note: If you don't see the Data Analysis option in your Excel, watch this tutorial

T2 (Optional for 10 bonus points): Each year, newspaper reports how many Americans watched the Super Bowl. Research how that number and the associated margin of error were estimated and explain how accurate you think the estimation was.

 Subject Mathematics Due By (Pacific Time) 06/02/2014 12:00 am
TutorRating
pallavi

Chat Now!

out of 1971 reviews
amosmm

Chat Now!

out of 766 reviews
PhyzKyd

Chat Now!

out of 1164 reviews
rajdeep77

Chat Now!

out of 721 reviews
sctys

Chat Now!

out of 1600 reviews

Chat Now!

out of 770 reviews
topnotcher

Chat Now!

out of 766 reviews
XXXIAO

Chat Now!

out of 680 reviews