Chapter 51
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?
Chapters 47–49 described how to use the trend curve in Microsoft Excel ...
Get Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th 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.