Cincinnati Paint Company sells quality brands of paints through hardware stores throughout the United States. The company maintains a large sales force whose job it is to call on existing customers as well as look for new business. The national sales manager is investigating the relationship between the number of sales calls made and the miles driven by the sales representative. Also, do the sales representatives who drive the most miles and make the most calls necessarily earn the most in sales commissions? To investigate, the vice president of sales selected a sample of 25 sales representatives and determined:
• The amount earned in commissions last month (Y)
• The number of miles driven last month (X1)
• The number of sales calls made last month (X2)
The information is reported below.
Commissions Calls Driven
($000)
22 139 2,371
13 132 2,226
33 144 2,731
38 142 3,351
23 142 2,289
47 142 3,449
29 138 3,114
38 139 3,342
41 144 2,842
32 134 2,625
20 135 2,121
13 137 2,219
47 146 3,463
38 146 3,290
44 144 3,103
29 147 2,122
38 144 2,791
37 149 3,209
14 131 2,287
34 144 2,848
25 132 2,690
27 132 2,933
25 127 2,671
43 154 2,988
34 147 2,829
Develop a regression equation including an interaction term. (Round your answers to 3 decimal places. Negative amounts should be indicated by a minus sign.)
Commissions = _____+ _____ Calls + ____ Miles + _____ X1X2
Complete the following table. (Round your answers to 3 decimal places. Negative amounts should be indicated by a minus sign.)
Predictor Coef SE Coef T P
Constant ____ ___ ____ ___ ____
Calls ____ ___ ____ ___ ____
Miles ____ ___ ____ ___ ____
X1X2 ____ ___ ____ ___ ____
Compute the value of the test statistic corresponding to the interaction term. (Round your answer to 2 decimal places. Negative amount should be indicated by a minus sign.)
Value of the test statistic:____?