5 2 2539 1 AGE1 Demographics, Age recode, persons 15+ years 18 Not In Universe 0 false 15 years 1 true 16 and 17 years 2 true 18 and 19 years 3 true 20 and 21 years 4 true 22 to 24 years 5 true 25 to 29 years 6 true 30 to 34 years 7 true 35 to 39 years 8 true 40 to 44 years 9 true 45 to 49 years 10 true 50 to 54 years 11 true 55 to 59 years 12 true 60 to 61 years 13 true 62 to 64 years 14 true 65 to 69 years 15 true 70 to 74 years 16 true 75 years and over 17 true 3028 1 PTOTVAL Person total income 1 Range -999999 999999 true -1 RECODE1 Income Recode 3028 1 PTOTVAL Person total income 1 {Between -999999 and -1} 2 {Between 0 and 0} 3 {Between 1 and 5000} 4 {Between 5001 and 10000} 5 {Between 10001 and 15000} 6 {Between 15001 and 20000} 7 {Between 20001 and 25000} 8 {Between 25001 and 30000} 9 {Between 30001 and 35000} 10 {Between 35001 and 40000} 11 {Between 40001 and 45000} 12 {Between 45001 and 50000} 13 {Between 50001 and 55000} 14 {Between 55001 and 60000} 15 {Between 60001 and 65000} 16 {Between 65001 and 70000} 17 {Between 70001 and 75000} 18 {Between 75001 and 80000} 19 {Between 80001 and 85000} 20 {Between 85001 and 90000} 21 {Between 90001 and 95000} 22 {Between 95001 and 100000} 23 {Between 100001 and 105000} 24 {Between 105001 and 110000} 25 {Between 110001 and 115000} 26 {Between 115001 and 120000} 27 {Between 120001 and 125000} 28 {Between 125001 and 130000} 29 {Between 130001 and 135000} 30 {Between 135001 and 140000} 31 {Between 140001 and 145000} 32 {Between 145001 and 150000} 33 {Between 150001 and 155000} 34 {Between 155001 and 160000} 35 {Between 160001 and 165000} 36 {Between 165001 and 170000} 37 {Between 170001 and 175000} 38 {Between 175001 and 180000} 39 {Between 180001 and 185000} 40 {Between 185001 and 190000} 41 {Between 190001 and 195000} 42 {Between 195001 and 200000} 43 {Between 200001 and 999999} 2977 1 MARSUPWT Weight, March supplement - Person 0 -2 RECODE2 Age Recode 2539 1 AGE1 Demographics, Age recode, persons 15+ years 1 {1 ,2 ,3 ,4 ,5} 2 {6 ,7} 3 {8 ,9} 4 {10 ,11} 5 {12 ,13 ,14} 6 {15 ,16 ,17} (AGE1 in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17) and ((PTOTVAL between -999999 and -1) or (PTOTVAL between 1 and 999999))) 1 1 0 2 200603 false 0 CPS//March Supplement/Mar 2006
2977 40 2
=SUM(R3,R4,R5,R6,R7,R8) Total 15 + 2 3
RECODE2=1 15 to 24 2 4
RECODE2=2 25 to 34 2 5
RECODE2=3 35 to 44 2 6
RECODE2=4 45 to 54 2 7
RECODE2=5 55 to 64 2 8
RECODE2=6 65 + 2 183 2
=COMP(0.5) Percentile 0 -2 3
=COMP(C6*C2) Percentile of Total 0 4
=SUM(C177) Calculated Percentile Income 2 2 5
=COMP(C179) Average Income 0 6
=SUM(C7,C8,C9,C10,C11,C12,C13,C14,C15,C16,C17,C18,C19,C20,C21,C22,C23,C24,C25,C26,C27,C28,C29,C30,C31,C32,C33,C34,C35,C36,C37,C38,C39,C40,C41,C42,C43,C44,C45,C46,C47,C48,C49) Total 2 7
RECODE1=1 Between -999999 and -1 2 8
RECODE1=2 Between 0 and 0 2 9
RECODE1=3 Between 1 and 5000 2 10
RECODE1=4 Between 5001 and 10000 2 11
RECODE1=5 Between 10001 and 15000 2 12
RECODE1=6 Between 15001 and 20000 2 13
RECODE1=7 Between 20001 and 25000 2 14
RECODE1=8 Between 25001 and 30000 2 15
RECODE1=9 Between 30001 and 35000 2 16
RECODE1=10 Between 35001 and 40000 2 17
RECODE1=11 Between 40001 and 45000 2 18
RECODE1=12 Between 45001 and 50000 2 19
RECODE1=13 Between 50001 and 55000 2 20
RECODE1=14 Between 55001 and 60000 2 21
RECODE1=15 Between 60001 and 65000 2 22
RECODE1=16 Between 65001 and 70000 2 23
RECODE1=17 Between 70001 and 75000 2 24
RECODE1=18 Between 75001 and 80000 2 25
RECODE1=19 Between 80001 and 85000 2 26
RECODE1=20 Between 85001 and 90000 2 27
RECODE1=21 Between 90001 and 95000 2 28
RECODE1=22 Between 95001 and 100000 2 29
RECODE1=23 Between 100001 and 105000 2 30
RECODE1=24 Between 105001 and 110000 2 31
RECODE1=25 Between 110001 and 115000 2 32
RECODE1=26 Between 115001 and 120000 2 33
RECODE1=27 Between 120001 and 125000 2 34
RECODE1=28 Between 125001 and 130000 2 35
RECODE1=29 Between 130001 and 135000 2 36
RECODE1=30 Between 135001 and 140000 2 37
RECODE1=31 Between 140001 and 145000 2 38
RECODE1=32 Between 145001 and 150000 2 39
RECODE1=33 Between 150001 and 155000 2 40
RECODE1=34 Between 155001 and 160000 2 41
RECODE1=35 Between 160001 and 165000 2 42
RECODE1=36 Between 165001 and 170000 2 43
RECODE1=37 Between 170001 and 175000 2 44
RECODE1=38 Between 175001 and 180000 2 45
RECODE1=39 Between 180001 and 185000 2 46
RECODE1=40 Between 185001 and 190000 2 47
RECODE1=41 Between 190001 and 195000 2 48
RECODE1=42 Between 195001 and 200000 2 49
RECODE1=43 Between 200001 and 999999 2 50
=SUM(C7) SUMS 0 51
=SUM(C8,C50) 0 52
=SUM(C9,C51) 2 53
=SUM(C10,C52) 2 54
=SUM(C11,C53) 2 55
=SUM(C12,C54) 2 56
=SUM(C13,C55) 2 57
=SUM(C14,C56) 2 58
=SUM(C15,C57) 2 59
=SUM(C16,C58) 2 60
=SUM(C17,C59) 2 61
=SUM(C18,C60) 2 62
=SUM(C19,C61) 2 63
=SUM(C20,C62) 2 64
=SUM(C21,C63) 2 65
=SUM(C22,C64) 2 66
=SUM(C23,C65) 2 67
=SUM(C24,C66) 2 68
=SUM(C25,C67) 2 69
=SUM(C26,C68) 2 70
=SUM(C27,C69) 2 71
=SUM(C28,C70) 2 72
=SUM(C29,C71) 2 73
=SUM(C30,C72) 2 74
=SUM(C31,C73) 2 75
=SUM(C32,C74) 0 76
=SUM(C33,C75) 2 77
=SUM(C34,C76) 2 78
=SUM(C35,C77) 2 79
=SUM(C36,C78) 2 80
=SUM(C37,C79) 2 81
=SUM(C38,C80) 2 82
=SUM(C39,C81) 2 83
=SUM(C40,C82) 2 84
=SUM(C41,C83) 2 85
=SUM(C42,C84) 2 86
=SUM(C43,C85) 2 87
=SUM(C44,C86) 2 88
=SUM(C45,C87) 2 89
=SUM(C46,C88) 2 90
=SUM(C47,C89) 2 91
=SUM(C48,C90) 2 92
=SUM(C49,C91) 2 93
=COMP(0-1000000+((C3-0)/C7)*1000000) Percentile Calcs 2 94
=COMP(0) 2 95
=COMP(1+((C3-C51)/C9)*5000) 2 96
=COMP(5001+((C3-C52)/C10)*5000) 2 97
=COMP(10001+((C3-C53)/C11)*5000) 2 98
=COMP(15001+((C3-C54)/C12)*5000) 2 99
=COMP(20001+((C3-C55)/C13)*5000) 2 100
=COMP(25001+((C3-C56)/C14)*5000) 2 101
=COMP(30001+((C3-C57)/C15)*5000) 2 102
=COMP(35001+((C3-C58)/C16)*5000) 2 103
=COMP(40001+((C3-C59)/C17)*5000) 2 104
=COMP(45001+((C3-C60)/C18)*5000) 2 105
=COMP(50001+((C3-C61)/C19)*5000) 2 106
=COMP(55001+((C3-C62)/C20)*5000) 2 107
=COMP(60001+((C3-C63)/C21)*5000) 2 108
=COMP(65001+((C3-C64)/C22)*5000) 2 109
=COMP(70001+((C3-C65)/C23)*5000) 2 110
=COMP(75001+((C3-C66)/C24)*5000) 2 111
=COMP(80001+((C3-C67)/C25)*5000) 2 112
=COMP(85001+((C3-C68)/C26)*5000) 2 113
=COMP(90001+((C3-C69)/C27)*5000) 2 114
=COMP(95001+((C3-C70)/C28)*5000) 2 115
=COMP(100001+((C3-C71)/C29)*5000) 2 116
=COMP(105001+((C3-C72)/C30)*5000) 2 117
=COMP(110001+((C3-C73)/C31)*5000) 2 118
=COMP(115001+((C3-C74)/C32)*5000) 2 119
=COMP(120001+((C3-C75)/C33)*5000) 2 120
=COMP(125001+((C3-C76)/C34)*5000) 2 121
=COMP(130001+((C3-C77)/C35)*5000) 2 122
=COMP(135001+((C3-C78)/C36)*5000) 2 123
=COMP(140001+((C3-C79)/C37)*5000) 2 124
=COMP(145001+((C3-C80)/C38)*5000) 2 125
=COMP(150001+((C3-C81)/C39)*5000) 2 126
=COMP(155001+((C3-C82)/C40)*5000) 2 127
=COMP(160001+((C3-C83)/C41)*5000) 2 128
=COMP(165001+((C3-C84)/C42)*5000) 2 129
=COMP(170001+((C3-C85)/C43)*5000) 2 130
=COMP(175001+((C3-C86)/C44)*5000) 2 131
=COMP(180001+((C3-C87)/C45)*5000) 2 132
=COMP(185001+((C3-C88)/C46)*5000) 2 133
=COMP(190001+((C3-C89)/C47)*5000) 2 134
=COMP(195001+((C3-C90)/C48)*5000) 2 135
=COMP(200001+((C3-C91)/C49)*800000) 2 136
=IF((C3 IF CHECKS 2 137
=IF((C3 If 2 2 138
=IF((C3 If 3 2 139
=IF((C3 2 140
=IF((C3 2 141
=IF((C3 2 142
=IF((C3 2 143
=IF((C3 2 144
=IF((C3 2 145
=IF((C3 2 146
=IF((C3 2 147
=IF((C3 2 148
=IF((C3 2 149
=IF((C3 2 150
=IF((C3 2 151
=IF((C3 2 152
=IF((C3 2 153
=IF((C3 2 154
=IF((C3 2 155
=IF((C3 2 156
=IF((C3 2 157
=IF((C3 2 158
=IF((C3 2 159
=IF((C3 2 160
=IF((C3 2 161
=IF((C3 2 162
=IF((C3 2 163
=IF((C3 2 164
=IF((C3 2 165
=IF((C3 2 166
=IF((C3 2 167
=IF((C3 2 168
=IF((C3 2 169
=IF((C3 2 170
=IF((C3 2 171
=IF((C3 2 172
=IF((C3 2 173
=IF((C3 2 174
=IF((C3 2 175
=IF((C3 2 176
=IF((C3 2 177
=IF((C3 Final Check 2 178
MEAN(PTOTVAL)=1 Total PTOTVAL 2 179
=COMP(C181/C178) Average PTOTVAL 2 -1 180
=COMP(SQRT(C182-C179*C181)/C178) Std Err PTOTVAL 2 -2 181
MEAN(PTOTVAL)=2 Weighted total PTOTVAL 2 182
MEAN(PTOTVAL)=3 Weighted sum of squares PTOTVAL 2