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
8	7	10
7	7	11
6	6	10
7	6	9
8	7	10
6	6	10

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). =

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
		- Select your answer
		- Select your answer
		- Select your answer

Answer 1

I am using Excel

Data > Data analysis > Anova single factor > select the data > ok

Anova: Single Factor
SUMMARY
Groups	Count	Sum	Average	Variance
Marketing Managers	6	42	7	0.8
Marketing Research	6	39	6.5	0.3
Advertising	6	60	10	0.4
ANOVA
Source of Variation	SS	df	MS	F	P-value	F crit
Between Groups	43	2	21.5	43	6.14E-07	3.682
Within Groups	7.5	15	0.5
Total	50.5	17

Sum of Squares, Treatment	=43.00
Sum of Squares, Error	=7.50
Mean Squares, Treatment	=21.5
Mean Squares, Error	= 0.5

========================================

b) Test - stats = 43.00

========================================