Appendix B-1

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

for North Park Monitor (AQS ID: 42-003-0093)

Pittsburgh Sites & 2007-2009 DVs & Data Capture

Site A1 

Site B1 

Site A1: 

Site B1

npairsQ1 npairsQ2 npairsQ3 npairsQ4 corr

Pittsburgh-Beaver Valley, PA 420030093 420030093 11.3 inc-a 11.3 inc-a 53 44 52 53 1

Pittsburgh-Beaver Valley, PA 420030093 420030008 11.3 inc-a 13.1 A 53 44 51 52 0.969902

Pittsburgh-Beaver Valley, PA 420030093 420050001 11.3 inc-a 11 inc-a 13 12 0.962351

Pittsburgh-Beaver Valley, PA 420030093 420030067 11.3 inc-a 11.7 A 44 39 46 47 0.945352

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

Pittsburgh-Beaver Valley, PA 420030093 421255001 11.3 inc-a 12.4 A 42 40 45 52 0.924971

Pittsburgh-Beaver Valley, PA 420030093 420031301 11.3 inc-a 14.3 A 50 43 51 53 0.916812

Pittsburgh-Beaver Valley, PA 420030093 421250200 11.3 inc-a 12.7 A 52 39 51 51 0.907219

Pittsburgh-Beaver Valley, PA 420030093 420031008 11.3 inc-a 13.7 A 51 39 46 48 0.879467

Pittsburgh-Beaver Valley, PA 420030093 421250005 11.3 inc-a 13.7 A 51 43 50 51 0.873922

Pittsburgh-Beaver Valley, PA 420030093 420070014 11.3 inc-a 14.2 A 50 42 48 48 0.829567

Pittsburgh-Beaver Valley, PA 420030093 421290008 11.3 inc-a 13.8 A 49 42 51 52 0.817973

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)

Site B

Quarterly Data Capture, 2007-2009

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

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

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

420050001 100% 98%

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

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

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

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

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

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

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

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

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

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

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

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

Figure 1
Linear Regression Results

• The computed 420030093 (Site A1) – 420030008 (Site B1) linear relationship is:

Site A concentration = -0.94663 + 0.90641 * Site B concentration

•The linear regression is 

based on the most 

recent 5 years (1/1/2005 

– 12/31/2009) of paired 

(Site A1: Site B1) data 

•The residuals from this 

model are used in the 

subsequent 

bootstrapping

Site A1:Site B1

v_a

0

10

20

30

40

50

60

v_b

0 10 20 30 40 50 60 70

Figure 2
Imputation & Resulting Data Capture & DV Recalculation

Before

After

All quarters, 2007-2009 now complete

“Complete” DV is 11.3

All quarters of 2008 are missing and 

2009-Q1 is deficient.

Site A1:Site B1

Incomplete DV is 11.3

Figure 3
Bootstrapping Residuals (& DV Recalculations)

• FYI Residual distribution for 420030093 (Site A1) – 420030008(Site B1) 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 A1:Site B1

Figure 4