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?


RegionPromoteSales
18588
2120106
3120105
4102112
59988
6104106
7109113
89389
910595
109190
1197102
12103104
13113112
149883
15104110
1610398
17105112
18101116
1910287
20107101
21112115
2210499
2311296
2498100
2510695
26106108
27108105
28110108
29123122
309584
31109104
32105100
33114104
34110107
359894
3699102
37111115
38116107
39126114
40127123
4110997
4210583
439795
44119111
45119106
46126116
47107107
48109101
49104111
5010590

Step by Step Solution

3.43 Rating (150 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

so promote is our independent variable and sales is our dependent variable here is excel step step 1 ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!