The following data are from an experiment designed to investigate the perception

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

Explanation / Answer

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

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

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

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.