Home Announcements Assignments Discussions Grades People Syllabus Quizzes Modules Library Guides Office 365 Media Gallery - Kaltura Due Monday by 9am Points 55 Submitting a file upload File Types xls and xlsx See the videos on forecasting submission. Replicate the excel sheet to fit a forecasting model for mortality in the USA and use that to predict the excess deaths in the USA in 2020. Create similar predictions for any other two states in the USA. You need to upload one excel file only. The excel file that you submit must have three spreadsheets- one for USA and two for the other states. Each excel spreadsheet should indicate: (1) Method used to fit the previous data, (2) The MAD / MAE, MAPE or RMSE for the fitted data, (3) The forecast for 2020 using the appropriate method and (4) The excess total mortality from April 2020 to December 2020, Forecasting submission rubric Criteria Replication of the spreadsheet with USA data Should include (a) Raw data downloaded (b) Data plot of raw data (c) Data correction for days of the month (d) Noting the measures of accuracy with three methods (e)Forecasting mortality in 2020 (Apr 2020 to Dec 2020) (f) Calculating excess mortality Ratings Pts 9 to >0.0 pts Full Marks O pts No Marks: 9 pts State 1 data downloaded State 1 data plot State 1 data correction 4 pts Full O pts No 4 pts Marks Marks 4 to >0.0 pts O pts Full Marks No 4 pts Marks 4 to >0.0 pts O pts Full Marks No 4 pts Marks Spring 2024 Forecasting submission rubric Criteria Home Replication of the spreadsheet with USA data Should include (a) Raw data downloaded (b) Data plot of raw data (c) Data correction for days of the month (d) Noting the measures of accuracy with three methods (e)Forecasting mortality in 2020 (Apr 2020 to Dec 2020) (f) Calculating excess mortality Announcements Assignments Discussions Grades State 1 data downloaded People Syllabus State 1 data plot Quizzes Modules Ratings 9 to >0.0 pts Full Marks O pts No Pts Marks 9 pts 4 pts Full Marks O pts No Marks 4 pts 4 to >0.0 pts O pts Full Marks No 4 pts Marks Library Guides Office 365 Media Gallery - Kaltura State 1 data correction State 1 Forcasting accuracy use at least 3 criterion State 1 Forecasts 12 periods forecasted using the method of best fit State 1 Excess mortality 4 to >0.0 pts. O pts Full Marks No Marks 4 pts 4 to >0.0 pts O pts Full Marks No 4 pts Marks 4 to >0.0 pts Full Marks O pts No 4 pts Marks 3 to >0.0 pts O pts Full Marks No Marks 3 pts Spring 2024 Home Announcements State 1 Excess mortality 3 to >0.0 pts Full Marks Assignments Discussions O pts No 3 pts Marks State 2 data downloaded 4 pts Full Marks O pts No Marks 4 pts Grades State 2 data plot People Syllabus Quizzes Modules Library Guides Office 365 Media Gallery - Kaltura State 2 data correction State 2 Forcasting accuracy use at least 3 criterion State 2 Forecasts 12 periods forecasted using the method of best fit State 2 Excess mortality 4 to >0.0 pts Full Marks O pts No Marks 4 pts 4 to >0.0 pts Full Marks O pts No 4 pts Marks. 4 to >0.0 pts O pts Full Marks No Marks 4 pts 4 to >0.0 pts Full Marks O pts No 4 pts Marks 3 to >0.0 pts Full Marks O pts No Marks 3 pts Total Points: 55