Use the following information to answer the question(s) below.
Ford would like to develop a regression model that would predict the number of cars sold per month by a dealership employee based on the employee's number of years of sales experience (Exp), the employee's weekly base salary before commissions (Salary), and the education level of the employee. There are three levels of education in the sales force—high school degree, associate's degree, and bachelor's degree. The following dummy variables have been defined.
Degree | ED1 | ED2
High School | 0 | 0
Associate's | 0 | 1
Bachelor's | 1 | 0
The following Excel output shows the partially completed regression output from a random sample of employees from the previous month.
