Complete the Revisiting Cost Analytics exercise $($Chapter $10$ DA Exercise $2)$ before answering the question below.

Enter the number $40$ into cell L$5$ on the Cost Data worksheet. In the space below, enter the estimated cost per day in cell L$6.$ Type the number and only the number in

Question $1$ the space below. Round your answer to $2$ decimal places.

$$

Question $2$

Complete the Revisiting Cost Analytics exercise $($Chapter $10$ DA Exercise $2)$ before answering the question below.

Enter the number $40$ into cell L$5$ on the Cost Data worksheet. In the space below, enter the estimated cost per day in cell L$6.$ Type the number and only the number in

Question $1$ the space below. Round your answer to $2$ decimal places.

$$

Question $2$

Complete the Revisiting Cost Analytics exercise $($Chapter $10$ DA Exercise $2)$ before answering the question below.

Question $1$

After running the regression and observing the output in step $18,$ enter the Adjusted R Square that appears in cell B$6$ in the space below. Type the number and only the number in the space below. Round your answer to $2$ decimal places.

Question $2$

$6-20201221-220217-722052/$read

$10.$ Define the Input $x$ Range with the data in the Number of Properties column. Include cell $C1$ in the cell range for this input box. This will be the independent variable for the regression analysis.

$11.$ Click the Labels check box in the Regression dialog box.

$12.$ Type the following in the New Worksheet Ply input box: "Regression Output".

$13.$ Click the Line Fit Plots option and then click the OK button on the Regression dialog box.

$14.$ Increase the width of column A to $18$ points on the Regression Output worksheet.

$15.$ Increase the size of the scatter chart so the right side is in column $R$ and the bottom of the chart is in row $18.$

$16.$ Add a linear trendline to the Predicted Total Cost data series on the scatter chart and add the trendline equation. Then, move the trendline equation to the upper left area of the chart plot area. The equation shown on the chart is the cost function for the total landscaping costs. The Number of Properties coefficient, $17\mathrm{.}421$ x $,$ is the variable cost per unit and the x represents the number of properties serviced. Therefore, the number of properties serviced multiplied by $17\mathrm{.}421$ would equal the total variable cost that is predicted to be incurred. The Intercept, which is $340\mathrm{.}11,$ is the fixed cost per day.

$17.$ Format the values in the range E$17$:E$18$ to a percentage with five decimal places. Increase the width of column E if needed. These are the P$-$values for the Intercept and the Number of Properties coefficients. Provide a brief explanation of what these values indicate for this analysis in the AnswerSheet worksheet.

$18.$ Observe the Multiple $R$ and Adjusted $R$ Square in the regression output. Provide a brief explanation of what these values indicate for this analysis in the AnswerSheet worksheet.

$19.$ Open the Cost Data worksheet and type the fixed cost per day that was established in the regression analysis into cell L$3.$ Use two decimal places for this value.

$20.$ Type the variable cost per property serviced day that was established in the regression analysis into cell L$4.$ Use three decimal places for this value.

$21.$ Type the number $65$ into cell L$5.$ Assume the company is estimating the total costs that would

$6-20201221-220217-722052/$read

$10.$ Define the Input $x$ Range with the data in the Number of Properties column. Include cell $C1$ in the cell range for this input box. This will be the independent variable for the regression analysis.

$11.$ Click the Labels check box in the Regression dialog box.

$12.$ Type the following in the New Worksheet Ply input box: "Regression Output".

$13.$ Click the Line Fit Plots option and then click the OK button on the Regression dialog box.

$14.$ Increase the width of column A to $18$ points on the Regression Output worksheet.

$15.$ Increase the size of the scatter chart so the right side is in column $R$ and the bottom of the chart is in row $18.$

$16.$ Add a linear trendline to the Predicted Total Cost data series on the scatter chart and add the trendline equation. Then, move the trendline equation to the upper left area of the chart plot area. The equation shown on the chart is the cost function for the total landscaping costs. The Number of Properties coefficient, $17\mathrm{.}421$ x $,$ is the variable cost per unit and the x represents the number of properties serviced. Therefore, the number