In this analysis you will use the data collected to track the development of COVID-19 in the state of Missouri.

The data is available in the following file: MO_COVID.xlsx

This file contains data on COVID-19 tests performed during Fall 2020, along with the number of hospitalizations and available ICU beds in the same period.

Use the data to answer the following questions:

1. What is the predicted number of ICU beds available for Oct-W4?
2. What is the predicted number of tests for Oct-W4?
3. What is the predicted number of hospitalizations for Oct-W4?

According to the rubric below, the report should include 4 sections, see below for important information about what to include in each section:

1. Introduction: Provide background and motivation about the problem we are analyzing, why should we care about this analysis?
2. Descriptive Statistics: Include a table with summary statistics of all the data, describe the statistics in the table. Since this is a forecasting analysis, you must include a plot of all variables you are forecasting
3. Methods: Name the methods used for all forecasts, and why you selected each method.
4. Results: Present the forecasted values, along with error metrics obtained, discuss the results and their implications.

You may use the following templates to conduct your analyses:

• Forecasting Horizontal Patterns
• Forecasting Trend and Seasonality