Appendix B-2

Statistical Results of 2007-2009 Annual PM2.5 Design Value

for Moon Monitor (AQS ID: 42-003-0095)

Pittsburgh Sites & 2007-2009 DVs & Data Capture

Site A2 

Site B2 

•Site 420030008 has, 1) the highest correlation with Site A2 (and meets the3 criteria stated here), and 2) 

sufficient paired data to establish a good relationship with site A2, and, 3) sufficient (i.e., complete) data 

available in all quarters of 2007-2009 to produce Site A2 estimates for those 12 quarters. 

Site A2: 

Site B2

npairsQ1 npairsQ2 npairsQ3 npairsQ4 corr

Pittsburgh-Beaver Valley, PA 420030095 420030095 11.5 inc-a 11.5 inc-a 50 54 56 56 1

Pittsburgh-Beaver Valley, PA 420030095 421255001 11.5 inc-a 12.4 A 39 50 50 55 0.934208

Pittsburgh-Beaver Valley, PA 420030095 420030093 11.5 inc-a 11.3 inc-a 48 41 48 51 0.929045

Pittsburgh-Beaver Valley, PA 420030095 420030067 11.5 inc-a 11.7 A 41 48 50 49 0.928869

Pittsburgh-Beaver Valley, PA 420030095 420030008 11.5 inc-a 13.1 A 50 54 55 55 0.924932

Pittsburgh-Beaver Valley, PA 420030095 421250200 11.5 inc-a 12.7 A 49 46 55 53 0.90746

Pittsburgh-Beaver Valley, PA 420030095 420050001 11.5 inc-a 11 inc-a 14 12 0.892954

Pittsburgh-Beaver Valley, PA 420030095 421250005 11.5 inc-a 13.7 A 48 51 54 54 0.870867

Pittsburgh-Beaver Valley, PA 420030095 420031301 11.5 inc-a 14.3 A 47 52 54 56 0.86271

Pittsburgh-Beaver Valley, PA 420030095 421290008 11.5 inc-a 13.8 A 47 53 54 53 0.817796

Pittsburgh-Beaver Valley, PA 420030095 420031008 11.5 inc-a 13.7 A 48 46 51 50 0.807254

Pittsburgh-Beaver Valley, PA 420030095 420070014 11.5 inc-a 14.2 A 48 51 52 52 0.800365

Area Site A Site B

DV Site 

A

DV 

status 

Site A

DV Site 

B

DV 

status 

Site B

20-quarter look (2005-Q1 - 2009-Q4)

2007 Q1 2007 Q2 2007 Q3 2007 Q4 2008 Q1 2008 Q2 2008 Q3 2008 Q4 2009 Q1 2009 Q2 2009 Q3 2009 Q4

420030095 93% 87% 100% 93% 60% 94% 93% 87%

421255001 97% 89% 93% 97% 97% 89% 70% 95% 88% 98% 89% 98%

420030093 100% 80% 93% 93% 73% 94% 87% 87%

420030067 63% 80% 90% 87% 81% 93% 90% 90% 80% 90% 90% 81%

420030008 94% 95% 93% 97% 98% 97% 92% 99% 92% 100% 99% 88%

421250200 100% 93% 100% 97% 90% 87% 97% 87% 90% 96% 99% 92%

420050001 100% 98%

421250005 93% 97% 97% 100% 90% 100% 90% 93% 90% 100% 100% 100%

420031301 93% 90% 100% 87% 84% 87% 94% 93% 80% 94% 97% 84%

421290008 93% 97% 94% 97% 100% 87% 87% 100% 73% 97% 99% 100%

420031008 87% 90% 97% 90% 84% 93% 97% 77% 83% 87% 87% 74%

420070014 93% 97% 71% 97% 100% 90% 90% 97% 89% 93% 90% 96%

Quarterly Data Capture, 2007-2009

Site B

Figure 5
Linear Regression Results

• The computed 420030095 (Site A2) – 420030008 (Site B2) linear relationship is:

Site A concentration = -0.16428 + 0.90221 * Site B concentration

•The linear regression is 

based on the most 

recent 5 years (1/1/2005 

– 12/31/2009) of paired 

(Site A2: Site B2 data) 

•The residuals from this 

model are used in the 

subsequent 

bootstrapping

Site A2:Site B2

v_a

0

10

20

30

40

50

v_b

0 10 20 30 40 50 60 70

n = 213

R_square = 0.86

Figure 6
Imputation & Resulting Data Capture & DV Recalculation

Before

After

All quarters, 2007-2009 now complete

“Complete” DV is 11.6

All quarters of 2008 are missing and 

2009-Q1 is deficient.

Site A2:Site B2

Incomplete DV is 11.5

Figure 7
Bootstrapping Residuals (& DV Recalculations)

• FYI Residual distribution for 420030095 (Site A2) – 420030008(Site B2) linear fit

•This step randomly applies real 

residuals from the linear regression to 

the imputed current-period Site A values.

•A 1000 bootstrap runs will provide a 

pseudo confidence interval for the 

partially imputed current-period design 

value

• Bootstrap results (for a run of 1000):

• Final result:

PASS (clean data determination)

•All 1000 simulations produced a passing DV

Site A2:Site B2

Figure 8