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:

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.6: Summarizing Categorical Data
Problem 10CYU
icon
Related questions
Topic Video
Question

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
22 140 2,372 38 146 3,291
13 132 2,227 44 145 3,104
33 145 2,732 29 147 2,122
38 146 3,351 38 144 2,792
23 142 2,289 37 149 3,210
47 143 3,450 14 132 2,288
29 138 3,114 34 144 2,848
38 146 3,342 25 132 2,691
41 145 2,843 27 132 2,934
32 134 2,626 25 128 2,672
20 136 2,121 43 154 2,989
13 137 2,220 34 147 2,829
47 146 3,464      
 

 

 

 

  Click here for the Excel Data File

 

 

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

 

 

 

 

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

 

 

 

 

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.)

 

 

 

 

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

 

 

 

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Discrete Probability Distributions
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, probability and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt