Due Thursday, November 8, 2001 (beginning of lecture)

**Downloads Required:**

Complete the following:Templates1.xls

1. Use the appropriate functions in Excel to solve problem 5-48 on Page 212 of your text.

2. Use the appropriate functions in Excel to solve
problem 5-57 on Page 213 of your text.

*For problems 3-5 download the Templates1.xls
file from the course web site and use the appropriate sheet to perform
the calculations for the following:*

3. Complete Problem 7-18 (a) on Page 273 of your text. Repeat the exercise (Part a only) using 95% confidence and compare your results. The file ECCO must be retrieved from the CD-ROM.

4. Use the standard deviation from #3 above as a pilot study estimate of the population standard deviation and complete Problem 7-28 (a) and (b) on Page 278 of your text.

5. Complete Problem 8-60 (a) on Page 326.
Repeat the exercise (Part a only) using a significance level of 0.01.
How does using a significance level of 0.01 impact your decision?

Notes:

- Data is also contained on the CD-ROM provided with your textbook.
- The Excel template file must be downloaded from this page.
- All output is to be produced in Excel.
- Interpretations or explanations may be handwritten on the output directly from Excel
- Results may be pasted into a word processor (e.g. MS Word) and explanations may be typed.
- All output must be generated independently, however, you may help one another to get started.
- All “write-ups” must be your own work.