BUS-352-RS-CLC-COVID_in_Arizona-Student-Jazmin Lopez

CLC – Exploring COVID-19 in Arizo Overview Tasks (All students must complete this section individually) Instructions for Data Analysis Portion 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 2. How many in the "Total on Ventilators" were in the selected month from the pivot table (count for Response CFR)? 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 <= x <= 7)? During the early stages of the COVID-19 pandemic, many hospitals worldwide became insufficiently stocked with necessities t beds. To investigate the hospital circumstances surrounding the peak stages of COVID-19 in Arizona, you will analyze ventilato Tracking Project by The Atlantic. The dataset was compiled for June 2020 through February 2021 and is attached in the Excel a You will use the DCOVAS framework. Reference readings in The Statistician In You: 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. 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 documen Select randomized sample for "Current Hospitalized." 1.        On the "RawData" tab, click the drop down arrow in the "Record Shuffler" column and select "Sort Smallest to Largest" (a 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. ·          Each team member should complete the binomial distribution and Poisson distribution sections using a different month o ·          Each team member will use their individual sample of 50 "Current Hospitalized" to get a descriptive statistics table from E ·          The "Comparison of Samples to Population Analysis" and the "Putting It All Together" sections can be distributed across g ·          Each student's "Analysis" results should be copied and pasted into the appropriate area of the "SummaryResults" tab, wh 1. How many in the "Total in ICU" column were in the selected month from the pivot table (sample size n)? 3. If we assume being on a ventilator as a success, what is the rate of success in your sample (sample proportion p)? This refle Using the success rate p from above, for any given day and a random sample of 10 ICU patients across Arizona, use the binom

Poisson Distribution Columns F and G in the Analysis tab are there if you wish to calculate individual probabilities to answer the questions, rather th 7. What is the Average Deaths per day in the selected month from pivot table (μ)? Assuming the number of deaths per day are relatively consistent within any month, use the Poisson distribution to calculate th 8. What is the probability of exactly 20 deaths in one day of the selected month? P(x = 20)? 9. What is the probability of less than 20 deaths in one day of the selected month? P(x < 20)? 10. What is the probability of 40 or more deaths in one day of the selected month? P(x >= 40) 11. What is the probability of 120 or more deaths in one day of the selected month? P(x >= 120) 12. What is the probability of deaths on one day of the selected month being between 10 and 40? P(10 <= x <= 40) Probabilities of Sampling Distributions 13. What is the probability of the sample mean from 50 random days being fewer than 2,000 patients hospitalized? 14. What is the probability of the sample mean from 50 random days being more than 2,000 patients hospitalized? 15. What is the probability of the sample mean from 50 random days being fewer than 3,000 patients hospitalized? 16. What is the probability of the sample mean from 50 random days being between 1,500 and 2,500 patients hospitalized? 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: As a group, prepare and submit ONE group PowerPoint presentation (8-12 slides). The presentation should include s Deliverables Using your random sample of 50 records from the variable "Current Hospitalized" that you pasted into Column A in the "Analy into the "Analysis" tab where indicated (Column C below Poisson calculations). Copy the entire "Current Hospitalized" column in the "RawData" tab and paste into Cell T1 of the "SummaryResults" tab. Run descriptive statistics from Excel's Data Analysis Tool on the entire "Current Hospitalized" column and paste the summary t Copy each team member's "Sample" tables Into the "SummaryResults" tab cells as indicated in the worksheet. Change "Stude 17. What is the sampling error each team member experienced compared to the population mean? Recall from Chapter 7 in E Sample Mean - Population Mean · Create a roles and responsibility slide. · Explanation of all DCOVA elements. · Include a screenshot of the pivot table and bar chart located in the “RawData” tab. Include your group’s initial viewpoint · Create a slide to comment on the binomial and Poisson result differences that you noticed in in each team member's cal ventilators? How can the data regarding deaths per day during a peak month of the pandemic help officials to understand the capacity for ICU beds, ventilators, or other hospital-related needs? Are there any patterns or trends that you can validate with addressed in this study? · Create a summary slide to compare the population descriptive statistics of current hospitalized to the individual sample incurred? What was the range of the sampling means and how did the population mean compare to them? Would the samplin unavailable? Be sure to include your reasoning. Research two or more sources that validate your summary slide. · Add a reference slide and include two or more references. Note : Each student should use their own sample to answer their assigned section(s). Each team member's Excel file ("Analysis submitted.

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. · One group PowerPoint presentation (8-12 slides)that includes all the components as listed in "Tasks" section. Data adapted from “The COVID Tracking Project: The Data: Arizona,” by The Atlantic , 2021 (https://covidtracking.com/data/st Commons CC BY 4.0 license.

Date State 2/22/2021 AZ 0 1590 478 299 0.4676 12/23/2020 AZ 54 4163 972 673 0.9623 12/17/2020 AZ 147 3884 899 618 0.4050 8/24/2020 AZ 0 908 345 176 0.9563 1/9/2021 AZ 98 4918 1121 791 0.1008 9/10/2020 AZ 22 628 204 120 0.6692 1/29/2021 AZ 203 3970 1002 678 0.9644 2/8/2021 AZ 7 2853 828 536 0.7083 2/4/2021 AZ 176 3303 946 618 0.3101 8/28/2020 AZ 49 809 272 160 0.5870 2/17/2021 AZ 82 1941 593 354 0.8644 6/27/2020 AZ 44 2577 657 433 0.1201 10/10/2020 AZ 13 685 145 71 0.6725 6/1/2020 AZ 11 968 377 238 0.2820 2/7/2021 AZ 37 2910 838 561 0.1448 1/2/2021 AZ 46 4484 1074 761 0.0947 7/11/2020 AZ 69 3485 899 620 0.9883 7/23/2020 AZ 89 2966 851 617 0.4021 8/26/2020 AZ 104 967 305 180 0.6347 10/28/2020 AZ 14 871 188 94 0.7849 10/29/2020 AZ 13 874 186 95 0.5901 7/30/2020 AZ 172 2348 758 531 0.3072 9/21/2020 AZ 2 472 119 57 0.3357 1/14/2021 AZ 182 4930 1167 821 0.6395 1/28/2021 AZ 176 4087 1023 692 0.9768 8/16/2020 AZ 14 1208 417 267 0.2414 12/11/2020 AZ 91 3482 809 508 0.2012 8/12/2020 AZ 148 1469 519 328 0.0636 10/5/2020 AZ 1 567 134 57 0.8732 6/8/2020 AZ 3 1266 390 246 0.8897 10/8/2020 AZ 10 728 156 63 0.3873 10/18/2020 AZ 3 714 176 85 0.0360 11/21/2020 AZ 30 1916 435 253 0.6595 10/4/2020 AZ 1 545 133 59 0.6980 9/29/2020 AZ 9 540 119 64 0.9614 7/19/2020 AZ 31 3136 894 622 0.1343 8/18/2020 AZ 23 1167 427 260 0.1113 11/18/2020 AZ 53 1700 396 218 0.7779 8/21/2020 AZ 4 1068 365 234 0.3005 12/7/2020 AZ 0 3059 736 459 0.7228 11/22/2020 AZ 7 1932 438 256 0.1699 New Deaths Reported Current Hospitalized Current in ICU Current on Ventilator Record Shuffler <-- Sort

6/3/2020 AZ 40 1092 379 239 0.2965 7/14/2020 AZ 92 3517 970 674 0.0452 8/19/2020 AZ 105 1160 414 250 0.1189 1/10/2021 AZ 105 4988 1122 791 0.9754 12/29/2020 AZ 171 4475 1053 720 0.9404 2/3/2021 AZ 214 3456 955 646 0.6963 7/10/2020 AZ 44 3432 876 615 0.1286 6/23/2020 AZ 42 2136 614 386 0.6347 7/4/2020 AZ 17 3113 796 413 0.8179 1/6/2021 AZ 127 4877 1084 747 0.9229 6/18/2020 AZ 32 1667 540 341 0.6377 8/11/2020 AZ 45 1574 510 346 0.4987 9/22/2020 AZ 20 527 122 47 0.0683 2/23/2021 AZ 148 1515 447 266 0.9133 10/22/2020 AZ 5 848 164 92 0.2684 2/25/2021 AZ 121 1385 415 241 0.9042 10/3/2020 AZ 12 605 127 52 0.0710 6/4/2020 AZ 15 1079 375 223 0.6971 8/8/2020 AZ 56 1659 539 400 0.9121 6/19/2020 AZ 41 1832 519 362 0.5223 11/27/2020 AZ 20 2301 532 325 0.9989 2/9/2021 AZ 231 2744 797 524 0.3932 9/30/2020 AZ 18 560 115 55 0.1985 1/30/2021 AZ 76 3828 984 645 0.7364 6/30/2020 AZ 44 2793 683 455 0.5404 10/20/2020 AZ 7 777 170 91 0.5038 10/2/2020 AZ 19 586 125 48 0.9481 12/1/2020 AZ 48 2594 597 369 0.0680 9/26/2020 AZ 35 509 115 56 0.9987 2/28/2021 AZ 13 1251 402 210 0.4824 9/5/2020 AZ 36 702 225 131 0.6799 8/13/2020 AZ 36 1411 497 334 0.4190 6/6/2020 AZ 30 1278 391 292 0.8534 11/7/2020 AZ 38 1139 249 137 0.9362 7/16/2020 AZ 58 3454 918 657 0.6911 11/20/2020 AZ 43 1835 431 244 0.7843 12/28/2020 AZ 42 4390 1007 715 0.4806 10/21/2020 AZ 17 832 171 91 0.5537 2/24/2021 AZ 43 1449 430 253 0.9019 1/22/2021 AZ 229 4495 1054 739 0.7044 9/9/2020 AZ 30 658 203 111 0.1389 12/3/2020 AZ 82 2743 642 386 0.6679 11/25/2020 AZ 9 2217 531 335 0.4301 11/15/2020 AZ 2 1506 368 183 0.1651