Chapter 51. Randomized Blocks and Two-Way ANOVA

  • 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 on sales when there ...

Get Microsoft® Office Excel® 2007: Data Analysis and Business Modeling, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.