Explore BrainMass

# Multiple Regression Analysis

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

See attached file.

Please see attached Xls file associated with this problem.
Create dummy variables for Tuesdays, Wednesdays, Thursdays and Fridays.

· Create dummy variables 09/24/2008, 11/14/2008 and 11/17/2008.

· Create time variable t starting with t =1 for 08/18/2008 to t =70 for 11/21/2008.

· Run multiple regression to predict daily calls offered using the above dummy variables and a time as independent variables.

· Remove any variables that are not statistically significant at the 5% level and rerun the regression.

· Examine the regression residuals for patterns and for normality

https://brainmass.com/statistics/regression-analysis/regression-analysis-using-dummy-variables-357137

#### Solution Preview

o Please see attached xls file associated with this problem. Also can you detail the procedure for creating dummy variables.

o Create dummy variables for Tuesdays, Wednesdays, Thursdays and Fridays.
Formula for dummy variable of
o Tuesdays =IF(WEEKDAY(A4)=3,1,0)
o Wednesdays =IF(WEEKDAY(A4)=4,1,0)
o Thursdays=IF(WEEKDAY(A4)=5,1,0)
o Friday = IF(WEEKDAY(A4)=6,1,0)

o Create dummy variables 09/24/2008, 11/14/2008 and 11/17/2008.
o Create time variable t starting with t =1 for 08/18/2008 to t =70 for 11/21/2008. ...

#### Solution Summary

The solution provides step by step method for the calculation of multiple regression model. Formula for the calculation and Interpretations of the results are also included.

\$2.19