1 / 11

Household Data Module Setup for LLTI and Disability Projections

This document outlines the configuration and methodology for the Household Data Module related to Long-term Limiting Illness (LLTI) and Disability projections, based on the CLG 2008 forecasts. It details the application of population adjustments to Sub-National Population Projections (SNPP) to identify the 'population at risk' and utilize CLG-defined headship rates for household projections. Additionally, it explains the setup of blank workbooks that will be populated by the data module for various scenarios, including static and alternative disability rate scenarios.

nile
Download Presentation

Household Data Module Setup for LLTI and Disability Projections

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Derived Forecast Model Data ModulesHouseholdLLTI/Disability September 2011 Edge Analytics 2011

  2. Setting up the household Data Module …\3. Data Modules\CLG2008HH\DM_CLG2008HH_1 Edge Analytics 2011

  3. CLG Data Module Methodology • The Data Module applies a population adjustment to the Sub-National Population Projection (SNPP) for the chosen area/s, to create a ‘population at risk’ • SNPP – Population adjustment (Persons not in households) = Population at risk. • The Data Module applies the CLG defined headship rates to the ‘population at risk’, to replicate the CLG 2008 household forecasts. • Population at risk x CLG 2008 Headship rates = household projection Edge Analytics 2011

  4. CLG2008HH Configuration Edge Analytics 2011

  5. Folders Created …\2. DF\LeedsYork_inp • Household_inp • DFPopAdjust – CLG 2008 • DFRates – CLG 2008 • DFPop – CLG 2008 • DFScenario – CLG 2008HH • Household_out • DFForecastDetail_CLG 2008 • DFForecastTotal_CLG 2008 • DFRatesOut_CLG 2008 • DFRiskPop_CLG 2008 • Household_skel • Contains blank workbooks that are populated by the data module and used to run the CLG 2008HH scenario. • N.b. DFPop – CLG 2008 renamed to SNPP, DFScenario_CLG 2008 renamed to SNPP. Edge Analytics 2011

  6. 2. Setting up the LLTI or Disability Data Module ..\3. Data Modules\ENG2001Disability\DM_Disability2001_Setup Edge Analytics 2011

  7. ENG2001Disability Data Module Configuration Edge Analytics 2011

  8. Folders Created ..\2. DF • Disability_inp • DFPop_Disability • DFRatesIntercensalLocalChange_Disability • DFRatesOptimistic_Disability • DFRatesPessimistic_Disability • DFRatesStatic_Disability • DFScenario_Disability • Disability_out • DFForecastDetail_Disability • DFForecastTotal_Disability • DFRatesOut_Disability • DFReporter_Disability • DFRiskPop_Disability • Disability_skel • Contains blank workbooks that are populated by the data module and used to run the static disability scenario by the Data Module. Edge Analytics 2011

  9. DF – tables & charts DFReporter_Disability.xls Example: Static disability rates applied to SNPP 2008 projections Edge Analytics 2011

  10. Additional Disability Scenarios • To run additional disability scenarios: • The population projections input can be changed (DFPop) 2. Different disability rates can be applied: optimistic, pessimistic or Intercensal Edge Analytics 2011

  11. End Edge Analytics 2011

More Related