ANOVA hypothesis test (using Excel)
Not what you're looking for?
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.
Purchase this Solution
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.
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 ...
Purchase this Solution
Free BrainMass Quizzes
Terms and Definitions for Statistics
This quiz covers basic terms and definitions of statistics.
Know Your Statistical Concepts
Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.
Measures of Central Tendency
This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.
Measures of Central Tendency
Tests knowledge of the three main measures of central tendency, including some simple calculation questions.