mba 522 Qulitative multiple reg example

mba 522 Qulitative multiple reg example - Data

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

View Full Document Right Arrow Icon
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
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.
Ask a homework question - tutors are online