Section 2 - Analysis . Using Excel, create scatter plots and display the regression equations for the following pairs of variables: . "BachDeg%" versus "Sales/SqFt" . "Medincome" versus "Sales/SqFt" . "MedAge" versus "Sales/SqFt" . "LoyaltyCard(%)" versus "SalesGrowth(%)" . In your report, include the scatter plots. For each scatter plot, designate the type of relationship observed (increasing/positive, decreasingegative, or no relationship) and determine what you can conclude from these relationships.Paste BI U v Clipboard IN Font IN Alignment A40 35 B C D E G H 1 Pastas R Us, Inc. Database (n = 74 restaurants) 2 Square Average Over Previous Loyalty Card % Sales Per Median HH Age (3 Bachelor's Feet Spending Year (%) of Net Sales Sq Ft Income [3 Miles Miles Degree [3 Obs Soft Sales/Person SalesGrowth \\LoyaltyCard SalesiSy \\Medincome MedAge BachDeqy 2354 6.81 -8.31 2.07 701.97 45177 34.4 31 12 2604 7.57 -4.01 2.54 209.93 51888 41.2 20 13 2453 6.89 -3.94 1.66 364.92 61379 40.3 24 4 2340 7.13 -3.39 2.06 443.04 66081 35.4 29 10 2500 7.04 -3.30 2.48 399.20 5099 31.5 18 11 2806 6.93 -1.94 2.96 264.64 41562 36.3 30 2250 7.11 -0.77 2.28 571.59 44196 35.1 14 2400 7.13 -0.37 2.34 642.25 50975 37.6 33 270 6.58 -0.25 2.20 461.45 72808 34.9 28 1990 6.77 -0. 17 2.34 638.82 79070 34 8 29 2392 5.66 0.47 2.09 484.38 78497 36.2 2408 7.03 0.55 2.47 581.09 41245 32.2 2627 7.03 0.77 2.04 267.71 33003 30.9 2500 7.00 1.92 2.02 572.84 90988 37.7 1986 7.38 2.05 2.01 586.48 37950 34.3 2500 7.18 2.12 2.64 368.73 45206 32.4 17 2668 7.35 2.84 2.22 351.47 79312 32.1 37 2517 6.95 2.88 2.07 458. 24 37345 31.4 22 1251 7.02 3.96 1.94 987.12 46226 30.4 36 998 6.85 4.04 2.17 357.45 70024 33.9 34 21 2625 7.16 4.05 0.72 405.77 54982 5.6 22 2300 6.99 4.05 2.00 680.80 54932 35.9 23 2761 7.28 4.24 1.81 368.02 34097 3.6 29 24 2764 7.07 4.58 2.13 303.95 46593 37.9 26 30 25 2430 7.05 5.09 2 50 393.90 61893 10.6 21 31 26 2154 6.54 5.14 263 562.12 88162 37.7 37 32 27 2400 6.70 5.48 1.95 494.88 89016 36.4 34 33 28 2430 6.91 5.86 2.04 310.07 114353 40.9 34 34 29 2549 7.58 5.91 141 373.46 75366 35.0 30 35 30 2500 7.03 5.98 2.05 .235.81 48163 26.4 16 36 31 3653 6.84 6.08 2. 13 413.08 19956 37.1 28 37 32 2440 6.94 6.08 2.08 625.22 45990 30.3 36 38 33 2600 7.07 6.13 2.73 274 30 45723 ELE 18 39 34 2160 7.00 6.27 1.95 542 62 43800 19.6 36 35 2800 80 6 571 2 04 178 56 6871 32 91 Data + Ready Type here to search O