Government consumption preprocessor: Difference between revisions
No edit summary |
No edit summary |
||
Line 5: | Line 5: | ||
Initialize defense expenditures using '''SeriesGovtMil%GDPSIPRI.''' If null, then use '''SeriesGovtMil%GDP.''' | Initialize defense expenditures using '''SeriesGovtMil%GDPSIPRI.''' If null, then use '''SeriesGovtMil%GDP.''' | ||
'''If null estimate using GDPPCP: '''TbName$ = "GDP/Capita (PPP) Versus Govt Exp Mil as % of GDP (" & CStr(BaseYear) & ") - linear" | '''If null estimate using GDPPCP: '''TbName$ = "GDP/Capita (PPP) Versus Govt Exp Mil as % of GDP (" & CStr(BaseYear) & ") - linear" | ||
= Health = | = Health = | ||
Line 13: | Line 13: | ||
If null estimate using GDPPCP: TbName$ = "GDP/Capita (PPP) Versus Govt Exp Hlth as % of GDP (" & CStr(BaseYear) & ") - log" | If null estimate using GDPPCP: TbName$ = "GDP/Capita (PPP) Versus Govt Exp Hlth as % of GDP (" & CStr(BaseYear) & ") - log" | ||
Initialize private health expenditures using '''SeriesHealthExpPriv%Tot'''. If no data, but there is data on total health expenditures '''(SeriesHealthExpTot%GDP) '''then set private as the difference between total and public. | Initialize private health expenditures using '''SeriesHealthExpPriv%Tot'''. If no data, but there is data on total health expenditures '''(SeriesHealthExpTot%GDP) '''then set private as the difference between total and public. | ||
If no data on total health expenditure then estimate private using: | If no data on total health expenditure then estimate private using: | ||
<span style="color: rgb(0, 128, 0);"> 'Estimate Private</span><br/> Call AnalFunc("Private Health Expenditures % of GDP (2012)", _<br/> Array(CGDPPCP(ICount%), CEDYRSAGE25T(ICount%)), cVal, _<br/> Array("GDP2005PCPPP(MOSTRECENT)/ 1000 (Log)", "EdYearsAge25(MOSTRECENT) (Linear)")) | <span style="color: rgb(0, 128, 0);"> 'Estimate Private</span><br/> Call AnalFunc("Private Health Expenditures % of GDP (2012)", _<br/> Array(CGDPPCP(ICount%), CEDYRSAGE25T(ICount%)), cVal, _<br/> Array("GDP2005PCPPP(MOSTRECENT)/ 1000 (Log)", "EdYearsAge25(MOSTRECENT) (Linear)")) | ||
If no data on total expenditures, then it is the sum of private and public. | If no data on total expenditures, then it is the sum of private and public. | ||
= Education = | |||
Initialize public spending on education using '''SeriesGovtEdPub%GDP'''. If null then use: | |||
Call XYTABL("GDP/Capita (PPP) Versus Govt Exp Educ as % of GDP (2002) - log", _<br/> Amin(40, CGDPPCP(ICount%)), GExpEd(ICount%)) | |||
Bound as 1.5% as a minimum. Set Uzbekistan to 3%. |
Revision as of 18:48, 16 May 2016
Series read
Defense
Initialize defense expenditures using SeriesGovtMil%GDPSIPRI. If null, then use SeriesGovtMil%GDP.
If null estimate using GDPPCP: TbName$ = "GDP/Capita (PPP) Versus Govt Exp Mil as % of GDP (" & CStr(BaseYear) & ") - linear"
Health
Initialize public health expenditures using SeriesGovtHl%GDP.
If null estimate using GDPPCP: TbName$ = "GDP/Capita (PPP) Versus Govt Exp Hlth as % of GDP (" & CStr(BaseYear) & ") - log"
Initialize private health expenditures using SeriesHealthExpPriv%Tot. If no data, but there is data on total health expenditures (SeriesHealthExpTot%GDP) then set private as the difference between total and public.
If no data on total health expenditure then estimate private using:
'Estimate Private
Call AnalFunc("Private Health Expenditures % of GDP (2012)", _
Array(CGDPPCP(ICount%), CEDYRSAGE25T(ICount%)), cVal, _
Array("GDP2005PCPPP(MOSTRECENT)/ 1000 (Log)", "EdYearsAge25(MOSTRECENT) (Linear)"))
If no data on total expenditures, then it is the sum of private and public.
Education
Initialize public spending on education using SeriesGovtEdPub%GDP. If null then use:
Call XYTABL("GDP/Capita (PPP) Versus Govt Exp Educ as % of GDP (2002) - log", _
Amin(40, CGDPPCP(ICount%)), GExpEd(ICount%))
Bound as 1.5% as a minimum. Set Uzbekistan to 3%.