Question: Download the Excel file A1Q1.xlsx from Moodle. The spreadsheet contains 30 randomly generated numbers.

1. Use the descriptive statistics feature in Excel to calculate the descriptive statistic. Attach the Excel output. (3 marks)
2. Construct a 95-percent confidence interval for the population variance and the population mean. (4 marks)
3. At the 90-percent level of confidence, test whether the population variance equals 25. Carefully state the null and alternative hypotheses, calculate the appropriate test statistic, state the appropriate critical value and explain your decision. (4 marks)
4. At the 99-percent level of confidence, test whether the population mean equals zero. Carefully state the null and alternative hypotheses, calculate the appropriate test statistic, state the appropriate critical value and explain your decision. (4 marks)

Price: $2.99

Solution: The downloadable solution consists of 4 pages
Deliverable: Word Document