E6-28A (similar to) Question Help O Kim Meyer, owner of Flower Direct, operates a local chain of floral shops. Each shop has its own delivery van. Instead of charging a flat delivery tee, Meyer wants to set the delivery fee based on the distance driven to deliver the fowers. Meyer wants to separate the fixed and variable portions of her van cperating costs so that she has a better idea how delivery distance effects these costs. Flower Direct does a regression analysis on the next year's data using Excel. The output generated by Excel is follows: Click the icon to view the regression analysis.) Read the renuirements i Regression analysis Requirement 1. Determine the firm's cos: equation (use the output from the Excel regression). (Enter y = X D E F G 0.85 0.72 A B 1 SUMMARY OUTPUT 2 Regression Statistics 3 Multiple R 4 R Square 5 Adjusted R Square 6 Standard Error 7 Observations BANOVA 9 10 Regression 1 11 Residual 5 0.66 207.23 7 SS MS F Significance F 0.0181 545 575.49 12.71 545,a7a 49 214,721.51 42 944.30 6 760.600.00 12 Total 13 Coefficients Sla Pah Law 95% Upx 95% 4,077.64 947.20 Standard Error 1,217.78 0.08 14 Intercept 15 X Variable 1 0.78 -2,183.23 0.00 0.27 3.57 0.02 0.46 Enter any number in the edit reics and then click Check Answer, Print Done