Refer to the Posies Unlimited data in E6- 45B. Use Microsoft Excel to run a regression analysis,

Question:

Refer to the Posies Unlimited data in E6- 45B. 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 Posies Unlimited’s R- square indicate?
3. Predict van operating costs at a volume of 17,000 miles.