Requirement This assignment should be completed in Word

Subject:MathPrice:15.89 Bought3

Share With

Requirement

• This assignment should be completed in Word. However, you are required to record your statistical analysis in Excel with formulas or functions kept inside. In other words, you need to submit two files (Word and Excel) to me for grading. This is required since I want to make sure you clearly know how to run formulas or functions in Excelto conduct the statistical analysis, which is a core purpose for this course.

Content

The ongoing pandemic provides us with a proper scenario where the relationship between politics, public health crisis, and economic development can be investigated. The given data set includes the confirmed cases of COVID-19 every 100,000 people (case rate per 100,000) and the gross domestic product (GDP) per capita as of 2020 in three groups of states with different political affiliation (swing states, solid red states, and solid blue states). In this context, case rate per 100,000 and GDP per capita in 2020 are two relative strength indicators taking population size into consideration. Compared with the absolute strength indicators (total confirmed cases and GDP), the relative strength ones can best represent the status quo of public health crisis and economic development, enabling a valuable comparative analysis across states. Specifically, the given data set is used to answer the following questions:

• Calculate and compare central tendency and variability of case rate per 100,000 and GDP per capita in 2020 among swing, solid blue, and solid red states.
  • Please write out your observations and comments attached behind the below table regarding the comparison of confirmed cases of COVID-19 and economic development among swing, solid blue, and solid red states. For example, do swing states, on average, have more (or less) confirmed cases of COVID-19 and better (or worse) economic development than solid red and solid blue states? Are these observations or findings attractive to you? How will you justify these observations or findings? (Notes: Complete it in Word.)
  • Insert a new sheet in the given data set to place the new grouped data by political affiliation and case rate per 100,000. (Notes: Complete it in Excel.)
  • Follow the famous eight steps to test the hypothesis above. (Notes: Notes: Complete it in Word.)

• Use the flowchart in textbook to select the most appropriate test statistic to examine whether the means of case rate per 100,000 among three groups of states (swing states, solid red states, and solid blue states) are different.
• The ongoing pandemic brings up two critical questions requiring further examination. First, whether is there a relationship between the confirmed cases of COVID-19 (case rate per 100,000) and economic development (GDP per capita in 2020)? Second, the degree to which have the confirmed cases of COVID-19 (case rate per 100,000) affected economic development (GDP per capita in 2020)? The given sample data (24 states) will be used to answer the above two questions.
  • Use the correlation coefficient to examine the first question. You are NOT required to follow the famous eight steps to conduct the test statistic. Instead, you can use “Data Analysis Tools” in Excel to calculate the correlation. (Notes: Complete it in Excel.) (). However, you are REQUIRED to interpret and evaluate the correlation coefficient using “Thumb Rule”, “Coefficient of Determination”, and “Association versus Causality”. (Notes: Complete it in Word.) (
  • Use the regression analysis to examine the second question. Again, you are NOT required to follow the famous eight steps to conduct the test statistic. Instead, you can use “Data Analysis Tools” in Excel to get a regression equation or line that can reflect how the confirmed cases of COVID-19 (case rate per 100,000) affects economic development (GDP per capita in 2020). (Notes: Complete it in Excel.) (2 pts). However, you are REQUIRED to clearly and precisely state the independent variable, the dependent variable, slope and intercept, the regression equation, and a scatterplot that can visualize how the confirmed cases of COVID-19 (case rate per 100,000) affects economic development (GDP per capita in 2020). Finally, please calculate the predicted GDP per capita when the case rate per 100,000 goes up to 15,000. (Notes: Complete it in Word)