# Grand Canyon University CLC Exploring COVID 19 in Arizona Paper

This is a Collaborative Learning Community (CLC) assignment.

Follow the instructions found in the “CLC – Exploring COVID-19 in Arizona” Excel spreadsheet.

While APA style is not required for the body of this assignment, solid academic writing is expected, and documentation of sources should be presented using APA formatting guidelines, which can be found in the APA Style Guide, located in the Student Success Center.

This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.

“Hey guys,

I’m checking in as well. It looks like there is a lot of work we each need to do individually for this assignment, so we will definitely want to start on that part early. Once each team member has completed their sections we should upload here so that whoever we decide to turn in the homework can add the data to the applicable section and get it turned in with the PowerPoint. I can do the Include a screenshot of the pivot table and bar chart located in the “RawData” tab. Include your group’s initial viewpoints. Are there any patterns or trends that you can validate with COVID-19 research? section of the PowerPoint.

KF

Kendra Fahringer7:16 PM

Banipal,

If you want to do the Create a roles and responsibility slide and the Explanation of all DCOVA elements you would be able to complete those for the most part without waiting on everyone to upload their sections of the assignment.

-Kendra”

CLC – Exploring COVID-19 in Arizona

Overview

•

•

•

•

•

•

Define the problem.

Collect data from the appropriate source(s).

Organize data using tables.

Visualize data using a chart or graph.

Analyze data using a tool and/or calculation(s).

Solution: Provide a conclusion and solution.

Tasks (All students must complete this section individually)

2.

3.

Copy the first randomized 51 rows of “Current Hospitalized” (Column D) to include the label.

Paste the 51 rows into the tab “Analysis” cell A1 as indicated. You should have 50 records.

Instructions for Data Analysis Portion

Questions

Binomial Distribution

1. How many in the “Total in ICU” column were in the selected month from the pivot table (sample size n)?

4. What is the probability that exactly 5 of them are ventilated? P(x = 5)?

5. What is the probability that more than 5 are ventilated? P(x > 5)?

6. What is the probability that between 4 and 7, inclusive, are ventilated? P(4 = 120)

Probabilities of Sampling Distributions

Comparison of Samples to Population

18. What is the range of the sample’s means? Does the population mean fit within this range?

Putting It All Together:

·

·

Create a roles and responsibility slide.

Explanation of all DCOVA elements.

·

Add a reference slide and include two or more references.

Deliverables

As a group, one person needs to submit:

·

Each student’s Excel file with all the tables, graph, and calculations as listed in “Tasks” section.

CLC – Exploring COVID-19 in Arizona

Overview

During the early stages of the COVID-19 pandemic, many hospitals worldwide became insufficiently stocked with

necessities to take care of patients. There were concerns about the availability of ventilators and hospital beds.

To investigate the hospital circumstances surrounding the peak stages of COVID-19 in Arizona, you will analyze

ventilator usage, deaths per day, and hospital bed usage for COVID-19 using a data set from The COVID Tracking

Project

dataset was

compiled

for Junein2020

through February

and

is attached

in the

You willby

useThe

theAtlantic.

DCOVASThe

framework.

Reference

readings

The Statistician

In You: 2021

Simple

Everyday

Life-Hacks

(TSIY).

•

•

•

•

•

•

Define the problem.

Collect data from the appropriate source(s).

Organize data using tables.

Visualize data using a chart or graph.

Analyze data using a tool and/or calculation(s).

Solution: Provide a conclusion and solution.

Tasks (All students must complete this section individually)

Review the provided pivot table and bar chart on the “RawData” tab.

What are your initial observations of the pivot table and bar chart information that is provided? (Your opinion

will be documented in a PowerPoint slide in the “Solution” section.)

Select

sample

“Current

Hospitalized.”

1. Onrandomized

the “RawData”

tab,for

click

the drop

down arrow in the “Record Shuffler” column and select “Sort Smallest

to Largest” (ascending).

2. Copy the first randomized 51 rows of “Current Hospitalized” (Column D) to include the label.

3. Paste the 51 rows into the tab “Analysis” cell A1 as indicated. You should have 50 records.

Organization has been provided for you in the pivot table in the “RawData” sheet.

Visualization has been provided for you in the “RawData” sheet.

Instructions for Data Analysis Portion

• Each team member should complete the binomial distribution and Poisson distribution sections using a

of data shown

the pivot

table.sample of 50 “Current Hospitalized” to get a descriptive

•different

Eachmonth

team member

will useintheir

individual

table from Excel’s

Data Analysis

Tool toAnalysis”

completeand

thethe

sampling

distribution

section.

•statistics

The “Comparison

of Samples

to Population

“Putting

It All Together”

sections can be

across group

members

so should

that each

is assigned

at least

portion/activity.

•distributed

Each student’s

“Analysis”

results

be student

copied and

pasted into

the one

appropriate

area of the

“SummaryResults” tab, which will be part of the comprehensive PowerPoint presentation.

Questions

Binomial Distribution

Columns F and G in the “Analysis” tab are there if you wish to calculate individual probabilities to answer the

questions rather than using the cumulative functions shown in the tables in Column C.

1. How many in the “Total in ICU” column were in the selected month from the pivot table (sample size n)?

2. How many in the “Total on Ventilators” were in the selected month from the pivot table (count for Response

CFR)?

3. If we assume being on a ventilator as a success, what is the rate of success in your sample (sample

proportion p)? This reflects the percentage of patients who were ventilated.

Using the success rate p from above, for any given day and a random sample of 10 ICU patients across Arizona,

use the binomial distribution to calculate the following probabilities:

4. What is the probability that exactly 5 of them are ventilated? P(x = 5)?

5. What is the probability that more than 5 are ventilated? P(x > 5)?

6. What is the probability that between 4 and 7, inclusive, are ventilated? P(4 = 120)

12. What is the probability of deaths on one day of the selected month being between 10 and 40? P(10