Question: Based on the Drug Store data set, complete the following. (1) Display the least squares line based on the scatter plot for the data. (2)
Based on the Drug Store data set, complete the following.
(1) Display the least squares line based on the scatter plot for the data. (2) In the Excel file, indicate how would you interpret the least squares line? (3) What is the R2 value? (4) How would you interpret the R2 value?
| Region | Promote | Sales |
| 1 | 85 | 88 |
| 2 | 120 | 106 |
| 3 | 120 | 105 |
| 4 | 102 | 112 |
| 5 | 99 | 88 |
| 6 | 104 | 106 |
| 7 | 109 | 113 |
| 8 | 93 | 89 |
| 9 | 105 | 95 |
| 10 | 91 | 90 |
| 11 | 97 | 102 |
| 12 | 103 | 104 |
| 13 | 113 | 112 |
| 14 | 98 | 83 |
| 15 | 104 | 110 |
| 16 | 103 | 98 |
| 17 | 105 | 112 |
| 18 | 101 | 116 |
| 19 | 102 | 87 |
| 20 | 107 | 101 |
| 21 | 112 | 115 |
| 22 | 104 | 99 |
| 23 | 112 | 96 |
| 24 | 98 | 100 |
| 25 | 106 | 95 |
| 26 | 106 | 108 |
| 27 | 108 | 105 |
| 28 | 110 | 108 |
| 29 | 123 | 122 |
| 30 | 95 | 84 |
| 31 | 109 | 104 |
| 32 | 105 | 100 |
| 33 | 114 | 104 |
| 34 | 110 | 107 |
| 35 | 98 | 94 |
| 36 | 99 | 102 |
| 37 | 111 | 115 |
| 38 | 116 | 107 |
| 39 | 126 | 114 |
| 40 | 127 | 123 |
| 41 | 109 | 97 |
| 42 | 105 | 83 |
| 43 | 97 | 95 |
| 44 | 119 | 111 |
| 45 | 119 | 106 |
| 46 | 126 | 116 |
| 47 | 107 | 107 |
| 48 | 109 | 101 |
| 49 | 104 | 111 |
| 50 | 105 | 90 |
Step by Step Solution
3.43 Rating (150 Votes )
There are 3 Steps involved in it
so promote is our independent variable and sales is our dependent variable here is excel step step 1 ... View full answer
Get step-by-step solutions from verified subject matter experts
