to deliver the flowers Buite angol. The pred Kali Batte, owner of Tulip Time, operates a local chain of floralshops. Each shop has its own delivery van. Instead of charging a fal ellery for Bare wait to set the delivery fee based on the danced wants to separate the food and variable portions of her an operating costs so that she has a better idea how delivery distance affects theseos Tulip Time does regression analysis on the rest year's d by Excel is as follows: Click the icon to view the regression analysis) Requirements 1. Determine the firm's cost equation use the old from the Excel regression) 2. Determine the square the output from the Excel regression) What does Times-sure indicare? 3. Predict van operating costs a volume of 16.500 miles assuming the company would use the cost equation from the Excel regression regardless of thout the company rely on this why or why no Requirement 1. Determine the firm's cost in the out from the Eol regression. Entramounts to two decimal places) y- $ 0.20 028 29 Requirement 2. Determine the R are use the output from the Excel regression The square is OT13077 the besed with c on To The may or may not feel content What does Tulip Time r nice? The quare indicates that the couleuion plans of the variability in the data in volumes within the servantage Requirements. Predic t ing cost volume of 16.500 assuming the company w (Round your a wer to the nearest cont) The song cool at volume of 6.500 l e on from Icelregressions that they want ? www EGITEgressi 6,500 miles assumi on (use the output fid SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations he con output from the Ex 0.86 0.75 0.70 174.75 ANOVA lains 74.6% of the df Regression Residual rolume of 16,500 F SS 448,647.94 152,694.92 601,342.86 MS 448,647.94 30,538.98 Significance F 14.69 0.0122 Total pnfident using $ re. Should the Standard Error Coofficients 1028.28 Intercept Lower X Variable 1 1.131.33 0.07 1 Stat 0.91 3.83 P-value 0.41 0.26 Upper 95% 95% -1,879.90 0.09 0.01 3,936.46 # Check Answer. 0.43 Print Done