Basic Marketing Research with Excel 3rd Edition by Alvin Burns,Ronald Bush

Exercise 5

A marketing manager of a Web-based catalog sales company uses a segmentation scheme based on the incomes of target customers. The segmentation system has four segments:
(1) low income,
(2) moderate income,
(3) high income, and
(4) wealthy.
The company database holds information on every customer's purchases over the past several years, and the total dollars spent is one of the prominent variables. The marketing manager finds that the average total dollar purchases for the four groups are as follows:
Construct a table that is based on how the XL Data Analyst presents its findings for ANOVA that illustrates that the low-and moderate-income groups are not different from each other, but the other groups are significantly different from one another.