mba 522 Qulitative multiple reg example

# mba 522 Qulitative multiple reg example - Data A B C D E...

This preview shows page 1. Sign up to view the full content.

Data Qualitative variables as independent variables in multiple regression  A B C D E F Person Repairperson 2.9 2 1 1 electrical Dave Newton Note: Repair time is the dependent variable  3.0 6 0 1 mechanical Dave Newton to be estimated. Indep variables are months since  4.8 8 1 0 electrical Bob Jones last service, type of job and reapairman. 1.8 3 0 1 mechanical Dave Newton 2.9 2 1 1 electrical Dave Newton Note: I have re-coded columns E and F.  4.9 7 1 0 electrical Bob Jones Results are in columns C and D. 4.2 9 0 0 mechanical Bob Jones In column C: 1= Electrical, and 0 = mechancial 4.8 8 0 0 mechanical Bob Jones In column D: 1= Dave, and 0 = Bob 4.4 4 1 0 electrical Bob Jones 4.5 6 1 1 electrical Dave Newton Using the Regression printout from Excel, we have the following regression equation: SUMMARY OUTPUT Y^ = 1.86 + 0.29 (months) + 1.10 (job type) -0.61 (person) Let's make several estimates using this multiple regression equation that we made with Excel. Regression Statistics
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 11/13/2011 for the course MBA 522 taught by Professor Nabavi during the Spring '08 term at Bellevue.

Ask a homework question - tutors are online