Math Statistics

EXCEL Assignment 2

You are to perform a wide variety of tests on the data and submit the EXCEL workbook containing your work and a WORD document summarizing your results.

1. Conduct the following tests on the data

a. Test whether the variance of SALES equals 4,600,000 at the 95% level.

b. Test whether the variance of SALES is greater than 5,000,000 at the 95% level.

c. Test whether the variance of TEMP is equal to 300 at the 99% level.

d. Test whether the variance of MIN is less than 200 at the 90% level.

2. Conduct the following tests on the data using the following definitions: Winter is December, January and February; Spring is March, April and May; Summer is June, July and August; and Fall is September, October and November.

a. Test whether the variance of SALES in the Winter is the same as the variance of SALES in the Summer.

b. Test whether the variance of SALES in the Winter is the same as the variance of SALES in the Fall.

c. Test whether the variance of SALES in the Winter is the same as the variance of SALES in the Spring.

d. Test whether the variance of SALES in the Spring is the same as the variance of SALES in the Fall.

e. Test whether the variance of TEMP is the same as the variance of MIN.

3. Conduct the following tests on the data

a. Test whether SALES are the same in the Spring and the Fall at the 99% level.

b. Test whether SALES are more than 5,000 higher in Summer than in Winter at the 90% level.

c. Test whether SALES are higher on Weekends in May or Weekends in September at the 95% level.

d. Test whether SALES are higher in Fall than in Spring at the 99% level.

e. Test whether SALES are equal on weekdays and weekends during the Summer at the 95% level.

4. Repeat all the problems in 3. above using ANOVA instead of the direct test.