Average the Values for each Year in the Condition Analysis

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