In: Statistics and Probability
The following data are from an experiment designed to investigate the perception of corporate ethical values among individuals who are in marketing. Three groups are considered: management, research and advertising (higher scores indicate higher ethical values).
Marketing Managers | Marketing Research | Advertising |
6 | 7 | 8 |
5 | 7 | 9 |
4 | 6 | 8 |
5 | 6 | 7 |
6 | 7 | 8 |
4 | 6 | 8 |
a. Compute the values identified below (to 2 decimal, if necessary).
Sum of Squares, Treatment | |
Sum of Squares, Error | |
Mean Squares, Treatment | |
Mean Squares, Error |
b. Use to test for a significant difference in perception among the three groups.
Calculate the value of the test statistic (to 2 decimals).
The -value is - Select your answer -less than .01between .01 and .025between .025 and .05between .05 and .10greater than .10Item 6
What is your conclusion?
c. Using , determine where differences between the mean perception scores occur.
Calculate Fisher's LSD value (to 2 decimals).
Test whether there is a significant difference between the means for marketing managers (1), marketing research specialists (2), and advertising specialists (3).
Difference | Absolute Value | Conclusion |
For the given data using Anova single factor in Excel we get output as
Anova: Single Factor | ||||||
SUMMARY | ||||||
Groups | Count | Sum | Average | Variance | ||
Marketing Managers | 6 | 30 | 5 | 0.8 | ||
Marketing Research | 6 | 39 | 6.5 | 0.3 | ||
Advertising | 6 | 48 | 8 | 0.4 | ||
ANOVA | ||||||
Source of Variation | SS | df | MS | F | P-value | F crit |
Between Groups | 27 | 2 | 13.5 | 27 | 1.07E-05 | 3.68232 |
Within Groups | 7.5 | 15 | 0.5 | |||
Total | 34.5 | 17 |
So from the above output