Data Table Month Miles Driven Van Operating Costs 15,500 $5,400 January February.. $5,350 17,500 14,400 March. $4,980 April 16,400 $5,280 May 16,900 $5,580 June 15,300 $5,010 July.. 13,500 $4,590 Print Done Kallic Rafferty, owner of Rose Red, aperates a local chain of floral shops. Each shop has its gran 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 deivery distance affects these coate. She has the following data from the past seven months. Click the icon to view the data.) Read the requirements. Requirement 1. Determine the company's cost equation (use the autout from the Excel regression (Round the amounts to two decimal places.) Requirement 2. Determine the R-aquare (use the output from the Excel regression) The square is 7 What does Rose Rod's R-equere indicate? The square indicates that the cost equation explains of the variability in the data. In ather words, it Rose Red feel confident using this cast equation to predict total costs at other volumes within the same relevant range Requirement 3. Predict ven cperating coata at & volume of 17.000 miles assuming the company would use the cost equation from the Excel regression regardless of its R-equere should the company rely on this cost estimate? Why or why not? Round your answer to the nearest cant.) The aperating costs at a volume af 17,000 miles is $ Should the company rely on this cost estimate? Why or why nat? Since ther-square is 7. the company