Refer to the Flower Power data in E6- 26A. Use Microsoft Excel to do the following:

Requirements
1. Run a regression analysis.
2. Determine the company€™s cost equation (use the output from the Excel regression).
3. Determine the R- square (use the output from the Excel regression). What does Flowers Power€™s R- square indicate?
4. Predict van operating costs at a volume of 16,000 miles.

In E6-26A

Month January February March ...uu. April May.. une July Miles Driven 16,000 17,500 14,900 16,200 16,900 15,100 14,500 Van Operating Costs 55,490 $5,700 $4,910 $5,340 55,820 55,410 $4,920