Date: Thu, 20 Oct 2011 08:35:10 -0700
Reply-To: David Marso <david.marso@gmail.com>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: David Marso <david.marso@gmail.com>
Subject: Re: using prior years to compute new variable
In-Reply-To: <1319123133634-4921774.post@n5.nabble.com>
Content-Type: text/plain; charset=us-ascii
VARSTOCASES
SPLIT FILE
REGRESSION (save PRED) OR RMV (see options -TREND?-) or CURVEFIT or ....???
CASESTOVARS.
wall wrote:
>
> Dear all,
>
> it sounds easy, but I cannot come up with a solution.
>
> I have the number of inhabitants for all cities for all years except for
> 2011:
>
> 2007 2008 2009 2010 2011
> 12187,0 12131,0 12114,0 12032,0 .
> 10601,0 10550,0 10462,0 10447,0 .
> 9514,0 9497,0 9270,0 9261,0 .
> 7246,0 7276,0 7447,0 7427,0 .
> 27653,0 27314,0 26744,0 26635,0 .
> 181613,0 182484,0 184227,0 187298,0 .
>
> and now I want to compute the values for 2011 by extending the regression
> line for all prior years up to 2011.
>
> For another variable I have another problem. There is a year missing in
> the middle.
>
> 2007 2008 2009 2010
> 12187,0 12131,0 . 12032,0
> 10601,0 10550,0 . 10447,0
> 9514,0 9497,0 . 9261,0
> 7246,0 7276,0 . 7427,0
> 27653,0 27314,0 . 26635,0
> 181613,0 182484,0 . 187298,0
>
> I there a way to interpolate by making use of all other years. At the
> moment I have used the average of 2008 and 2010 to make the variable for
> 2009. But I hope there is a better solution which makes use of all
> information i have.
>
> Thanks for any help!
>
--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/using-prior-years-to-compute-new-variable-tp4921774p4921892.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.
=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@LISTSERV.UGA.EDU (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
| 
