Case study

Case Study – COVID-19 - PART I – DUE AT THE END OF WEEK FOUR

Part I of the case will take the most time. I advise you to start working on your research ASAP.

You are being provided an Excel spreadsheet with USA COVID-19 numbers of confirmed cases, and

numbers of deaths since the first confirmed case on January 21, 2020. For this case, you will be using the

data provided for the month of March only.

Case Study 1 is due at the end of week four. You have 4 weeks to work on the part I of the case. Part II

and Part III will be a continuation and conclusion of Part I. Part II will be due at the end of week six, and

Part III and last will be due at the end of the term (last day of classes). Each part is worth 5% of your final

grade. However, without Part I completed, you will not be able to complete Part II and Part III.

Requirements for Part I

1. SAMPLING AND DATA:

a. Research number of COVID-19 confirmed cases in your state for the month of March.

b. Sample the information by state.

c. Record the data in Excel for number of cases and number of deaths.

d. Write an introduction by describing what will be the purpose of your case study. Include

some raw data, basic percentages (frequency), and overall information to search on the

case.

- For example, as of 2019, the United States of America had a population of

328.2 million people. The state I live, Texas, as of 2019, had a population of 29

million people. At the end of March, the US had 164,620 confirmed cased.

Therefore, 0.05% (164,620/328,200,000) of the population was infected. The

number of confirmed cases for Texas at the end of March was 3,266 cases.

Therefore, 0.01% of the population in Texas was infected. Let’s say I would

compare Texas numbers to New York number (state wise). What could you

briefly tell us about your state compared to other states in the US as of March

2020?

2. DESCRIPTIVE STATISTICS: CHARTS, HISTOGRAMS, PLOTS, COMBO CHARTS (this is the body of the

case)

a. Make charts for the data provided by me for number of cases, and charts for the data

collected by you for number of cases. You will choose the chart that fits best in your eyes

to convey the message. (Hint: do a little research on COVID-19 statistics to see the most

common charts to present the data).

b. Make charts for the data provided by me for number of deaths, and charts for the data

collected by you for number of deaths. You will choose the chart that fits best in your eyes

to convey the message. (Hint: do a little research on COVID-19 statistics to see the most

common charts to present the data).

c. Once you have inserted charts for both data series, what can you conclude? In sentences

(written) analysis, describe the information. Did the numbers of confirmed cases for the

country grow faster in comparison to your area? Did they grow slower?

d. What are the advantages of presenting the data in charts? What are the disadvantages?

3. PROBABILITY:

a. By looking at all charts presented, and providing us a contingence table (you might need

to include a few more states to achieve this part), what can you tell us? What should we

expect based on March’s numbers? What is the probability of numbers of cases and

deaths getting higher? What is the probability of numbers of cases and deaths getting

lower?

4. DISCRETE RANDOM VARIABLE:

a. Compute the means, medians, modes, minimums, maximums and standard

deviations for your state data and the state that you used for comparison at the

beginning of your analysis. Which state has the highest mean number of cases? The

lowest? Which state has the highest mean number of deaths? The lowest?

b. Based on standard deviations numbers, what does it tell us? How is it useful?

Case Study – PART II – DUE AT THE END OF WEEK SIX

TBA

Case Study – PART III – DUE AT THE END OF WEEK EIGHT

TBA