Big data can play an essential role in community and population health. Using the data sets in Table 11.3, determine what relationship, if any, may exist between the unemployment rate, number of COVID admits, community COVID immunization rates, and patient age at hospital admission. How might you present this data to a group of healthcare executives? What type of chart would you use? What questions might you anticipate you will be asked about the data?

Transcribed Image Text:

TABLE 11.3 Data Table for Critical Thinking Exercises Datasets Available for Medical-Surgical Unit, Year/ Quarter Average patient acuity score (1=low, 5-high) Average number of patients per nurse Y1Q1 Lawsuit total for patient negligence 3.00 Unit-budgeted HPPD 8.00 8.00 8.00 RN average hourly salary PCT/CNA average hourly salary Unit assistant average hourly salary Average patient census Staffing fines by state department 0.00 of public health 5.00 Y1QZ Y1Q3 0.00 Average patient length of stay (in 2.30 days) 2.00 3.00 5.00 8.00 8.10 $55.50 $55.50 $55.50 $61.85 $61.85 $61.85 $19.75 $19.75 $19.75 $19.75 $19.75 $19.75 $14.25 $14.25 $14.25 $14.25 $0.00 $0.00 Y1Q4 YZQ1 Y2Q2 4.00 3.80 5.60 0.00 3.10 0.00 $120K $250K 0.00 $250K 2.30 3.00 1.95 4.20 0.00 1.00 0.00 2.60 8.10 3.90 0.00 0.00 2.75 30.00 27.00 26.00 32.00 26.00 28.00 YZQ3 3.00 8.10 8.60 $54.60 $54.60 $0.00 $19.75 $19.75 4.15 Y2Q4 5.00 4.10 30.00 $0.00 0.00 $240K 5.15 0.00 $500K 3.25 31.00