Community Health and Hospital Community Benefit
This sample analyzes a fictional county community health survey with 1,412 respondents, which is the kind of survey hospitals run as part of a community health needs assessment. It includes a filterable dashboard, an 8-page results brief and an Excel workbook with crosstabs, a codebook and weighting.
Sample data. All names, organizations, and figures are fictional.
Open larger imageThis product shows how community survey responses are cleaned, coded and reported for a needs assessment. The sample survey asks residents about their own health, conditions in their community, their top health concerns, barriers to care and what would most improve health, and the open-ended answers are coded into themes. Results are broken out by age, income, race and ethnicity and area of residence, and they are reported both unweighted and weighted to the county's age and gender mix.
The results brief has a summary of findings, ranked concerns, diverging bars for the agreement statements, small multiples by group, resident quotes and a methods page that is plain about the limits of a convenience sample. The dashboard lets a reader filter by group and switch weighting on and off, and it warns when a filtered group is too small to read with confidence. The Excel workbook builds every crosstab with COUNTIFS and SUMPRODUCT formulas so new responses flow through.
Select an image to see it larger.
This is the secondary data profile from a community health needs assessment for ten Upstate South Carolina counties, and it is built from the 2024 County Health Rankings release. It compares 35 county indicators with state and national values and turns them into a dashboard, a 14-page report and an Excel workbook.
Public data
This Excel workbook consolidates five hospitals' community benefit activity logs into one dataset and rolls it up to the lines of IRS Form 990, Schedule H. Every total on the summary ties back through formulas to the row a hospital reported.
Sample data