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
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy