Chapter 49. 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 salesperson’s effectiveness, the amount that a salesperson sells depends on the district to which he or she is assigned. How can I incorporate the district assignments of my sales-people into my analysis?

  • Based on a knowledge of sales rep and district, 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 is a significant interaction ...

Get Microsoft® Excel Data Analysis and Business Modeling 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.