Developing a multiple regression model

In the previous movies in this chapter, I showed you how to have Excel use…linear regression to derive an equation used to project future values, and to…estimate how much of the value's variance was due to the data in your samples.…In this movie, I'll show you how to perform a similar analysis for multiple factors.…This technique is called multiple regression.…When you create your source data table, you need to have two regressors, and…those are the independent variables you want to use in the Regression formula to…derive the dependent variable.…Your two regressors--in this case Impressions, which is the number of times an…individual sees one of your company's ads, and Proximity which is the distance…in miles that a person lives from your store--…we want to see how these two factors when working together relate to the revenue…that you generate, or in other words the amount that you sold them.…

To perform multiple regression analysis, you use the Data Analysis tool, and…that is on the Data tab in the Analysis Group.…