Chapter 53. Introduction to Multiple Regression

Questions answered in this chapter:

  • Our factory manufactures three products. How can I predict the cost of running the factory based on the number of units produced?

  • How accurate are my forecasts for predicting monthly cost based on units produced?

  • I know how to use the Data Analysis command to run a multiple regression. Is there a way to run the regression without using this command and place the regression’s results in the same worksheet as the data?

Answers to This Chapter’s Questions

Our factory manufactures three products. How can I predict the cost of running the factory based on the number of units produced?

In Chapter 49 through Chapter 51, I described how to use the trend curve in Microsoft Excel ...

Get Microsoft® Excel® 2010: 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.