Ecological Study


Step 6: Data Analysis

You plan to use the Average Daily water use calculated for the previous year, the total population census calculated from the previous year, and the number of new Susser Syndrome cases reported over the previous year as contained in the reportable disease registry.

After running your database queries, you get the following printout detailing the reservoirs:

Rothman Reservoir

Sector 1 Sector 2 Sector 3 Sector 4 Sector 5
Ave Daily Use (L) 165,000 189,500 142,500 88,000 130,000
Total Pop 10,300 11,300 9,500 8,000 8,900

 

Greenland Reservoir

Sector 1 Sector 2 Sector 3 Sector 4 Sector 5
Ave Daily Use (L) 124,500 151,500 102,000 180,000 222,000
Total Pop 8,300 10,100 6,800 12,000 14,800

You also get the following printout detailing the Susser Syndrome cases over the 1-year period:

Susser Syndrome Registry Reported over 1 year Period
Reservoir Sector # # of Cases Reported By
Rothman 1 25 Epiville General
Greenland 5 16 Epiville General
Greenland 2 10 Epiville General
Rothman 2 30 Epiville General
Rothman 5 17 Epiville General
Rothman 4 11 Epiville General
Greenland 1 8 Epiville General
Greenland 3 7 Epiville General
Rothman 3 21 Epiville General
Greenland 4 12 Epiville General

 

6. Combine the above data into a table summarizing the pertinent information. Calculate the incidence rates per 1,000 population (per 1 year) for the sectors associated with each reservoir. [ Check Answer ]
7. Using the tabulated information from question 6, create a graph showing the correlation between incidence rates of Susser Syndrome and Rothman Reservoir water intake. (Hint: model the graph after that found in Gordis pg. 186) [ Check Answer ]
8. Using the tabulated information from question 6, create a second graph showing the correlation between incidence rates of Susser Syndrome and the Greenland Reservoir water intake. (Hint: model the graph after that found in Gordis pg. 186) [ Check Answer ]
9. In order to simplify the visual comparison of Susser Syndrome incidence in different sectors, you decide to combine the two graphs. [ Check Answer ]

 

10. What conclusions can you draw from the graph above?
checkbox a. The incidence rate of the population served by the Rothman Reservoir appears to be identical to the incidence rate of the population served by the Greenland Reservoir.
checkbox b. Increased water use appears to be correlated with an increase in incidence rate of Susser Syndrome among populations served by the Rothman Reservoir whereas no correlation appears to exist among populations served by the Greenland Reservoir.
checkbox c. Individuals drinking Rothman Reservoir water have approximately twice the risk of developing Susser Syndrome than individuals drinking Greenland Reservoir water.

blank image