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

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

Transcribed Image Text:

Month January Februar March Kilometres Driven 15,800 17,300 14,600 16,000 17,100 15,400 14,100 Van Operating Costs $5,460 5,680 4,940 5,310 5,830 5,420 4,880 pri May July..