In 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.
M3.5 Excel and Forecasting Rubric
M3.5 Excel and Forecasting Rubric
Criteria Ratings Pts
This criterion is linked to a Learning OutcomeRegression
45 pts
Exemplary
Your regression has been run accurately for the data set. Output variables are clearly identified
31 pts
Progressing
Your regression has been run for the data set. Output variables are identified. There are some errors.
0 pts
Not addressed or not submitted
Your regression is missing or completely inaccurate.
45 pts
This criterion is linked to a Learning OutcomeScatterplot and Regression Line
45 pts
Exemplary
Your scatterplot is present, accurate, and includes your regression line.
31 pts
Progressing
Your scatterplot and regression line are present. There are some errors.
0 pts
Not addressed or not submitted
Your scatterplot and regression line are missing or completely inaccurate.
45 pts
This criterion is linked to a Learning OutcomeDue date
10 pts
Exemplary
Submitted by due date
8 pts
Proficient
Submitted one day after due date.
6 pts
Progressing
Submitted two to four days after due date.
4 pts
Incomplete
Submitted 5-6 days after due date.
0 pts
Not addressed or not submitted
Submitted 7 or more days after due date.
10 pts
Total Points: 100
