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 Rsquare measure rather than Rsquare 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 scattergraph 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
 Rabe
 Decision Making

Click to edit the document details