Instructions: Answer each question in two different ways - first by doing the calculations manually and second by using Excel. The solution to each question should include the following: the appropriate calculations (showing all work), the Excel output, and the blanks filled in. The Excel output can either be submitted as an Excel file with each question on a different sheet, or as .pdf files.

The weights of a random sample of containers that are supposed to weigh 100 grams are listed below.

105.2 103.5 98.6 100.3 99.1 97.8 101.2 96.0

The sample statistics are: = 100.213, = 3.025 Can we infer, at the 5% significance level, that the variance of container weights is greater than 7? Assume the required conditions are satisfied.

H0 : _______________________

H1 : _______________________

Conclusion: Reject H0 Do not reject H0

Reason for conclusion: _____________________________________________

Commute times to Central Bank for a random sample of employees (in minutes) are listed below. 21 32 13 19 48 22 7 18 31 56 28 6 16 Estimate with 95% confidence the mean commute time of Central Bank employees.