O'Reilly logo

Microsoft® Excel Data Analysis and Business Modeling by Wayne L. Winston

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required