Chapter 45. Introduction to Multiple Regression

  • A factory produces three products (A, B, and C). How can we predict the cost of running the factory based on knowing the number of units produced?

  • How accurate are our forecasts for predicting monthly cost from 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?

In Chapter 41, Chapter 42, and Chapter 43, I described how to use Excel’s trend curve to predict one variable (called y, or the dependent variable) from another variable (called x, or the independent variable). However, we often want to use more than one independent variable ...

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.