Refer to the Flowers Direct data in E6-53B. Use Microsoft Excel to run a regression analysis, then

Question:

Refer to the Flowers Direct data in E6-53B. Use Microsoft Excel to run a regression analysis, then do the following calculations:
Requirements
1. Determine the firm's cost equation (use the output from the Excel regression).
2. Determine the R-square (use the output from the Excel regression). What does Flowers Direct's R-square indicate?
3. Predict van operating costs at a volume of 15,500 miles.