using Excel. The output generated by Excel is as follows:

View the regression analysis.

Read the requirements.

Requirement $1.$ Determine the firm's cost equation $($use the output from the Excel regression$).$

Requirements

Determine the firm's cost equation $($use the output from the Excel regression$).$

Determine the R$-$squared $($use the output from the Excel regression$).$ What

does Rose Red's R$-$squared indicate?

Predict van operating costs at a volume of $17,000$ 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?

Regression analysis