Test whether the variance of SALES equals 4,600,000 at the 95% level, excel assignment help

This assignment uses the same data that was used in assignment 1. A due date for the assignment will be determined shortly and announced in class. 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
    1. Test whether the variance of SALES equals 4,600,000 at the 95% level.
    2. Test whether the variance of SALES is greater than 5,000,000 at the 95% level.
    3. Test whether the variance of TEMP is equal to 300 at the 99% level.
    4. 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.
    1. Test whether the variance of SALES is the same in Winter and Summer.
    2. Test whether the variance of SALES is the same in Winter and Fall.
    3. Test whether the variance of SALES is the same in Winter and Spring.
    4. Test whether the variance of SALES is the same in Spring and Fall.
    5. Test whether the variance of TEMP is the same as the variance of MIN.
  3. Conduct the following tests on the data
    1. Test whether SALES are the same in the Spring and the Fall at the 99% level.
    2. Test whether SALES are more than 5,000 higher in Summer than in Winter at the 90% level.
    3. Test whether SALES are higher on Weekends in May or Weekends in September at the 95% level.
    4. Test whether SALES are higher in Fall than in Spring at the 99% level.
    5. 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. Point out any differences.
  5. Create a frequency distribution of the temperature variable from the first assignment – use decile temperatures (30-39, 40-49, etc) for grouping the data. Answer the following questions using Chi-Squared tests.
    1. Do you believe that the data are distributed uniformly on [30,100]? (HINT: This would mean the same number of observations in each temperature block).
    2. Do you believe that the data are distributed normally? (HINT: You will need to create a standard normal equivalent using mean and standard deviation from assignment 1 and create probabilities for all of the endpoints of the data blocks to find the expected frequencies).
  6. Create a frequency distribution for the sales variable from the fist assignment – use $1,000 increments ($0-$999.99, $1,000-$1,999.99, etc). Answer the following questions using Chi-Squared tests.
    1. Do you believe that the data are distributed uniformly on [1,000; 10,000]?
    2. Do you believe that the data are normally distributed?
  7. What assumptions were needed to perform the tests in 1.-4.? Perform the tests in 1-4 again using a test that makes no (or minimal) assumptions. Describe the test and contrast the results from this test with the tests in 1.-4.
  8. What assumptions were needed to perform the tests in 5.-6.? Perform the tests in 5.-6. again using a test that makes no (or minimal) assumptions. Describe the test and contrast the results from this test with the tests in 5.-6.