Question

Cincinnati Paint Company sells quality brands of paints through hardware stores throughout the United States. The...

Cincinnati Paint Company sells quality brands of paints through hardware stores throughout the United States. The company maintains a large sales force who call on existing customers and 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 ($000) Calls Driven Commissions ($000) Calls Driven
23 68 2,372 39 188 3,291
14 30 2,229 44 218 3,103
34 136 2,733 29 105 2,123
39 180 3,353 38 162 2,794
24 77 2,291 37 154 3,209
47 186 3,451 15 25 2,289
30 103 3,117 34 132 2,850
39 143 3,343 26 94 2,692
42 200 2,843 28 96 2,934
32 156 2,626 25 81 2,673
21 50 2,122 44 205 2,988
13 46 2,222 35 155 2,830
47 225 3,466

Develop a regression equation including an interaction term. (Negative amount should be indicated by a minus sign. Round your answers to 3 decimal places.)

Commissions= ___________ + __________________ calls + _______________________miles + ___________________x1x2

Complete the following table. (Negative amounts should be indicated by a minus sign. Round your answers to 3 decimal places.)

Predictor Coefficient SE Coefficient t p-value
Constant
Calls
Miles
X1X2

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

Value of the test statistic ___________________

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

This is STATISTICALLY SIGNIFICANT or NOT SIGNIFICANT (choose), so we conclude that there IS INTERACTION or IS NO INTERACTION (choose).

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Cincinnati Paint Company sells quality brands of paints through hardware stores throughout the United States. The...
Cincinnati Paint Company sells quality brands of paints through hardware stores throughout the United States. The company maintains a large sales force who call on existing customers and 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...
Cincinnati Paint Company sells quality brands of paints through hardware stores throughout the United States. The...
Cincinnati Paint Company sells quality brands of paints through hardware stores throughout the United States. The company maintains a large sales force who call on existing customers and 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...
Cincinnati Paint Company sells quality brands of paints though hardware stores throughout the United States. The...
Cincinnati Paint Company sells quality brands of paints though hardware stores throughout the United States. The company maintains a large sales force whose job is to call on existing customer 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...
I completed everything except for the last part. I know my answers are right because i...
I completed everything except for the last part. I know my answers are right because i double checked but i just dont know how to answer the last section. Problem 3-1 Schedule C (LO 3.1) Scott Butterfield is self-employed as a CPA. He uses the cash method of accounting, and his Social Security number is 644-47-7833. His principal business code is 541211. Scott's CPA practice is located at 678 Third Street, Riverside, CA 92860. Scott’s income statement for the year...
MATHEMATICS 1. The measure of location which is the most likely to be influenced by extreme...
MATHEMATICS 1. The measure of location which is the most likely to be influenced by extreme values in the data set is the a. range b. median c. mode d. mean 2. If two events are independent, then a. they must be mutually exclusive b. the sum of their probabilities must be equal to one c. their intersection must be zero d. None of these alternatives is correct. any value between 0 to 1 3. Two events, A and B,...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT