\begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ Regression Statistics } \\ \hline Multiple R & 0.85 \\ R Square & 0.72 \\ Adjusted R Square & 0.67 \\ Standord Error & 184.41 \\ Obseivations & 77 \\ \hline \end{tabular} \begin{tabular}{lr} R Square & 0.72 \\ Adjusted R Square & 0.67 \\ Standard Error & 184.41 \\ Observations & 7 \\ \hline \end{tabular} ANOVA \begin{tabular}{|c|c|c|c|c|c|} \hline & dI & S5 & MS & F & Significance F \\ \hline Regression & & 43905633 & 439056.33 & 1291 & 0.457 \\ \hline Residual & & 17002936 & 3400568 & & \\ \hline Iotal & & 60905571 & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline & Coetficients & Stand & ard Error & tStat & P-value & Lower 954 & Upper 95%. & Lower 95.0s: & Upper s5 on \\ \hline Intercept & 757.43 & + & 120598 & 0.59 & 0.58 & -2540.27 & 406314 & 254327 & \\ \hlinex Variable 1 & 027 & & 0,08 & 359 & 002 & 0.05 & 047 & 0,05 & \\ \hline \end{tabular} Alice Coughin, owner of Rose Red operates a local chain of flocal shiops. Each shop has its own delvery van finstead of charging a fiat delwery fee, Coughlih wants to set the delivery fee based on the distance diven to dether the flowers. Coughin wants to separate the foxed and varisble portigns of hes van operating costs so that she has a better idea as folows (Click the icon to view the regression analysis.) Requiremeats 1. Determine the frimis cout equasion (use the output fram the Excel regression) 2. Determine the R-square (use the output from the Excel regession) What does Rese Reda Rsquace hacale? 3. Pissic van operating. costs at a volume of 17,000km