Please do C. Show work on what was clicked and done
Background: PLE is investigating the demand for an attachment for a popular line of mowers that it sold in North America (NA) in 2018. A competitor also sells the same attachment. In a recent market study the PLE marketing department randomly sampled sales and pricing data from 15 market regions (region 1, region 2, etc.) in NA. Those data are contained in the spreadsheet Problem 6a. The variables are defined as follows: Market Region: Market location in NA Sales: Units of PLE Mower Attachment Sold 2018 Price: Selling Price of PLE Attachment Competitor Price: Selling Price of Competitor's Attachment The marketing department wishes to use regression analysis and related techniques to answer several demand related questions. The dependent variable is Sales. The explanatory (independent) variables are Price and Competitor Price. Complete the questions below. a) Utilizing the worksheet Problem 6a, create a scatter chart utilizing the variables Sales and Price. Locate the chart roughly in the range E2:M18. b) Utilizing the worksheet Problem 6a, use the Regression tool in the Data Analysis Telpack to perform a simple linear regression with the dependent variable (Y) = Sales and the explanatory variable (X) = Price. Use labels and output the regression results in a new worksheet and include standardized residuals. Name the new worksheet Prob6bSimpReg and locate this worksheet next to the Problem ba worksheet (click and drag the worksheet tab). Change the numeric format for the p-value for the intercept to 'number' with 5 0.00000) decimal places so it is easier to read. Also create a histogram of the standardized residuals (hint: see P. 301). Now, go to the worksheet titled SimrRegMultChoice and answer the multiple choice questions based on the regression results & chart you generated. (NOTE: You do not need to save the histogram. You Do need to save the regression results!) c) Utilizing the worksheet Problem 6a once again, use the Regression tool in the Data Analysis Teolpack to perform a multiple linear regression with the dependent variable (Y) = Sales and two explanatory variables (x1) = Price and (X2) = Competitor Price. Use labels and output the regression results in a new worksheet. You do not need to include standardized residuals. Name the new worksheet ProbbaMultReg and locate this worksheet next to the Problem 6cSimpReg worksheet (click and drag the worksheet tab). Change the numeric format for the p-value to 'number' with 5 (-00000) decimal places for intercept, price, and competitor price so they are easier to read. Now, go to the worksheet titled MultRegMultCheice and answer the multiple choice questions based on the regression results you generated. A B D E F G H J K L M N LOCATE THE SCATTER CHART BELOW 1 Problem 6a 2 DEMAND DATA 3 Market Region 4 Sales 1 5 6 2 3 7 8 9 4 5 Price 2280 2160 2330 2070 2160 2470 2330 2490 2390 2090 6 7 10 11 Competitor Price $220 $290 $240 $260 $240 $250 $220 $270 $240 $240 $240 $300 $210 $220 $300 $220 $270 $240 $290 $280 $220 $200 $230 $210 $270 $280 $260 $260 $290 $260 8 9 9 12 13 10 14 11 2140 2360 15 12 16 13 2180 1910 17 14 18 15 2230 19 20 21 22 N O B C D E F A H J L M 1 Answer the following questions based on the regression output you 2 generated with Sales as the dependent (Y) variable and both Price (x1) and Competitor Price (X2) as the explanatory variables. 3 4 1) The estimated regression equation is: 5 A) Y = 2892.15 - 4.75(X1)+2.18 (X2) 6 B) Y = 2892.15 +4.95(X1)-2.99 (X2) ANSWER 7 C) Y = 3000.15 -4.75(X1) +4.75 (X2) 8 A) Y = 4000.15 -4.75(X1)-2.18 (X2) 9 10 2) Using the regression equation the predicted value of Sales is _if Price = $300 and Competitor Price = $288 (Note: Round up) 11 A)1990 12 B)2150 ANSWER 13 C2095 14 D 2000 15 16 3) Using the regression equation the predicted value of Sales is if Price = $288 and Competitor Price = $288 (Note: Round up) 17 A 1990 18 B)2152 ANSWER 19 C)2098 20 D 2000 21 22 4) What proportion of the variation in Sales is explained by Price and Competitor price? 23 A).00026 24 B).810 ANSWER 25 C).900 26 D) 456 27 28 5) Assume that you are using a a-.05 level of significance to test the null hypothesis that the slope coefficient for B2 (Competitor Price) 29 is 0 (Ho: B2 = 0). Utilizing the P-value for Competitor Price, which is true if H1 is specified as B2=0? 30 A) Reject Ho and accept H1 because P
