I​‌‍‍‍‌‍‌‍‍‍‌‌‌‍‌‌‌‌‌‌​n this assignment, you will practice forecasting by repli

I​‌‍‍‍‌‍‌‍‍‍‌‌‌‍‌‌‌‌‌‌​n this assignment, you will practice forecasting by replicating the time-series forecasting of death rates for Montgomery County, OH for 2020. The forecasting sample is shown in your module notes. Here is your data sheet Download data sheet. The sample includes data for each county in Ohio. Please use Excel to create your own 2020 forecast for Montgomery County only. You will have to enter​‌‍‍‍‌‍‌‍‍‍‌‌‌‍‌‌‌‌‌‌​ only the Montgomery County data and years in your spreadsheet, from 2010 through 2020.
Please review the video clip below to help walk you through how to conduct the forecast analysis using Excel. Once you have 2020 forecasted, create a scatterplot including a regression line showing the data for Montgomery County.
Submit your excel file including the data set with forecast and graph​‌‍‍‍‌‍‌‍‍‍‌‌‌‍‌‌‌‌‌‌​.