Chapter 63Randomized 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 own effectiveness, the amount sold by a representative 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 the price and advertising interact significantly?

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

Get Microsoft Excel 2019 Data Analysis and Business Modeling, 6th 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.