Microsoft® Excel® 2010: Data Analysis and Business Modeling

Chapter 56. Analysis of Variance: One-Way ANOVA

Questions answered in this chapter:

• The owner of my company, which publishes computer books, wants to know whether the position of our books in the computer book section of bookstores influences sales. More specifically, does it really matter whether the books are placed in the front, back, or middle of the computer book section?

• If I am determining whether populations have significantly different means, why is the technique called analysis of variance?

• How can I use the results of one-way ANOVA for forecasting?

Data analysts often have data about several different groups of people or items and want to determine whether the data about the groups differs significantly. Here are some examples:

• Is there ...