(Solved): The following are sales revenues for a large utility company for years 1 through 11 . Forecast reve ...

The following are sales revenues for a large utility company for years 1 through 11 . Forecast revenue for years 12 through 15 . Because we are forecasting four years into the future, you will need to use linear regression as your forecasting method. Note: use Excel "Data Analysis" to find out the values of "a" and " $$b$$ " first in $$Y=a+b$$ " $$X$$, where $$X$$ is the Year, i.e. $$1,2,3,4,\dots \dots$$ 5723 1. Year 12 5779 2. Year 13 5892 3. Year 14 4. Year 15 5835