Chapter 6 Homework (Sp 22) Question 4, E6-30A (similar to) Part 1 of 5 HW Score: 17.14%, 0.86 of 5 points O Points: 0 of 1 Save Kristen Rafferty, owner of Flower Mode, operates a local chain of foral shops. Each shop has its own delivery van instead of charging a flat delivery fee, Rafferty wants to set the delivery fee based on the distance driven to deliver the flowers 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 costs. Flower Mode does a megression analysis on the next year's data using Excel. The outpu (Click the icon to view the regression analysis) generated by Excel is as follows: Read the menta Requirement 1. Determine the firm's cost equation use the output from the Excel Regression analysis A C D E F 0 2 SUMMARY OUTPUT Regression Statistics Mule R 0.95 4R Square 09 5 Adjusted R Squar Standard E 037 124.99 7 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 R-squared 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 this cost estimate? Why or why net? 7 Observations ANOVA 10 Regression 11. 12 Tital Print Done 13 14ercept 15x Vebe Help me solve this Video Get more help. d 55 1 66800058 5 78.110.42 0000050 158220 4277 00013 6 74620000 Confe Sandante Ple 931.23 67887 137 623 028 0.04 854 0.00 Lower 93% 41307 017 Upper 5% 1.67633 030 Check