Chapter 47. Introduction to Multiple Regression

  • 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?

Our factory manufactures three products. How can I predict the cost of running the factory based on the number of units produced?

  • In Chapter 43 through Chapter 45, I described how to use the trend curve in Microsoft Office Excel 2007 to predict one variable (called y, or the dependent variable) ...

Get Microsoft® Office Excel® 2007: Data Analysis and Business Modeling, Second 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.