3 of 4 Horal shops. Each shop has its own delivery van. Instead of charging a flat delivery fee, Reynolds wants to se tions of her van operating costs so that she has a better idea how delivery distance affects these costs. She h 6 Requirements -X he Use Microsoft Excel to run a regression analysis, then do the following 1. Determine the company'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.000 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 its R-squa 000 next question a O e hop myUT 3 of 4 of floral shops Ea 1 . portions of her var qe, Reynolds wants to set the ffects these costs. She has t Data Table - X the output from the Month om the Excel regress January February March April May June Miles Driven 16 000 17 500 14 900 16 200 16.900 15 100 Van Operating costs 55 490 $5.700 $4 910 $5.340 $5,820 $5.410 V of the variability July 14.500 $4.920 Mode feel cor 16.000 miles assumin regardless of its R-squared SH Done the next