its own delivery van. Instead of charging a fat delivery fee, Rafferty wants to set the delivery fee based on the distance driven to deliver the that she has a better idea how delivery distance affects these costs Flower Mode does a regression analysis on the next year's data using Excel, The output Kraten Rafferty, owner of Flower Mode, operates a local chain of ford shops. Each shop has Rafferty wants to separate the fad and vartable portions of f generaled by Excel is as follows Read the requirements regression anatya van operating costs Regression analysis - x Requirement 1. Determine the firm's cod equation (use the output from the Excel regression) (Enter and 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 its R-squared. Should the company rely on this cost estimate? Why or why not? Print Done Help me solve this Video Get more help. A D D 4 2 SUMMARY OUTPUT Regression Statistics 3 Multiple 095 X RSquare 09 Adjusted Square 087 Standard Emer 124.00 7 Observations ANOVA MS P Significence 10 Mogression 6680805 11 Resu " 78,110.42 660.000.50 15622.08 42.77 0.0013 12 Tota 746,200.00 13 Coeficients Standard Error 1 Shad Lower 95% Upper 14 Intercept 15X Varable 1 831.23 0.28 678.87 137 0.23 01387 2.676.33 0.04 654 0.00 017 0.39 Print Done