ࡱ> Y[X 'bjbj .B%81,]D5~")5+5+5+5+5+5+5$(79BO5O5d5Q Q Q )5Q )5Q Q 24pmf}p35z5053 ;2 ;,4 ;4"Q O5O525 ; : Documentation for the Health and Survivor Transition Probabilities, andtheLog Income and Medical Expense Regressions, Reported in Why do the Elderly Save? The Role of Medical Expenses (formerly titled Differential Mortality, Uncertain Medical Expenses, and the Saving Of Elderly Singles) Eric French Federal Reserve Bank of Chicago efrench@frbchi.org July 7, 2009 I. General comments All of the .do (STATA) files use the STATA data set dataprep2.dta. I can give you dataprep2.dta if you are interested. That way you can modify the regressions to your liking. Many researchers do not have the permanent income (PI) percentile as an argument in their model, but want to either want to think about the relationships near the median of the permanent income distribution, or want to use log income (or medical expenses) instead of PI. If you want to think about median income, set your PI value to 0.5, and PI squared to 0.52 = 0.25. If you want to use log income, I once had log income regressions, and can do them again (all I need to do is replace PI=lanninc, PI2=lanninc*lanninc, PIage=age1*lanninc), so just ask. Please contact me if something is unclear. That way I can improve the documentation, which will help other people using these numbers. II. Health Transition Probabilities Three important files: (i) the parameters of the health transition matrix (healthprof.out); (ii) the file that created it (healtrans.do written in STATA); and (iii) a file describing how to map the two-year transition probabilities that we estimate into one-year transition probabilities (two_to_one.pdf). The following line at the bottom of healtrans.do will help you understand the parameter vectors in healthprof.out: order age1 ageshiftFINAL healshift maleshift PIshift bPI2; The first column in healthprof.out is age1, which is just an index. The remainingcolumns are logit coefficients in the equation: Pr(healtht = bad | Xt 2 years) = exp(Xtb)/(1+exp(Xtb)), The coefficients are as follows: ageshiftFINAL=age-specific intercept termhealshift=age-specific coefficients for being in bad health 2 years ago (good health is the omitted category)maleshift=age-specific coefficients for being male (female is the omitted category)PIshift=age-specific coefficients on PI, which is measured as the individuals percentile rank (0 to 1) in the PI distribution bPI2=coefficients on PI percentile squared. For now there is no variation across ages, but that can be added. Suppose you had an 80-year-old male who was in good health and at the 60th percentile of the PI distribution. The probability that this man will be in bad health at age 82 is: Xb = ageshiftFINAL82+maleshift82+PI82*.6+bPI82*.36, where the 82 subscript denotes the row with age index number 82. Note that the health transition probabilities are 2-year probabilities. The document two_to_one.pdf shows how to derive 1-year transition probabilities from 2year transition probabilities. The STATA code in healtrans.do uses these formulas to generate 1year probabilities in the file programs genvals and ONEyear. We can talk this one over if it is not clear. III. Survival Probabilities Two important files: (i) the parameters of the survival probability transitions (deathprof.out); and (ii) the file that created it (death.do -- written in STATA). The line at the bottom of death.do will help you understand deathprof.outit works just like healthprof.out: order age1 ageshiftFINAL healshift maleshift PIshift bPI2; The first column in deathprof.out is age1, which is an index. The remainingcolumns are logit coefficients in the equation: Pr(alive at time t |Xt 2 years, alive at time t 2 years) = exp(Xtb)/(1+exp(Xtb)), These coefficients are completely analogous to the coefficients of the health transition equation. Note that these are 2-year survival probabilities take the square root of the 2-year survival probability to get the 1-year survival probability. IV. Income Two important files: (i) the parameters of the income regression (incprof.out); and (ii)the file that created them (incprof.do written in STATA). The left-hand variable in the income regression is the log of income. The right-hand-side variables are just like those for survival and health: age ageshiftFINAL healshift maleshift PIshift bPI2 V. Medical Expenses Three important files: (i) the parameters of the medical expense regression where the left hand side variable is average medical expenses over two years (medexprofX.out); (ii) the the parameters of the medical expense regression, where the left hand side variable is annual medical expenses (medexprof_adj.out); and (iii) the file that created them (medex.do written in STATA). The list of variables in medexprofX.out and medexprof_adj.out is: age ageshiftFINAL healshift maleshift PIshift bPI2 vagevheal vmale vPI vPI2 This list contains the results from two regressions. The first regression is structured identically to the income regression, except that the left-hand-side variable is log medical expenses. The results of this regression are in the variables ageshiftFINAL healshift maleshift PIshift bPI2 which are just as before. The second regression is a regression of the variance of medical expenses on the same covariates. The results of this regression are in the variables vagevheal vmale vPI vPI2 where: vage is an age-specific intercept for the (conditional on X) variance of log medical expenditures; "vheal" is the age-specific set of coefficients for being in bad health; and so on. If you wish only to use the coefficients, use medexprof_adj.out. Items 1-2 provide a complete description. If, however, you wish to understand how the coefficients relate to the data and the estimation procedure contained in medex.do, some additional explanation is necessary. When calculating average medical expenses by age, it is important to account for the variance. If ln(m) is distributed N((,(2), then E(m) = exp(( + (2/2). The key issue is that while the medical expense numbers in the data are 2-year averages. The file medexprofX.out provides estimates from that regression. However, our model uses 1year quantities, which will have a higher (conditional) variance. The estimation procedure contained in medex.do delivers coefficients for 2-year averages. Using our results from French and Jones, On the Distribution and Dynamics of Health Care Costs (Journal of Applied Econometrics, 2004), we convert the 2-year variances to 1-year variances by multiplying the 2-year variance coefficients by 1.423826. As item 3 shows, however, changing the variance of a lognormal distribution will affect the mean of the levels. Because we care more about the mean of medical expenses themselves than the mean of their logs, we therefore need to change the elements of the log-mean regression to reflect the variance adjustment. In short, we first increase vage,vheal, vmale, vPI, and vPI2, and then make offsetting reductions to ageshiftFINAL, healshift, maleshift, PIshift and bPI2. To see how this works, consider a homoskedastic case, where vheal, vmale, vPI, and vPI2 are set to zero. Because the two-year average of medical expenses has an average residual variance of 1.78 (i.e., the residuals from the regression have a variance of 1.78), we calculate the 1-year variance as 1.78(1.423826 = 2.53. To preserve the mean, we next decrement every element of ageshiftFINAL by (2.53 - 1.78)/2 = .375. To see how this works, suppose that ln(m) is distributed N(6,1.78). E(m) will equal exp(6+1.78/2) = 982.2. Suppose we increase the variance to 2.53. To preserve the mean of m, we would then reduce the mean of ln(m) from 6 to 5.63. In this case, E(m) will equal exp(5.63+2.53/2) = 982.2. When medical expenses are heteroskedastic, we make analogous pairs of adjustments to vheal and healshift, vmale and maleshift, and so on. Again, we have made the necessary adjustments the numbers in medexprof_adj.out are for 1year quantities so you do not need to do them.     PAGE  PAGE 3 y' ( ) n o t u +/`dozOQ/3{guh|khiD hONhz hON hz H*hz OJQJ^J hz H*h eh_! hONCJ h eCJ hz CJhz Jxy) * 6 V i v w > ? k l  RS & Fh^h & F$a$$a$gd e$a$!Zkd$$IflF| i#phX 6    4 la} $$Ifa$$Iff^f < f^f <Zkd$$IflF| i#phX 6    4 la} $$Ifa$$IfZkd}$$IflF| i#phX 6    4 la}_`egZkdw$$IflF| i#phX 6    4 la}$If $$Ifa$<=km/0h^h & F & F `xx^`f^fZkd$$IflF| i#phX 6    4 la}YZPQ-. & Fh^hgdON & FgdONh^h & Ff^f < f^f h^h`@A67h56##+','f^fgd4jgdiD & FgdiDgdiD & Ff^fgd1f^ff^fgdONAe7h5#<CD Q T !!!!!!!!!!!!!־ְְַַҧʧhThA{ hiDH* jshiD jmhiDhiDOJQJhph!;h4jhONhiDh1OJQJ^Jhz OJQJ^Jh1h eOJQJ^Jhz @!!!!"""""""8#T#X#Z#_#a#f#h#k#q#u#############$$$$ $#$)$-$I$O$P$v$$$$$$$$$$$$%%%%%%%Q%^%%ʻh9QhTOJQJ^J jhz hHZhch1hTOJQJ^J hThThiDhTOJQJ^Jh4jhA{hONhThz B%%&0&7&;&<&C&L&U&&&&&&' '''','\'t'x'''''''''''''''''''''''''鷫xh|k0JmHnHuh_! h_!0Jjh_!0JUhSjhSUhUhz h4jh9Q5hiDh9Qh9Qh4jOJQJ^Jh4jOJQJ^Jh9QhTOJQJ^JhTOJQJ^Jh4jhchTh9QhTOJQJ/,'''''''''''''''''''''&`#$f^fgdUf^fgd4j''''''hz hSh_! h_!0Jjh_!0JU,1h/ =!"#$% {$$If}!vh5k5g5#vk#vg#v:V lX 65p5h54a}{$$If}!vh5k5g5#vk#vg#v:V lX 65p5h54a}{$$If}!vh5k5g5#vk#vg#v:V lX 65p5h54a}{$$If}!vh5k5g5#vk#vg#v:V lX 65p5h54a}{$$If}!vh5k5g5#vk#vg#v:V lX 65p5h54a}^ 666666666vvvvvvvvv666666>6666666666666666666666666666666666666666666666666hH6666666666666666666666666666666666666666666666666666666666666666662 0@P`p2( 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p8XV~_HmH nH sH tH @`@ NormalCJ_HaJmH sH tH DA`D Default Paragraph FontVi@V  Table Normal :V 44 la (k (No List 2B@2 Body TextCJ4 @4 Footer  !.)@.  Page NumberDC"D Body Text Indent f^f@@2@ U List Paragraph ^PK![Content_Types].xmlj0Eжr(΢Iw},-j4 wP-t#bΙ{UTU^hd}㨫)*1P' ^W0)T9<l#$yi};~@(Hu* Dנz/0ǰ $ X3aZ,D0j~3߶b~i>3\`?/[G\!-Rk.sԻ..a濭?PK!֧6 _rels/.relsj0 }Q%v/C/}(h"O = C?hv=Ʌ%[xp{۵_Pѣ<1H0ORBdJE4b$q_6LR7`0̞O,En7Lib/SeеPK!kytheme/theme/themeManager.xml M @}w7c(EbˮCAǠҟ7՛K Y, e.|,H,lxɴIsQ}#Ր ֵ+!,^$j=GW)E+& 8PK!Ptheme/theme/theme1.xmlYOo6w toc'vuر-MniP@I}úama[إ4:lЯGRX^6؊>$ !)O^rC$y@/yH*񄴽)޵߻UDb`}"qۋJחX^)I`nEp)liV[]1M<OP6r=zgbIguSebORD۫qu gZo~ٺlAplxpT0+[}`jzAV2Fi@qv֬5\|ʜ̭NleXdsjcs7f W+Ն7`g ȘJj|h(KD- dXiJ؇(x$( :;˹! I_TS 1?E??ZBΪmU/?~xY'y5g&΋/ɋ>GMGeD3Vq%'#q$8K)fw9:ĵ x}rxwr:\TZaG*y8IjbRc|XŻǿI u3KGnD1NIBs RuK>V.EL+M2#'fi ~V vl{u8zH *:(W☕ ~JTe\O*tHGHY}KNP*ݾ˦TѼ9/#A7qZ$*c?qUnwN%Oi4 =3ڗP 1Pm \\9Mؓ2aD];Yt\[x]}Wr|]g- eW )6-rCSj id DЇAΜIqbJ#x꺃 6k#ASh&ʌt(Q%p%m&]caSl=X\P1Mh9MVdDAaVB[݈fJíP|8 քAV^f Hn- "d>znNJ ة>b&2vKyϼD:,AGm\nziÙ.uχYC6OMf3or$5NHT[XF64T,ќM0E)`#5XY`פ;%1U٥m;R>QD DcpU'&LE/pm%]8firS4d 7y\`JnίI R3U~7+׸#m qBiDi*L69mY&iHE=(K&N!V.KeLDĕ{D vEꦚdeNƟe(MN9ߜR6&3(a/DUz<{ˊYȳV)9Z[4^n5!J?Q3eBoCM m<.vpIYfZY_p[=al-Y}Nc͙ŋ4vfavl'SA8|*u{-ߟ0%M07%<ҍPK! ѐ'theme/theme/_rels/themeManager.xml.relsM 0wooӺ&݈Э5 6?$Q ,.aic21h:qm@RN;d`o7gK(M&$R(.1r'JЊT8V"AȻHu}|$b{P8g/]QAsم(#L[PK-![Content_Types].xmlPK-!֧6 +_rels/.relsPK-!kytheme/theme/themeManager.xmlPK-!Ptheme/theme/theme1.xmlPK-! ѐ' theme/theme/_rels/themeManager.xml.relsPK]  B $$$'!%'' ,''  '!!8@0(  B S  ?]dS"^S"NNUU8*urn:schemas-microsoft-com:office:smarttagsCity9*urn:schemas-microsoft-com:office:smarttagsplace "+28?@GINT[56hvw' ' . 3 :   J R l y np0:  GHgu  &*+0167:7DENOXY` %&+,/>BtvTXZ_afhk #Q^OQ k|guno/3{u#<CDQ7;<CLUtxno/3{u#<CDQ7;<CLUtx"" 9Wj7i@KzC2Q mM {NM  O\ {![yg2 uvh ff^f`o(hH.h ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.ff^f`o(.^`.pLp^p`L.@ @ ^@ `.^`.L^`L.^`.^`.PLP^P`L.ff^f`o(.^`.pLp^p`L.@ @ ^@ `.^`.L^`L.^`.^`.PLP^P`L.hff^f`o(.h ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.^`o() ^`hH. pLp^p`LhH. @ @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PLP^P`LhH.hff^f`o(.h ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.ff^f`o(.^`.pLp^p`L.@ @ ^@ `.^`.L^`L.^`.^`.PLP^P`L.^`o(.^`.pLp^p`L.@ @ ^@ `.^`.L^`L.^`.^`.PLP^P`L.NM uj7![ygzC O\Q mM"" "IV                          "IV        "IV        .        Sz Upr%6u01iD:KON9QTHZ e4j2kYnA{{=|c!;|kmX[:)]L_!@uuxIuuX@UnknownG* Times New Roman5Symbol3. * Arial?= * Courier NewEN Script MT BoldA BCambria Math"1h3&h׆3& 99!4d 2QHP?r%2!xx~DOCUMENTATION FOR THE HEALTH AND SURVIVOR TRANSITIONS, AS WELL AS LOG INCOME AND MEDICAL EXPESNSE REGRESSIONS, REPORTED IN  DIg1ebf00g1ebf00,        Oh+'0(4DP\l |    DOCUMENTATION FOR THE HEALTH AND SURVIVOR TRANSITIONS, AS WELL AS LOG INCOME AND MEDICAL EXPESNSE REGRESSIONS, REPORTED IN DIg1ebf00Normalg1ebf0013Microsoft Office Word@4@n@l[t@ Zf՜.+,0 hp  c Federal Reserve Bank of Chicago9 DOCUMENTATION FOR THE HEALTH AND SURVIVOR TRANSITIONS, AS WELL AS LOG INCOME AND MEDICAL EXPESNSE REGRESSIONS, REPORTED IN DI Title  !#$%&'()+,-./0123456789:;<=>?@ABCDEFGIJKLMNOQRSTUVWZRoot Entry F@mf\Data "1Table*8;WordDocument.BSummaryInformation(HDocumentSummaryInformation8PCompObjy  F'Microsoft Office Word 97-2003 Document MSWordDocWord.Document.89q