Kate Reynoils, owner of Rose Ready, operates a local chein of flocal shops. Each shop has is own delivery van. Insteed of charging a flat delivesy fee, Reynoids wants to ser the deivery loe based costs. Rose Ready does a regroseion analysis on the next year's data using Ficel The output penerates by Excel is as followa: liew the regcoseon andives. Soed the requirerente. equirement 1. Dotermine the firmin cost equation (use the cutbut from the Exoel regression). (Enter amounts to two decimal piacns) Requirements 1. Detemine the firmis cost equation (use the output from the Excel rogression) 2. Detemine the R-seguaced (use the output from the Exotl regression) What does Rose Ready's R-squared insicale? 3. Predict van operating costs at a wolume of 17,050 miles assuming the company would use the oost equation from the Excei regreasicn ragardless of its R-squared. Should the company rely on this cost esimate? Why or why not? on the distance driven to deliwer the flowers. Reynolds Wans to separate the fowed and variable portons of heady does a regression analysis on the next year's data using Exoel. The output generated by Excel is as foliows: Yew the cogressich anatysis. Bead hereguitements. Requirement 1. Determine the firm's cost equabion (use y=x+ Regression analysis