How does vaccination impact the nation-COVID19_Cases_in_the US_ MATH-Statistics

In the last tab you will find weekly data about COVID19 cases in the US (data is from the World Health Organization WHO). We are interested in finding out how does vaccination impact the nation. Consider "# of Vaccines administered per week" as your independent variable. Use single linear regression, for analyzing the relationship between "# of Vaccines administered per week" and each of the following dependent variables: 

1. Y = number of confirmed cases
2. Y = number of confirmed deaths
3. Y = number of hospitalizations

QUESTIONS:

1. Use regression results to identify
2. If "# of vaccines administered" has a statistically significant effect on any of the above.
3. For which one of the dependent variables, "# of Vaccines administered per week" is a better indicator.

Insert screenshots of your summary outputs here.

explain how you could justify the results and what does your findings imply. 

1. Perform the same three regression analysis but instead of "# of Vaccines administered per week," use the "cumulative # of vaccines administered " as your independent variable. Comparing these results with that of part A, which one is a better indicator for each of the outcomes: # of Vaccines administered per week, or  cumulative # of vaccines administered?

Insert screenshots of your summary outputs here.

1. How many people in total should be vaccinated in the United States to bring down the # of hospitalizations due to COVID to zero?