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 (X 2 ) The number of sales calls made last month (X 1 ) The information is reported below Commissions ($000) Calls Driven Commissions ($000) Calls Driven 34 126 2,293 31 132 3,195 46 128 2,152 26 133 3,036 35 129 2,659 48 133 2,074 11 135 3,278 44 149 2,714 14 136 2,214 42 153 3,154 10 142 3,392 16 167 2,214 32 143 3,046 19 182 2,790 26 104 3,279 38 183 2,607 22 105 2,806 26 188 2,879 10 144 2,547 24 192 2,604 13 187 2,060 12 115 2,926 12 115 2,160 18 132 2,768 20 126 3,379 Click here for the Excel Data File Develop a regression equation including an interaction term (Round your answers to 5 decimal places Negativeamountsshould be indicated by a minus sign ) Commissions Calls Miles X 1 X 2 Complete the following table (Round your answers for Coef, SE Coef to 5 decimal places, T to 2 decimal places and P to 3 decimal places Negativeamountsshould be indicated by a minus sign ) Predictor Coef SE Coef T P Constant Calls Miles X 1 X 2 Compute the value of the test statistic corresponding to the interaction term (Round your answer to 2 decimal places Negativeamountshould be indicated by a minus sign ) Value of the test statistic At the 05 significance level is there a significant interaction between the number of sales calls and the miles driven This is(Click to select)significantnot significant, so we conclude there(Click to select)is interactionis no interaction

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Oct 13, 2024

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

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 (X₂)

The number of sales calls made last month (X₁)

The information is reported below.

Commissions ($000)	Calls	Driven	Commissions ($000)	Calls	Driven
34	126	2,293	31	132	3,195
46	128	2,152	26	133	3,036
35	129	2,659	48	133	2,074
11	135	3,278	44	149	2,714
14	136	2,214	42	153	3,154
10	142	3,392	16	167	2,214
32	143	3,046	19	182	2,790
26	104	3,279	38	183	2,607
22	105	2,806	26	188	2,879
10	144	2,547	24	192	2,604
13	187	2,060	12	115	2,926
12	115	2,160	18	132	2,768
20	126	3,379

Click here for the Excel Data File

Develop a regression equation including an interaction term.(Round your answers to 5 decimal places. Negativeamountsshould be indicated by a minus sign.)

Commissions =+Calls +Miles +X₁X₂

Complete the following table.(Round your answers for Coef, SE Coef to 5 decimal places, T to 2 decimal places and P to 3 decimal places.Negativeamountsshould be indicated by a minus sign.)

Predictor	Coef	SE Coef	T	P
Constant
Calls
Miles
X₁X₂

Compute the value of the test statistic corresponding to the interaction term.(Round your answer to 2 decimal places. Negativeamountshould be indicated by a minus sign.)

Value of the test statistic

At the .05 significance level is there a significant interaction between the number of sales calls and the miles driven?

This is(Click to select)significantnot significant, so we conclude there(Click to select)is interactionis no interaction.