O'Reilly logo

Microsoft® Excel® 2010: Data Analysis and Business Modeling by Wayne L. Winston

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 57. Randomized Blocks and Two-Way ANOVA

Questions answered in this chapter:

  • I am trying to analyze the effectiveness of my sales force. The problem is that in addition to a sales representative’s effectiveness, the amount that a representative sells depends on the district to which he or she is assigned. How can I incorporate the district assignments of my representatives into my analysis?

  • Based on my knowledge of sales representatives and districts, how can I forecast sales? How accurate are my sales forecasts?

  • How can I determine whether varying the price and the amount of advertising affects the sales of a video game? How can I determine whether price and advertising interact significantly?

  • How can I interpret the effects of price and advertising ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required