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 R² value? (4) How would you interpret the R² 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

Answer rating: 100% (QA)

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