Part A: Scatter Plot and Regression Analysis Table 1 - Store Profits and Sales Store # Profits ($000s) Instructions: Complete Part A subparts 1 and 3 below. 1. Create a Scatter Plot using Table 1 data. [Enter scatter plot here. Expand spacing as necessary] Sales ($000s) 1 42.13 748.82 2 6.32 140.78 3 38.47 702.11 4 -0.32 41.54 5 3.65 96.85 6 7.77 166.93 7 4.31 109.05 8 4.53 263.92 9 -2.69 50.84 10 3.22 11 9.03 90.08 190.59 12 -2.59 13 6.39 14 24.39 15 13.93 91.75 141.57 377.04 198.69 16 17 17.48 18 19 7.21 15.62 20 33.61 91.8 231.6 548.31 2.13 62.78 265.28 3. Use the approach outlined in Week 5 of your text and Table 1 data in the scenario to develop a best fit linear equation of the form Y = a + b1*X1 where: - Y is the profit or the dependent variable - a is the value of the intercept from the regression analysis -X1 is the sales level or the independent variable -b1 is the coefficient of the independent variable from the regression analysis Run the complete regression analysis on a separate spreadsheet and insert the results of this regression analysis in the table here. Expand as necessary. [An example of the proper format can be found in section 6.2 of your text.] You will simply need to insert the values of the intercept and b1 into this table.