Refer to number 3 of the Questions for Discussion section of the Revenue Forecasting in the City of Envy case. Use a regression analysis as demonstrated in the video of lesson 2 of this module to estimate revenues for years 16 and 17. Use line graphs to illustrate the revenue patterns for the jurisdictions listed that also include your forecasts. Show your work in a table format copied from your Excel calculations and pasted into the Word document that contains this assignment. Use the attached spreadsheet: Module4PartB.xlsx to set up and calculate your forecasts. Use the same format as shown in the Time Series Analysis.xlsx sheet from Module 4 Lesson 2. Hint: Use the Lesson 2 notes to assist you with your regression calculations. Use the City Utility Data graph in the Time Series Analysis sheet to assist you with your line graphs.

1 1