Project #15959 - Statistics 2

Use the attached spreadsheet to complete the questions.

 

1. Use the file by selecting one hundred samples of thirty waiting times

 

a. Calculate the exact 95 percent upper and lower confidencr limits for each sample

 

b. Use the =AND statement to determine whether the confidence limits for each sample contain true population mean.   (ex. =And(upper limit>mu,lower limit<mu)

 

c. Use =Countif to determine whether the proportion of samples of the one hundred actually contains the true mean of the population within the 95 percent limits

 

d. Can you account for the result you got in (C)?

 

Attached is the spreadsheet.

 

Please use an excel spreadsheet to complete and show work. Thanks!

Subject Mathematics
Due By (Pacific Time) 11/03/2013 04:00 pm
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