questions pertaining table 8.3

Table 8.3 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. Apply linear regression model to this problem and solve it in EXCEL. NUMBER OF SALES NUMBER OF BOOKS CALLS MADE SOLD 25 375 15 250 25 525 45 825 35 550 25 575 25 35 575 25 400 15 400 550 What is the value of the sample correlation coefficient, 1? 86.5% 74.8% 72.5% 83.3% QUESTION 2 What is the standard error of the estimate? 72.5% 74.8% 83.299 86.5% QUESTION 3 What is the value of a (Y-intercept of the line)? 104.605 14.737 25.67 33.86 QUESTION 4 What is the value of b (slope of the line)? 33.86 14.737 25.67 104.605 QUESTION 5 Use the information provided in Table 8.3. For every sale call made, the number of books sold increases by: 14.74 books. 104.6 books. 83.30 books. 7.25 books. QUESTION 5 Use the information provided in Table 8.3. For every sale call made, the number of books sold increases by: 14.74 books. 104.6 books. 83.30 books. 7.25 books. OO QUESTION 6 Use the information provided in Table 8.3. If a sales representative makes 56 sales calls, the number of book sales the publisher should expect is: 114 915 105. 4,581 QUESTION 7 Use the information provided in Table 8.3. In order to realize the sale of 700 books, how many sales calls will the sales representative have to make? 45.9 40.4 37.6 32.7