This preview shows page 1. Sign up to view the full content.
Unformatted text preview: b n = Variable cost per unit of driver n X n = Number of units of driver n To analyze the effectiveness of the model, we examine the Adjusted R-square measure rather than R-square measure b) Performing multiple regression analysis The steps to perform a regression analysis are the same as for simple regression except as follows: o All of the X variables must be in contiguous columns o A scatter-graph is not prepared as there is too much data to interpret accurately; regression must be performed using the Data analysis toolpack o All of the X variables are highlighted together when inputting the X data Example Problem in Excel db9b77cae99c2aa7d898177a09dda1bb6b233902.doc Page 1 5/7/2009...
View Full Document
- Spring '08
- Decision Making