# 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
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

Pages (275 words)
Standard price: \$0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back