Share
Explore BrainMass

ANOVA hypothesis test (using Excel)

INSTRUCTIONS:
Include a "summary statement" for each hypothesis test, one for the ANOVA hypothesis test, and another "summary statement" for the multiple comparison results when the ANOVA null hypothesis is rejected.

FACTS:
A company sells identical soap in four different packages at the same price. The sales for each package type for 12 months are provided in the file P12_8.XLS.

PROBLEM:
Is there any indication of differences in the main sales of this brand of soap across the various package types? Using excel - perform an appropriate statistical test and report a p - value.

Attachments

Solution Preview

A company sells identical soap in four different packages at the same price. The sales for each package type for 12 months are provide in the following table.

Package type 1 Package type 2 Package type 3 Package type 4
5014 5044 4944 4848
4880 5095 5029 5165
4877 5106 4914 4934
4879 5053 5087 4929
4868 5047 4887 4925
5226 5049 4992 5085
4871 4946 4897 5053
4963 4897 4975 5070
5097 4955 5183 5131
5089 4895 4953 4723
4957 5117 4960 4853
4900 5061 4942 4963

Summary (1):

Now we conduct ANOVA at a 0.05 significance level to test, if there is a difference in the mean sales of the four ...

Solution Summary

The experts uses ANOVA hypothesis tests to indicate any differences in the main sales of the brand of soap across the various package types.

$2.19