Question

• Using Excel, create scatter plots and display the regression equations for the following pairs of variables:
• “BachDeg%” versus “Sales/SqFt”
• In your report, include the scatter plots. For each scatter plot, designate the type of relationship observed (increasing/positive, decreasing/negative, or no relationship) and determine what you can conclude from these relationships.

% w/ Bachelor's Degree (3 Miles)	Annual Sales Per Sq Ft
BachDeg%	Sales/SqFt
31	701.97
20	209.93
24	364.92
29	443.04
18	399.20
30	264.64
14	571.59
33	642.25
28	461.45
29	638.82
39	484.38
23	581.09
22	267.71
37	572.84
24	586.48
17	368.73
37	351.47
22	458.24
36	987.12
34	357.45
26	405.77
20	680.80
20	368.02
26	303.95
21	393.90
37	562.12
34	494.88
34	310.07
30	373.46
16	235.81
28	413.08
36	625.22
18	274.30
36	542.62
18	178.56
24	375.33
22	329.09
29	297.37
25	323.17
28	468.84
40	352.57
39	380.34
30	398.12
17	312.15
22	452.16
29	698.64
19	367.19
29	431.93
18	367.06
19	400.53
34	414.36
25	481.11
30	538.06
21	330.48
30	249.93
30	291.87
28	517.40
31	551.58
16	386.81
31	427.50
40	453.94
33	512.46
28	345.27
23	234.04
16	348.33
25	348.47
25	294.95
18	361.14
15	467.71
19	403.78
27	245.74
21	339.94
29	400.82
15	326.54

Answer 1