Determine the average non-null PCI value for each row:
Date |
Section 1 PCI |
Section 1 PCI Type |
Section 2 PCI
|
Section 2 PCI Type |
Average |
1/1/1995 |
100 |
Initial Construction |
NULL |
NULL |
100 |
1/1/1996 |
97.4 |
Interpolation |
NULL |
NULL |
97.4 |
1/1/1997 |
94.9 |
Interpolation |
NULL |
NULL |
94.9 |
1/1/1998 |
92.3 |
Interpolation |
NULL |
NULL |
92.3 |
6/1/1998 |
91 |
Inspection |
NULL |
NULL |
91 |
6/1/1999 |
88.4 |
Interpolation |
NULL |
NULL |
88.4 |
6/1/2000 |
85.9 |
Interpolation |
NULL |
NULL |
85.9 |
9/1/2000 |
83.3 |
Interpolation |
100 |
Initial Construction |
91.7 |
6/1/2001 |
82 |
Inspection |
97 |
Inspection |
89.5 |
6/1/2002 |
81 |
Family |
96.8 |
Family |
88.9 |
6/1/2003 |
79 |
Family |
96.6 |
Family |
87.8 |
6/1/2004 |
76 |
Family |
96.4 |
Family |
86.2 |
9/1/2004 |
71 |
Family |
96.1 |
Family |
83.6 |
9/1/2004 |
100 |
Reconstruction |
95.7 |
Family |
97.9 |
1/1/2005 |
99 |
Family |
95.3 |
Family |
97.2 |