Kam Battie, owner of Flower Drect, operates a local chain of floral shops. Each shop has its own delivery van Inwad of charging a flat delivery fee, Battle wants to set the delivery fee based on the distance driven to deliver the fowers Bat wants to separate the feed and vanable portions of her van operating costs so that she has a better idea how delivery distance affects these costs, Flower Direct does a regression analysis on the next year's data using Excel. The output generated by Excel is as follows: Click the soon to view the regression analysis) Requirement 1. Determine the femi's cost equation (use the output from the Excel regression) (Enter amounts to two decimal places.) Requirement 2. Determine the R-squared (use the output from the Excel regression) The R-squared What does Flower Dres que indicate? The R-squared indicates that the cost equation explains Requirement 3. Predict van operating costs at a volume of 17,000 miles assuming the c not? (Round your answer to t nearest cent The operating costs at a volume of 17.000 mi Should the company rely on this cost estimate? Why or why not? Since the R-squared the company other words Flower Dec any would use the cost equation from the Excel regression regardless o quared. Should the company cost estimate? Why or why Regression analysis A B 1 SUMMARY OUTPUT 2 Regression Statistics 3 Multiple R 0.87 4 R Square 0.75 5 Adjusted R Square 0.71 6 Standard Error 153.46 7 D E F G 7 Observations 8 ANOVA 9 10 Regression df SS MS F Significance F 1 362,391.24 362,391.24 15.39 0.0112 11 Residual 5 117,751.61 23,550.32 12 Total 6 480,142.86 13 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% 14 Intercept 1,784.73 884.55 2.02 0.10 -489.09 4,058.55 15 X Variable 1 0.22 0.06 3.92 0.01 0.07 0.36 Print Done Xor th