# time series analysis interpolation

• From: Jim Tarvid <tarvid ls net>
• To: gnumeric-list gnome org
• Subject: time series analysis interpolation
• Date: Thu, 19 Aug 2010 08:04:17 -0400

I have a lot more of these to do.

Goal. Compute asfr(time, age-group) where time is [1991,. 2021] and age-group=[15-19,20-24,25-29,30-34,35-39,40-44,45-49]

Given.
1. start and stop months of survey
2. age-group of respondent at time of survey
3. fertility rate based on number of births in the three year period befor interview
Imputations.
1. Start and stop dates are the 15th of the month of the dates of field work.
2. Interview conducted at the midpoint of the start and stop dates
3. Fertility observation ascribed to 18 months before the midpoint
Data observations.
1. Survey name
2. vlookup of date from the survey-date worksheet (abscissae)
3. births per thousand by survey and age-group (ordinates)
Output.asfr by calendar year and age-group

Formula.

=interpolation('asfr-dhs'!\$B\$2:\$B\$6,'asfr-dhs'!\$C\$2:\$C\$6,'asfr-ts'!\$A3,0)

where
'asfr-dhs'!\$B\$2:\$B\$6 are the imputed dates of the observations
'asfr-dhs'!\$C\$2:\$C\$6 are the observations
'asfr-ts'!\$A3 is the target date
0 is the method

Result. #NAME?

--
Rev. Jim Tarvid, PCA
Galax, Virginia
http://ls.net
http://drupal.ls.net

Attachment: asfr.gnumeric
Description: application/gnumeric