Kim Smith, owner of Flowers 4 You, operates a local chain of floral shops. Each shop has is own dolivery van. Instead of charging a fat dolivery fee, Snith wants to set the delivery fee based an distance driven to deliver the flowers. Smith wants to soparate the foxed and variable pertions of her van operating costs so that she has a better idea how delivery diatance affects these cosss. Flowers 4 You does a regression analysis on the neat yoar's data using Excol. The output generated by Excel is as follows: Yhus the regression andind. Bead the rnguirements. Requirement 1. Delermine the firm's cost equation (une the output from the Excel regression). (Enter ameunts fo two decimal places.) y=x+ 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 Flowers 4 You's R-squared indicate? 3. Predict van operating costs at a volume of 15,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? Regression analysis