Kate Meyer, owner of Flower Direct, operales a local chain of florai shops. Each shop has its own deivery van. Inssead of charging a fit delivery fee, Meyer warts to sel the delivery fee bated on the distance driven to doliver the flowers. Meyer wants to separate the fixed and variable pertions of her van operating costs so that she has a better idea how delivery distance affects these costs. She has the folowing data from the past seren months: FFich (cick the icon to viow the data.) Read the tequirements Requirement 1. Determine the company's cont equation (use the oulput from the Excel regression). (Round the aimounts to two decimal places.) y= Requirement 2. Determine the Rsquared (use the oulput from the Excel regression) The R-squared is What does Flower Diecrs R-squared indeale? The R-squared indcales that the cost equation explains of the variabelty in the data, in other words, it this cost equabon to predid total costs at other volumes within the same relovant range Requirement 3. Predict van operating costs at a volume of 15,500 miles astuming the compary would use the cost equation from the Excel regression regardiess of its R-squared. 5 hould ihe company rely on this cost estmate? Why or why not? (Round your antwor to the nearest cent) The operating costs at a velume of 15,500 miles is Should the company cely on this cost essmate? Why or why not? Since the R-squared is the compary Requirements 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 Direct'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? Data table