please include the hypothesis testing and steps.

One of your clients owns a large number of franchise restaurants. The owner wants you to determine if the Yearly Advertising Budget allocated to each store and / or the Number of Competing Stores helps to explain the level of annual sales for each store. Design: Your client wants you to study the importance of one or both variables (Yearly Ad Budget and Number of Competitor Stores) in understanding why Annual Net Sales vary among his many stores. Using Version 2 of the SSP, complete the following: (30 pts.) a. Complete all preliminary steps for correlation analysis. b. Note that scatter plots are useful in determining patterns between two variables. Use the scatter plot option to display the data patterns for each IV with the DV (Sales). The name (definition) of each IV is shown right above the data. C. Next, use the correlation option to build a correlation table for the 3 variables. Include all 3 variables in one correlation table. d. Discuss your findings and conclusions. Are all of the relationships (e.g., X1 with Y, X2 with Y) statistically significant? How do you know this? Be sure to show your work. Using Version 3 of the SSP, complete the following: (30 pts.) a. Complete all preliminary steps for regression analysis. b. Next, use the regression option to run a bi-variate regression model with the IV that has the strongest correlation with Sales as the dependent variable. C. Discuss your findings and conclusions. Does the Independent Variable you tested explain a significant amount of variation in the Dependent Variable (Sales)? d. Finally, what will you tell your client? Formulas Data Data Il Queries & Connections Properties Refresh All Edit Links Get Data Stocks Geo Get & Transform Data Queries & Connections Data Typ B9 X fx X1 A D E F G H 9 X 15-0 300 250 200 B X, $8.2 $8.9 $21 $5.8 $14.8 $11.8 $8.1 $7.7 $3.3 $113 $17.4 $10.5 $11.3 $2.5 11 12 15 1 5 4 10 12 15 13 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 28 27 28 129 30 100 SO $131 $88 $90 $319 $243 $387 $139 $65 $84 $68 $275 $428 $464 $132 $298 $180 $398 $98 $397 $207 $328 $54 $295 $147 $841 $267 $400 $295 $98 7 3 14 8 10 4 13 7 6 3 14 7 8 5 3 8 7 13 $12.9 $5.5 $49 $10.4 $14.5 $16.2 $2.8 $24 $9.6 $9.8 $14.9 $7.0 $2.4 $4.9 33 34 40 41 42