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 |

Tutor | Rating |
---|---|

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