# To :

Cc:

Bcc:

Subject: Re: Klemm PM Data Clarification

From: "Eddie Thomas" <ethomas@klemmanalysis.com>

To: Rebecca Yang/RTP/USEPA/US@EPA, "Rebecca Klemm" <rklemm@klemmanalysis.com>

Cc: Lindsay Stanek/RTP/USEPA/US@EPA

Date: 11/30/2009 11:56 PM

Subject: RE: Question regarding 2004 study



# Hi Rebecca,

The statistics we sent previously used updated AQI data (includes more recent data and back-filled

historical data) and includes less missing values o ver the two-year time period. We felt it prudent t o send

statistics on the more recent data since it is the data we’re using for all subsequent research on hea lth

effects of air pollution in Atlanta, GA. The updat ed data AQI statistics are based on average of lag0 and

lag1.

Attached are descriptive statistics on the original AQI data that coincide with “ Daily mortality and air

pollution in Atlanta: Two years of data from ARIES”

.

Please let us know if you have any further question s.

Klemm Analysis Group

From: Rebecca Klemm

Sent: Thursday , November 26, 2009 7:47 AM

To: Yang.Rebecca@epamail.epa.gov; Eddie Thomas

Subject: Re: Question regarding 2004 study



# Rebecca. We will check. Could be the aqi were updat ed. We will check next week.

Rebecca

Sent via BlackBerry from T-Mobile

From: Yang.Rebecca@epamail.epa.gov

Date: Wed, 25 Nov 2009 11:07:42 -0500

To: <rjklemm@klemmanalysis.com>

Cc: <Stanek.Lindsay@epamail.epa.gov>

Subject: Question regarding 2004 study

Hi Rebecca,

I have been looking through the data set you sent e arlier this year for your 2004 study titled, "Daily

mortality and air pollution in Atlanta: Two years o f data from ARIES" and found a few differences betw een

it and the published concentration information. I a pologize for disturbing you again, but I was wonder ing if I

could ask you for a few points of clarification? I n the data set, the maximum for PM coarse was liste d as

34.2 g/m3 whereas the maximum for PM coarse in the published study was 25.17 g/m3. In addition to

those differences, there are a few other small disc repancies as well (e.g., the minimum for coarse). I 'm not

sure if the discrepancies are due to the averaging of lags 0 and 1 in the published study, but I'd app reciate

any information you have about how the concentratio ns were calculated. The attached excel spreadsheet

# is the data set that I've been referencing. Thank y ou so much for your help and clarification! I look forward

to hearing from you.

Sincerely,

Rebecca Yang

Student Services Contractor

U.S. Environmental Protection Agency

National Center for Environmental Assessment-RTP

PH: (919) 541-2655AQI SummaryAtlanta ARIES (Fulton & DeKalb counties)August 1, 1998 through July 31, 2000Parameter Units MeanStandardDeviationMinimumFirstQuartileMedianThirdQuartile95thpercentile96thpercentile97thpercentile98thpercentile99thpercentileMaximum RangeNumber ofObservationsAir Quality indicatorsPM2.5FRMμg/m319.62 8.32 5.28 13.15 18.08 24.76 34.51 35.39 37.29 38.94 41.83 48.01 42.7 594PM10μg/m3 28.94 10.70 9.28 20.84 27.36 35.83 48.71 49.53 50.80 51.49 58.85 68.27 59.0 610Coarse massμg/m39.69 3.94 1.71 6.69 9.34 11.94 16.84 17.38 17.99 18.55 20.20 25.17 23.5 609O3 max 8hr ppbv 47.03 24.71 6.63 27.00 43.62 63.52 91.97 94.24 100.39 104.41 111.16 124.41 117.8 603NO2 max 1hr ppbv 51.28 16.30 10.46 39.95 49.35 60.80 81.23 83.95 86.40 88.96 96.01 104.23 93.8 507CO max 1hr ppbv 1314.32 939.13 303.58 680.39 1019.27 1655.40 3139.94 3402.02 3628.38 4243.47 5075.20 7396.22 7092.6 528SO2 max 1hr ppbv 19.40 13.42 0.93 9.83 16.38 24.95 45.36 47.47 51.15 53.77 61.62 99.70 98.8 577Ultrafine surface areamm2/cm3250.06 213.17 26.84 131.33 200.29 299.00 570.51 616.63 725.07 865.93 999.34 2289.33 2262.5 400Ultrafine count#/cm33.81E+04 3.56E+04 5.01E+03 1.83E+04 2.77E+04 4.61E+04 9.02E+04 1.01E+05 1.11E+05 1.42E+05 1.89E+05 3.66E+05 3.61E+05 400Acidμg/m30.02 0.02 -0.01 0.00 0.01 0.02 0.06 0.07 0.08 0.08 0.10 0.13 0.1 573Elemental Carbonμg/m32.03 1.23 0.45 1.27 1.71 2.40 4.40 4.55 5.36 5.56 6.80 9.76 9.3652Organic Carbonμg/m34.54 1.90 1.41 3.16 4.28 5.52 8.23 8.68 8.94 9.84 10.38 14.61 13.2 653SO4μg/m35.46 3.50 0.79 2.90 4.55 6.84 13.08 13.96 14.65 15.54 16.87 19.34 18.6 612OxygenatedhydrocarbonsppbC 31.82 12.33 9.35 23.25 30.00 39.18 53.33 54.88 58.13 62.15 68.27 79.15 69.8 483Non-methanehydrocarbonsppbC 292.42 215.07 67.25 160.52 221.40 326.80 764.18 857.35909.45 959.84 1112.27 1503.20 1436.0 546NO3μg/m31.17 0.79 0.15 0.59 0.99 1.48 2.76 2.87 3.04 3.55 4.13 5.40 5.2612Weather measuresDaily AverageTemperature°C 17.7 7.7 -5.6 12.2 18.3 24.4 28.3 28.3 28.9 29.4 30.0 31.7 37.2 731Daily Average DewPoint°C 10.6 8.5 -14.7 4.5 12.0 17.8 21.5 21.6 21.8 22.1 22.6 23.3 38.0 7311 of 2AQI SummaryAQI SummaryAtlanta ARIES (Fulton & DeKalb counties)August 1, 1998 through July 31, 2000Parameter Units MeanStandardDeviationMinimumFirstQuartileMedianThirdQuartile95thpercentile96thpercentile97thpercentile98thpercentile99thpercentileMaximum RangeNumber ofObservationsMORTALITYGROUPSDeaths due tononaccidental causes#22.3 5.2 6.0 18.0 22.0 26.0 31.0 31.0 32.0 34.0 35.0 40.0 34.0 731Deaths due tononaccidental causes,age 65+#14.8 4.3 4.0 12.0 15.0 18.0 22.0 22.0 23.0 24.0 27.0 31.0 27.0 731Deaths due to circulatoryconditions#8.4 3.3 1.0 6.0 8.0 10.0 14.0 15.0 15.0 16.0 17.0 22.0 21.0 731Deaths due to circulatoryconditions, age 65+#6.2 2.8 0.0 4.0 6.0 8.0 11.0 11.0 12.0 13.0 14.0 18.0 18.0 731Deaths due to respiratoryconditions#2.2 1.5 0.0 1.0 2.0 3.0 5.0 5.0 5.0 6.0 6.0 8.0 8.0 731Deaths due to respiratoryconditions, age 65+#1.8 1.3 0.0 1.0 2.0 3.0 4.0 5.0 5.0 5.0 5.0 7.0 7.0 731Deaths due to Cancer#5.22.30.04.05.07.09.09.010.010.411.013.013.0731Deaths due to Cancer,age 65+#3.3 1.9 0.0 2.0 3.0 4.0 7.0 7.0 7.0 7.0 8.0 10.0 10.0 731Deaths due to all othercauses#6.6 2.7 0.0 5.0 6.0 8.0 11.5 12.0 12.0 13.0 14.0 17.0 17.0 731Deaths due to all othercauses, age 65+#3.6 2.0 0.0 2.0 3.0 5.0 7.0 7.0 8.0 8.0 9.0 11.0 11.0 7312 of 2AQI SummaryYear 1Atlanta ARIES (Fulton & DeKalb counties)August 1, 1998 through July 31, 1999Parameter Units MeanStandardDeviationMinimumFirstQuartileMedianThirdQuartile95thpercentile96thpercentile97thpercentile98thpercentile99thpercentileMaximum RangeNumber ofObservationsAir Quality indicatorsPM2.5FRMμg/m320.6 9.3 3.8 13.4 19.2 26.0 37.9 39.7 40.7 43.5 46.8 54.6 50.9 299PM10μg/m3 29.3 12.0 7.0 20.9 28.0 36.6 49.1 52.8 54.6 60.9 67.8 68.661.6 310Coarse massμg/m39.4 4.5 0.5 6.1 9.0 11.8 17.2 18.0 19.5 20.9 21.8 28.6 28.0 310O3 max 8hr ppbv 44.6 25.4 3.5 24.6 40.1 60.6 91.7 95.2 98.5 109.0 117.4 130.8 127.3 317NO2 max 1hr ppbv 50.5 19.8 7.6 36.6 47.9 63.2 85.6 86.0 95.1 99.4 100.1 108.1 100.6 249CO max 1hr ppbv 1251.2 989.1 260.7 561.8 888.9 1563.3 3280.9 3435.1 3845.9 4065.2 4758.1 5627.1 5366.4 296SO2 max 1hr ppbv 18.5 17.4 1.0 6.6 12.6 24.9 52.5 55.5 62.6 73.3 82.1 100.8 99.8 310Ultrafine surface areamm2/cm3206.2 283.7 26.3 90.7 146.3 219.4 462.0 589.2 678.6 1053.1 1635.5 2939.5 2913.2 233Ultrafine count#/cm328975 48172 3148 12828 19261 24719 60253 84192 107617 165222273930 457316 454168.0 233Acidμg/m30.0 0.0 0.0 0.0 0.0 0.0 0.1 0.1 0.1 0.1 0.1 0.2 0.2 285Elemental Carbonμg/m32.3 1.6 0.3 1.3 1.9 2.6 5.3 5.9 6.0 7.2 8.3 11.9 11.6 340Organic Carbonμg/m34.6 2.3 1.1 3.1 4.2 5.6 8.2 9.1 10.1 12.0 12.9 16.0 14.9 340SO4μg/m35.6 3.5 0.8 2.8 4.8 7.5 12.2 13.4 13.8 15.1 17.4 20.8 20.1 326OxygenatedhydrocarbonsppbC 31.5 15.6 6.3 19.8 29.0 40.7 59.7 63.7 64.9 65.9 76.9 91.685.3 291Non-methanehydrocarbonsppbC 312.1 272.0 65.2 150.1 214.6 345.2 911.7 993.1 1058.7 1208.2 1435.6 1544.8 1479.6 318NO3μg/m31.2 0.9 0.1 0.6 0.9 1.5 3.0 3.2 3.3 3.9 4.8 7.5 7.4 326Weather measuresDaily AverageTemperature°C 17.7 7.4 -5.6 12.2 18.9 23.9 27.2 27.2 27.8 28.2 28.9 30.6 36.1 365Daily Average DewPoint°C 10.9 8.7 -14.7 4.4 12.5 18.3 21.7 21.9 22.0 22.3 22.7 23.2 37.8 3651 of 2Year 1Year 1Atlanta ARIES (Fulton & DeKalb counties)August 1, 1998 through July 31, 1999Parameter Units MeanStandardDeviationMinimumFirstQuartileMedianThirdQuartile95thpercentile96thpercentile97thpercentile98thpercentile99thpercentileMaximum RangeNumber ofObservationsMORTALITYGROUPSDeaths due tononaccidental causes#22.3 5.3 6.0 18.0 22.0 26.0 30.8 31.0 32.0 32.0 35.0 40.0 34.0 365Deaths due tononaccidental causes,age 65+#14.7 4.3 5.0 12.0 15.0 18.0 21.8 22.0 23.0 24.0 26.0 29.0 24.0 365Deaths due tononaccidental causes,under 65#7.6 2.8 0.0 6.0 8.0 10.0 12.0 12.0 13.0 13.0 14.0 17.0 17.0 365Deaths due tocirculatory conditions#8.4 3.2 1.0 6.0 8.0 11.0 13.0 14.0 15.0 15.7 16.4 21.0 20.0 365Deaths due tocirculatory conditions,age 65+#6.2 2.7 1.0 4.0 6.0 8.0 11.0 11.0 11.1 12.7 14.4 17.0 16.0 365Deaths due tocirculatory conditions,under 65#2.3 1.5 0.0 1.0 2.0 3.0 5.0 5.0 6.0 6.0 6.0 7.0 7.0 365Deaths due torespiratory conditions#2.1 1.6 0.0 1.0 2.0 3.0 5.0 5.0 6.0 6.0 7.0 8.0 8.0 365Deaths due torespiratory conditions,age 65+#1.7 1.4 0.0 1.0 2.0 2.0 4.8 5.0 5.0 5.0 6.0 7.0 7.0 365Deaths due torespiratory conditions,under 65#0.4 0.7 0.0 0.0 0.0 1.0 2.0 2.0 2.0 2.0 3.0 4.0 4.0 365Deaths due to Cancer#5.32.30.04.05.07.09.09.010.010.011.013.013.0365Deaths due to Cancer,age 65+#3.4 1.9 0.0 2.0 3.0 5.0 7.0 7.0 7.0 8.0 8.0 10.0 10.0 365Deaths due to Cancer,under 65#1.9 1.3 0.0 1.0 2.0 3.0 4.0 5.0 5.0 5.0 5.0 7.0 7.0 365Deaths due to all othercauses#6.4 2.5 0.0 5.0 6.0 8.0 11.0 11.4 12.0 12.0 13.0 14.0 14.0 365Deaths due to all othercauses, age 65+#3.4 1.9 0.0 2.0 3.0 5.0 7.0 7.0 7.0 8.0 9.0 9.0 9.0 365Deaths due to all othercauses, age under 65#3.0 1.7 0.0 2.0 3.0 4.0 6.0 6.0 7.0 7.0 7.0 9.0 9.0 3652 of 2Year 1Year 2Atlanta ARIES (Fulton & DeKalb counties)August 1, 1999 through July 31, 2000Parameter Units MeanStandardDeviationMinimumFirstQuartileMedianThirdQuartile95thpercentile96thpercentile97thpercentile98thpercentile99thpercentileMaximum RangeNumber ofObservationsAir Quality indicatorsPM2.5FRMμg/m318.4 8.5 4.2 12.0 16.6 23.5 34.0 34.1 35.6 38.4 39.5 42.0 37.8 339PM10μg/m328.2 11.3 5.6 19.7 26.9 35.2 49.0 49.9 50.8 55.1 56.7 59.6 54.1338Coarse massμg/m39.9 4.9 0.5 6.3 9.3 12.3 19.2 19.6 20.1 20.7 23.0 34.2 33.7 338O3 max 8hrppbv 49.2 26.4 2.9 27.8 42.9 68.8 97.9 101.7 103.1 106.3 116.9125.8 122.9 322NO2 max 1hrppbv 51.7 17.6 15.5 39.3 49.8 61.4 84.4 87.2 91.0 94.0 99.0 109.2 93.7 307CO max 1hrppbv 1405.3 1235.9 250.3 608.0 962.5 1857.6 4106.5 4368.4 4458.9 4757.3 6627.6 7657.0 7406.7 292SO2 max 1hrppbv 20.1 15.2 0.1 9.6 16.7 26.4 51.6 53.3 55.2 59.7 73.1 89.2 89.1 313Ultrafine surface areamm2/cm3302 173 63 177 268 386 631 665 682 738 886 1135 1071.9 192Ultrafine count#/cm348866.9 25669.3 11508.9 30050.3 43525.4 62251.6 94665.4 97238.1 103251.4 117310.8 123097.4 156268.8 144759.9 192Acidμg/m30.0 0.0 0.0 0.0 0.0 0.0 0.1 0.1 0.1 0.1 0.1 0.1 0.1 335Elemental Carbonμg/m31.8 1.1 0.3 1.0 1.5 2.2 3.9 4.0 4.2 5.2 5.5 8.1 7.8 345Organic Carbonμg/m34.5 2.2 1.3 3.0 4.1 5.6 8.2 8.7 9.2 9.5 10.5 18.4 17.1 346SO4μg/m35.2 3.8 0.6 2.6 4.1 6.4 14.1 15.1 15.7 16.3 17.3 20.2 19.6 332OxygenatedhydrocarbonsppbC 33.0 15.2 5.7 22.4 30.1 40.7 64.7 67.4 69.9 73.9 76.0 90.584.8 276Non-methanehydrocarbonsppbC 271.7 203.2 59.5 141.3 203.8 336.0 712.7 756.7 807.8 849.6 976.5 1665.0 1605.5 295NO3μg/m31.1 0.9 0.1 0.5 0.9 1.5 2.6 2.7 3.1 3.8 4.2 6.0 5.9 332Weather measuresDaily AverageTemperature°C17.7 8.0 -2.8 12.2 17.8 25.0 28.9 29.4 29.4 29.4 30.6 31.7 34.4366Daily Average DewPoint°C10.4 8.3 -13.6 5.4 11.4 17.4 21.0 21.2 21.4 21.6 22.2 23.3 36.93661 of 2Year 2Year 2Atlanta ARIES (Fulton & DeKalb counties)August 1, 1999 through July 31, 2000Parameter Units MeanStandardDeviationMinimumFirstQuartileMedianThirdQuartile95thpercentile96thpercentile97thpercentile98thpercentile99thpercentileMaximum RangeNumber ofObservationsMORTALITYGROUPSDeaths due tononaccidental causes#22.4 5.2 10.0 19.0 22.0 26.0 31.0 31.4 33.1 34.7 36.4 39.0 29.0366Deaths due tononaccidental causes,age 65+#15.0 4.3 4.0 12.0 15.0 18.0 22.0 22.0 23.0 23.7 27.0 31.0 27.0 366Deaths due tononaccidental causes,under 65#7.4 2.7 2.0 6.0 7.0 9.0 12.0 13.0 13.1 14.0 15.0 19.0 17.0 366Deaths due to circulatoryconditions#8.4 3.4 1.0 6.0 8.0 10.0 14.0 15.0 16.0 16.7 17.4 22.0 21.0 366Deaths due to circulatoryconditions, age 65+#6.2 2.8 0.0 4.0 6.0 8.0 11.0 11.0 12.0 13.0 14.0 18.0 18.0 366Deaths due to circulatoryconditions, under 65#2.2 1.6 0.0 1.0 2.0 3.0 5.0 5.0 6.0 6.0 6.0 10.0 10.0 366Deaths due to respiratoryconditions#2.2 1.4 0.0 1.0 2.0 3.0 5.0 5.0 5.0 5.0 6.0 7.0 7.0 366Deaths due to respiratoryconditions, age 65+#1.8 1.3 0.0 1.0 2.0 3.0 4.0 4.0 5.0 5.0 5.0 6.0 6.0 366Deaths due to respiratoryconditions, under 65#0.4 0.7 0.0 0.0 0.0 1.0 2.0 2.0 2.0 2.0 2.0 4.0 4.0 366Deaths due to Cancer#5.02.40.03.05.07.09.010.010.011.011.013.013.0366Deaths due to Cancer,age 65+#3.2 1.8 0.0 2.0 3.0 4.0 6.8 7.0 7.0 7.0 8.0 10.0 10.0 366Deaths due to Cancer,under 65#1.9 1.5 0.0 1.0 2.0 3.0 4.0 4.0 5.0 5.0 6.4 9.0 9.0 366Deaths due to all othercauses#6.7 2.8 1.0 5.0 6.0 8.8 12.0 12.0 13.0 13.0 14.0 17.0 16.0 366Deaths due to all othercauses, age 65+#3.8 2.0 0.0 2.0 4.0 5.0 7.0 8.0 8.0 8.7 9.0 11.0 11.0 366Deaths due to all othercauses, age under 65#2.9 1.8 0.0 2.0 3.0 4.0 6.0 7.0 7.0 8.0 9.0 10.0 10.0 3662 of 2Year 2