Question

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 4 9 8 3 9 9 2 8 8 3 8 7 4 9 8 2 8 8 Compute the values identified below (to 1 decimal, if necessary). Sum of Squares, Treatment Sum of Squares, Error Mean Squares, Treatment Mean Squares, Error Use = .05 to test for a significant difference in perception among the three groups. Calculate the value of the test statistic (to 2 decimals). The p-value is What is your conclusion? Using = .05, 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 1 - 2 1 - 3 2 - 3

Answer 1

We can use one way ANOVA in Excel to calculated the value of unknown variable.

Anova: Single Factor
SUMMARY
Groups	Count	Sum	Average	Variance
Management	6	18	3	0.8
Research	6	51	8.5	0.3
Advertising	6	48	8	0.4
ANOVA
Source of Variation	SS	df	MS	F	P-value	F crit
Between Groups	111	2	55.5	111	1.02E-09	3.68232
Within Groups	7.5	15	0.5
Total	118.5	17

The p-value is less than 0.05, reject the null hypothesis and concluded that there is a mean difference for marketing.

Test whether there is a significant difference between the means for two variables

If |ybar1-ybar2| >= LSD then you can reject the null hypothesis that the means are the same

Difference	Absolute Value	LSD value	Conclusion
M-R	5.5	0.8701	Reject
M-A	5	0.8701	Reject
R-A	0.5	0.8701	Accept