Homework: Chapter 6 Homework (Sp 22) Question 4, E6-30A (similar to) HW Score: 43.38%, 2.17 of 5 points O Point 0 of 1 Save Kristen Rafferty, owner of Flower Mode, operates a local chain of floral shops. Each shop has its own delivery van Instead of charging a fat delivery fee. Rafferty wants to set the delivery fee based on the delance driven to deliver the fowers Rafferty wants to separate the fixed and variable portions of her van operating costs so that she has a better idea how delivery distance affects these coats Flower Mode dies a regression analysis on the next year's data using Excel. The pur generated by Excel folos (Click the icon to view the regression analy Read the trements Regression analysis Requirement 1. Determine the Smi's cost equation (use the output from the Excel regression) (Enter a A C D E " 0 2 SUMMARY OUTPUT Regression Statistica 3 Mutiple R 4 Square Requirements 1. Determine the firm's cost equation use the output from the Excel regression) 2. Determine the R-squared (use the output from the Excel regression) What does Flower Mode's Raquared indicate? 3. Predict van operating costs at a volume of 16,500 miles assuming the company would use the cost equation from the Excel regression regardless of R-squared Should the company rely on the cost estimate? Why or why 5 Adjusted R S Standard E 7 Observations ANOVA Print Done Help me solve this Video Get more help. ON 0.87 124.99 MS 10 Regression 660.00 56 11 Residual bl T110.42 600.000.58 15.622.08 4277 Significance F 80013 12 Tola 6 748,200.00 13 Coefficients Standard For Stat Avale 14 opt 15 Varable T 33123 029 78.87 137 823 054 6.54 8.00 Co% -81247 0.17 Coper% 2,623 Print Done