A textbook publisher for books used in business schools believes that the number of books sold is related to the number of campus visits to decision makers made by their sales force. A sampling of the number of sales calls made and the number of books sold is shown in the following table. NUMBER OF SALES CALLS MADE 25 15 25 45 35 25 25 35 25 15 NUMBER OF BOOKS SOLD 375 250 525 825 550 575 550 575 400 400 a. Plot the data in excel and generate the linear regression model. b. What percent in the variation of the variable Books Sold is explained by the value of the variable Sales Calls Made? c. For every sale call made, the number of books sold increases by how much? d. In order to realize the sale of 700 books, how many sales calls will the sales representative have to make?
A textbook publisher for books used in business schools believes that the number of books sold is related to the number of campus visits to decision makers made by their sales force. A sampling of the number of sales calls made and the number of books sold is shown in the following table. NUMBER OF SALES CALLS MADE 25 15 25 45 35 25 25 35 25 15 NUMBER OF BOOKS SOLD 375 250 525 825 550 575 550 575 400 400 a. Plot the data in excel and generate the linear regression model. b. What percent in the variation of the variable Books Sold is explained by the value of the variable Sales Calls Made? c. For every sale call made, the number of books sold increases by how much? d. In order to realize the sale of 700 books, how many sales calls will the sales representative have to make?
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section13.3: Simple Regression Models
Problem 6P: Do the sales prices of houses in a given community vary systematically with their sizes (as measured...
Related questions
Question
![A textbook publisher for books used in business schools believes that the number of books sold is
related to the number of campus visits to decision makers made by their sales force. A sampling
of the number of sales calls made and the number of books sold is shown in the following table.
NUMBER OF SALES CALLS
MADE
25
15
25
45
35
25
25
35
25
15
NUMBER OF BOOKS SOLD
375
250
525
825
550
575
550
575
400
400
a. Plot the data in excel and generate the linear regression model.
b.
What percent in the variation of the variable Books Sold is explained by the value of the
variable Sales Calls Made?
c. For every sale call made, the number of books sold increases by how much?
d. In order to realize the sale of 700 books, how many sales calls will the sales
representative have to make?](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fa2b95824-f7a5-4632-a652-5cf680f15c7d%2F2d4ca41f-8a29-4620-ac99-cf84a4853894%2Fdv12ys8_processed.png&w=3840&q=75)
Transcribed Image Text:A textbook publisher for books used in business schools believes that the number of books sold is
related to the number of campus visits to decision makers made by their sales force. A sampling
of the number of sales calls made and the number of books sold is shown in the following table.
NUMBER OF SALES CALLS
MADE
25
15
25
45
35
25
25
35
25
15
NUMBER OF BOOKS SOLD
375
250
525
825
550
575
550
575
400
400
a. Plot the data in excel and generate the linear regression model.
b.
What percent in the variation of the variable Books Sold is explained by the value of the
variable Sales Calls Made?
c. For every sale call made, the number of books sold increases by how much?
d. In order to realize the sale of 700 books, how many sales calls will the sales
representative have to make?
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,