Chapter 59 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 the monthly cost, based on the 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 Chapters 56 through 58, I described how to use the trend curve in ...

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.