E6-48B (similar to) EQuestion Help Kristen Coughlin, awner of Flower Pelal, cperales a local thain of floral shops, Each shop has its own delivery van, Instead of charging a flat delivery fee, Coughlin wants to set the delivery fee based on the distance driven to deliver the flowers, Coughlin wants to afixed and variable portions af her van operating costs so that she has a better idea how delivery distance attects these costs Kristen's Flower Petal does a regression analysis on the next year's data using Excel. The output generated by Excel is as X EE (Cick the icon to view the regression analysis.) Regression analysis Requirements 1. Determine the firm's cost equation (use the output from the Excel regression) Determine the R-square (use the output from the Excel regression). What does Flower Petal's R-square indicate? SUMMARY OUTPUT 3 Predict van operating costs at a yolume of 15.500 miles. Rearession Statistics Mullipla F 0.87 Requirement 1. Determine the fim's cost equation (use the output from the Excel regression). (Enter amounts to two decimal places. ) 0.75 Square y$ x$ Adiuslod R Square 0.70 Standard Error 181 56 Observations ANOVA Signhcance SS MS 0.0115 Rearession 498,803.13 498 803 13 15.13 164,798 07 Residual 32.959.37 683.600.00 Total Standard Lower Upper Coetticents Enor rStat P.value 95 % 95% 4,DB9 B Enter any number in the edit fields and then click Check Answer. Intercept 1954 29 826 89 2 38 -161 31 x Variable 1 0.20 0,05 .0: 0.07 0.36 parts remalning Clear All