Question:

Sales Calls, Variety, & Units Sold

Use the information gathered from Question #1, but add a new variable for number of different products sold.

Sales Rep. No of Units Sold No of Sales Calls Variety of Different Prod. Sold

A 28 14 2

B 66 35 5

C 38 22 4

D 70 29 4

E 22 6 3

F 27 15 3

G 28 17 3

H 47 20 4

I 14 12 2

J 68 29 5

Use Excel to estimate a multiple linear regression model to explain the relationship between sales calls, variety, and units sold. Explain each of the coefficients from the regression. Conduct hypothesis tests for the significance of the overall model, the significance of the sales calls coefficient, and the significance of the variety coefficient. Discuss the coefficient of determination, and be sure to cover whether or not either of the independent variables provides a good explanation of the variation in the dependent variable.

Price: $2.99

Solution: The downloadable solution consists of 3 pages
Deliverable: Word Document