O'Reilly logo

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

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