Hi! My group and I are doing a Business Statistics course, and we're pretty new at Microsoft Excel, so we're hoping we'll be able to get some help here!
Microsoft Excel 2007.
Question: Develop a 95% confidence interval estimate of the mean assets for the population of money market funds (the data is on investment services).
This bell curve is what we have done so far:
We're trying to show these interval estimates
<table style="border-collapse: collapse; width: 188pt;" border="0" cellpadding="0" cellspacing="0" width="251"><col style="width: 125pt;" width="167"> <col style="width: 63pt;" width="84"> <tbody><tr style="height: 15.75pt;" height="21"> <td class="xl64" style="height: 15.75pt; width: 125pt;" height="21" width="167">Lower Limit</td> <td class="xl63" style="width: 63pt;" align="right" width="84">599.55927</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl64" style="height: 15.75pt;" height="21">Upper Limit</td> <td class="xl63" align="right">3390.0585</td> </tr> </tbody></table>
in the diagram above. How can it be done?
Thanks
Microsoft Excel 2007.
Question: Develop a 95% confidence interval estimate of the mean assets for the population of money market funds (the data is on investment services).
We're trying to show these interval estimates
<table style="border-collapse: collapse; width: 188pt;" border="0" cellpadding="0" cellspacing="0" width="251"><col style="width: 125pt;" width="167"> <col style="width: 63pt;" width="84"> <tbody><tr style="height: 15.75pt;" height="21"> <td class="xl64" style="height: 15.75pt; width: 125pt;" height="21" width="167">Lower Limit</td> <td class="xl63" style="width: 63pt;" align="right" width="84">599.55927</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl64" style="height: 15.75pt;" height="21">Upper Limit</td> <td class="xl63" align="right">3390.0585</td> </tr> </tbody></table>
in the diagram above. How can it be done?
Thanks