| Course | NR 550 Population Health Disparities: Local, National, and Global Perspectives |
|---|---|
| Week | 2 |
| Paper type | Local disparity profile |
| Length | About 1,160 words, 2 pages |
| Format | APA 7 student paper |
| School | Chamberlain University |
| Program | MSN, Population Health |
| Updated | September 2026 |
Free sample paper for NR 550 Week 2
Local Disparity Profile: Childhood Asthma Emergency Visits in One County by Census Tract Group, With Counts Printed Beside Every Rate and Small Cells Withheld Rather Than Dropped
Student Name
College of Nursing, Chamberlain University
NR 550: Population Health Disparities: Local, National, and Global Perspectives
Instructor Name
Month Day, Year
Local Disparity Profile: Childhood Asthma Emergency Visits in One County by Census Tract Group, With Counts Printed Beside Every Rate and Small Cells Withheld Rather Than Dropped
The Measure
This profile describes asthma emergency visits made by county children up to age 17, a mixed urban and rural county of about 210,000 residents and 45,000 children. The source is the state's emergency department discharge dataset, which records the patient's residential address and principal diagnosis. Visits with a principal diagnosis of asthma were counted for 2021 to 2023 and divided by the number of resident children from census population estimates, then expressed per 10,000 children per year. The measure counts visits, not children, so repeat visits by one child are included.
Asthma was identified by the principal diagnosis code on the visit record, so a child seen for pneumonia who also had wheezing would not be counted, and a visit coded as asthma by a busy emergency physician would be counted even if the diagnosis was uncertain. These choices match the state's published definition, which keeps the county's figures comparable with the state's. Population denominators are three-year averages of the census estimates for children in each tract, which smooths small year-to-year shifts in population.
The Depth I Can Defend
The profile uses groups of census tracts rather than single tracts or ZIP codes. The county has 52 tracts. At the single-tract level, many tracts recorded fewer than 11 visits over three years, and the state's small-cell rule requires counts below 11 to be withheld. Rates built on counts that small also move sharply if a single visit is recorded differently. Grouping tracts into five areas, each with at least 5,000 children, gives counts large enough to publish and to trust. ZIP codes were considered and rejected because two of the county's ZIP codes cross into neighboring counties and do not match census population estimates well.
The choice of areas is itself an analytic decision. Krieger and colleagues showed that the choice of geographic level and area-based measure changes the size of socioeconomic gradients that can be detected (Krieger et al., 2003). Tract groups are fine enough to show the east side's concentration and coarse enough to avoid suppression.
The Profile
Table 1 gives the counts, populations and rates for the five tract groups and the county.
Asthma emergency department visits, children 0 to 17, 2021 to 2023 pooled
Table 1
| Area | Children (average) | Visits, 3 years | Rate per 10,000 per year |
|---|---|---|---|
| East side (6 tracts) | 7,800 | 610 | 260.7 |
| Central city (11 tracts) | 9,600 | 214 | 74.3 |
| North suburbs (12 tracts) | 10,900 | 96 | 29.4 |
| South suburbs (13 tracts) | 9,200 | 88 | 31.9 |
| Rural townships (10 tracts) | 7,500 | 45 | 20.0 |
| County | 45,000 | 1,053 | 78.0 |
Individual Tracts on the East Side
Within the east side, the six tracts differ. Table 2 shows them, with small cells withheld rather than removed.
East side tracts, visits and rates, 2021 to 2023 pooled
Table 2
| Tract | Children | Visits, 3 years | Rate per 10,000 per year |
|---|---|---|---|
| E1 | 1,650 | 171 | 345.5 |
| E2 | 1,420 | 139 | 326.3 |
| E3 | 1,380 | 118 | 285.0 |
| E4 | 1,310 | 104 | 264.6 |
| E5 | 1,120 | 70 | 208.3 |
| E6 | 920 | Withheld | Not calculated |
Withheld, Not Deleted
Tract E6 is shown with its count withheld because the three-year total is below the state's threshold of 11. The five published tracts total 602 visits, and the east side total of 610 appears in Table 1, so a reader could recover the withheld count by subtraction. Before release, the state's rules would therefore require a second step, either rounding the east side total or withholding a second cell, and this internal profile flags that for the data steward. Removing the row altogether would make the east side look like five tracts with an average rate above 290, and would hide the fact that one east side tract has a much lower rate. Keeping the row, marked, tells a reader that the east side is not uniform.
What the Profile Shows
The east side rate of about 261 per 10,000 is roughly 6.5 times the rate in the rest of the county combined, which is about 40 per 10,000, and 13 times the rate in the rural townships. The central city has a moderately elevated rate. The suburbs and rural areas are low and similar. The gradient is steep and concentrated: about 17% of the county's children live on the east side, and they account for about 58% of the county's childhood asthma emergency visits.
Within the east side, tracts E1 and E2, along the rail yard and the truck route, have the highest rates, while E6, at the edge of the east side next to a park, is far lower. Housing age and condition, which are closely tied to childhood asthma (Krieger & Higgins, 2002), differ across these tracts and will be examined in a later brief. That within-area variation will matter when the profile is used to plan interventions.
How the Profile Should and Should Not Be Used
The profile is suitable for three uses. It can show the county board and the hospital where childhood asthma emergency use is concentrated, it can set a baseline against which future years are compared, and it can guide where to place resources such as home visits or an evening clinic. It is not suitable for judging individual families, for ranking single tracts in public, where small counts make rankings unstable, or for claims about how many east side children have asthma.
Because the profile will be read by people outside public health, every rate is printed with its count, and every table notes that the figures are visits, not children. A reader who sees 345 per 10,000 in tract E1 should also see that it rests on 171 visits over three years, which is solid, while a reader of the rural townships' figure should see that it rests on 45, which is solid for the area but would not be for any single rural tract.
Limits
The measure counts emergency visits, which reflect both how common and severe asthma is and how families use care. An area with poor access to primary care may have high emergency visit rates even if asthma is no more common. Three years of data smooth year-to-year variation but cannot show recent change. Visits by children living in the county but treated in another state are missing. And the address on the record is the address at the time of the visit, so families who moved are counted where they lived then. Braveman (2006) notes that disparity measures depend heavily on how groups and outcomes are defined, and this profile defines both narrowly on purpose.
References
Braveman, P. (2006). Health disparities and health equity: Concepts and measurement. Annual Review of Public Health, 27, 167-194. https://doi.org/10.1146/annurev.publhealth.27.021405.102103
Krieger, J., & Higgins, D. L. (2002). Housing and health: Time again for public health action. American Journal of Public Health, 92(5), 758-768. https://doi.org/10.2105/AJPH.92.5.758
Krieger, N., Chen, J. T., Waterman, P. D., Soobader, M.-J., Subramanian, S. V., & Carson, R. (2003). Choosing area based socioeconomic measures to monitor social inequalities in low birth weight and childhood lead poisoning: The Public Health Disparities Geocoding Project (US). Journal of Epidemiology and Community Health, 57(3), 186-199. https://doi.org/10.1136/jech.57.3.186
The Chamberlain NR 550 Week 2 instructions
This week asks you to build a profile of a health disparity in a local population using available data. The prompt typically requests the outcome, data sources, the population and geography, rates for relevant groups or areas and an interpretation with limitations. Define the measure precisely, including the diagnosis definition and denominator. Choose the geographic depth you can defend from the counts, and explain why a finer level could not be used. Print counts and denominators beside every rate so readers can see which figures are solid. Show small cells as withheld rather than deleting them, and consider whether withheld counts could be recovered by subtraction. Interpret the pattern, including variation within the high-rate area. State how the profile should and should not be used, and its limits. Cite sources in APA 7.
How the NR 550 Week 2 example is put together
The profile opens by defining the measure from the state discharge dataset and explaining the diagnosis coding and denominators. A section explains grouping 52 tracts into five areas with at least 5,000 children each, rejecting ZIP codes that cross county lines, and cites work on area-based measures. Table 1 gives counts, populations and rates for five areas and the county. Table 2 shows the six east side tracts, with one withheld. A section explains why the withheld row stays and how complementary suppression would be needed before release. The interpretation finds a steep gradient concentrated near the rail yard and links housing to asthma. Sections on appropriate use and on limits close the profile.
Reading the NR 550 Week 2 grading rubric
Local profiles are generally assessed on a clearly defined measure, appropriate data and geography, accurate calculations, transparent presentation of counts and suppression, sound interpretation and honest limitations. Explaining why a geographic level was chosen, based on counts, shows analytic judgment. Printing counts beside rates lets readers judge stability, which instructors look for. Handling suppressed cells visibly, and recognizing when subtraction would reveal them, shows understanding of data protection. Noting variation within the high-rate area adds depth that averages hide. A section on appropriate and inappropriate uses shows awareness of audience. Limits covering what the measure counts, and supporting citations in APA 7, complete a strong profile.
Common NR 550 Week 2 mistakes, and how to avoid them
Profiles often present rates without counts, so readers cannot tell whether a striking figure rests on hundreds of events or on four. Print both. Another weakness is choosing the finest geography available without checking whether counts support it. Explain your level. Some students delete suppressed cells, which changes averages and hides information; mark them as withheld. Check whether a withheld count could be recovered from totals. Avoid presenting a single average for a high-rate area when its parts differ. Define what the measure counts, since visits and people are different. Check every rate against its count and denominator before submitting, and include how the profile should be used so that readers do not misuse it.
Get a NR 550 Week 2 example written to your instructions
Tell us the area you have been asked to profile and which indicators your classroom expects. If the data at that depth is thin, say so, and the example will show what the write-up does about it. A custom profile is written to your instructions and returned inside 24 to 48 hours, the first one free, using published sources only.
More NR 550 papers and MSN samples
- NR 550 Week 1: Disparity Statement Discussion
- NR 550 Week 3: Comparator Analysis
- NR 550 Week 4: National Data Review
- NR 550 Week 5: Structural Causes Brief
- NR 550 Week 6: Global Comparison Write-up
- NR 550 Week 7: Multilevel Policy Analysis
- NR 550 Week 8: Synthesis Paper
- NR 540 Week 2: Program Structure Brief
- NR 539 Week 2: Logic Model Draft
- NR 538 Week 2: Data Source Appraisal
- NR 530 Week 2: Concept Clarification
NR 550 Week 2 questions, answered
How far down should the profile go?
As far as the counts allow and no further. In many sections the practical stop is whatever unit still yields events in double figures for the indicator you care about, and most published sources refuse to print anything thinner than that anyway. A write-up gains marks for naming the stop and loses nothing by admitting it, because the alternative is a rate that moves whenever one record changes.
What if my data only exists at county level?
Then say so, and say what it costs. A county figure averages over places that differ from each other by more than the county differs from the state, and a profile that states this has already made the central point of the course. It reads as a genuine finding rather than an excuse, provided you show you went looking for something finer and report what stopped you.
Does the profile need a comparison in it?
Not the full comparator work, which belongs to the following week. A profile describes one area, with its own figures standing on their own. What it does owe the reader is a note on whether the depth it chose could support a comparison at all, since a unit too thin to carry a rate is also too thin to carry a gap between two of them.
Where can I find a free NR 550 Week 2 sample paper?
The tract-group asthma profile is posted above as the NR 550 Week 2 sample, fully readable here. If your local data describe another outcome, share the source and geography with us and a profile following this approach can be prepared.
Why print counts beside rates in NR 550 Week 2?
So readers can see which rates rest on enough events to trust. The sample shows every visit count and child population beside its rate and marks one small cell as withheld.