select a spreadsheet with data for several health organizations in one of the states listed below. These spreadsheets were created several years ago so these hospitals may have different data now. You may use the spreadsheets as is, or you may decide to rerun the data on WhyNotTheBest.org if you want, however, this is NOT required. Instructions for re-running reports are provided on the WhyNotTheBest website.
Illinois (ACO)
California
Iowa
Texas
Illinois (teaching hospitals)
Table 1: Interpret the readmissions data in the spreadsheet and present it by creating Table 1. Compare the hospital data against benchmarks to look for high or low values. Your table must include:
Benchmarks (Note: benchmarks for national average and Top 10% appear in the Table 1 example. These are available from WhyNotTheBest.org)
Column headers
Highlight of high or low values (compared to WhyNotTheBest.org benchmarks - as illustrated in the example)
Table 1 Example:
U7 Table 1 Example
Table 2: Interpret the Patient Experience (HCAHPS) data in the spreadsheet and present it by creating Table 2. Compare hospital data against benchmarks to look for high or low values. Your table must include:
Benchmarks
Column headers
Highlight of high or low values (compared to benchmarks)
U7 Table 2 Example
For the final part of this assignment, you will create a report in WhyNotTheBest.org and download it to add to your spreadsheet data.
Watch the videos that demo use of WhyNotTheBest resources and tools available on YouTube:
WhyNotTheBest.org Demo https://www.youtube.com/watch?v=S-5iGt8G5Xs