Part 3. Regression Analysis

Regression Analysis. Regression analysis was run using the same data for the city of Rockville.

1. Use the regression output to develop the cost equation Y = f + vX by filling in the dollar amounts for f and v.

2. What would the city of Rockvilles estimated costs be if its trucks drove 500,000 miles in year 7?

Reporting Period (Year)	Total Costs	Level of Activity (Miles Driven)
Year 1	$ 750,000	225,000
Year 2	850,000	240,000
Year 3	1,100,000	430,000
Year 4	1,150,000	454,000
Year 5	1,250,000	560,000
Year 6	1,550,000	710,000

Please help me solve this question! PLEASE do not use high low method nor scatter-graph method. This is specifically for regression analysis.

THANK YOU!