Re: st: Re: Fill Missing values at the End

[Sadia Khalid <sadiakhalid234@gmail.com>]

@ Nick Cox

this is the Excel file with formulas.

https://dl.dropboxusercontent.com/u/15846832/missing%20values.xlsx

Regards

Sadia Khalid

On 9 January 2014 20:40, Sadia Khalid <sadiakhalid234@gmail.com> wrote:
> Thanks Nick Cox for your reply.
> I am extremely sorry for this. That why i have posted this question again.
>
> Kindly Consider this data
>
> year name y
> 1990 Aqueela 50.1
> 1991 Aqueela 39.9
> 1992 Aqueela 93.4
> 1993 Aqueela 53.4
> 1994 Aqueela 5.9
> 1995 Aqueela 41.6
> 1996 Aqueela
> 1997 Aqueela
> 1998 Aqueela
> 1999 Aqueela
> 2000 Aqueela
> 1990 Abida 57.0
> 1991 Abida 44.3
> 1992 Abida 41.3
> 1993 Abida 92.3
> 1994 Abida 42.2
> 1995 Abida 56.0
> 1996 Abida
> 1997 Abida
> 1998 Abida
> 1999 Abida
> 2000 Abida
> 1990 Zubaida 68.5
> 1991 Zubaida 51.0
> 1992 Zubaida 41.7
> 1993 Zubaida 91.5
> 1994 Zubaida 40.7
> 1995 Zubaida
> 1996 Zubaida
> 1997 Zubaida
> 1998 Zubaida
> 1999 Zubaida
> 2000 Zubaida
>
> What I want to have
>
> year name y
> 1990 Aqueela 50.1
> 1991 Aqueela 39.9
> 1992 Aqueela 93.4
> 1993 Aqueela 53.4
> 1994 Aqueela 5.9
> 1995 Aqueela 41.6
> 1996 Aqueela 42.1
> 1997 Aqueela 42.5
> 1998 Aqueela 43.0
> 1999 Aqueela 43.4
> 2000 Aqueela 43.9
> 1990 Abida 57.0
> 1991 Abida 44.3
> 1992 Abida 41.3
> 1993 Abida 92.3
> 1994 Abida 42.2
> 1995 Abida 56.0
> 1996 Abida 59.3
> 1997 Abida 62.9
> 1998 Abida 66.7
> 1999 Abida 70.7
> 2000 Abida 75.0
> 1990 Zubaida 68.5
> 1991 Zubaida 51.0
> 1992 Zubaida 41.7
> 1993 Zubaida 91.5
> 1994 Zubaida 40.7
> 1995 Zubaida
> 1996 Zubaida
> 1997 Zubaida
> 1998 Zubaida
> 1999 Zubaida
> 2000 Zubaida
>
>
> Kindly do not consider the previous data .
> take this data into consideration.
> Like for the individual Aqueela values for the year 1996 – 2000 are
> missing. I will first calculate the growth rate of values from >
> 1991-1995. the formula for calculating the growth rate is
> =((41.6/39.9)^(1/(5-1))-1). The growth rate is 1.05%.now the value in
> 1996 = value in 1995*(1+growth rate).  And value in 1997= value in
> 1996 * (1+growth rate). And so on.
> Similarly for other individuals.
>
>
> Regards
> Sadia Khalid
>
> On 9 January 2014 18:00, Nick Cox <njcoxstata@gmail.com> wrote:
>> <>
>>
>> In fact
>>
>> http://www.stata.com/statalist/archive/2014-01/msg00231.html
>>
>> is not even internally consistent.
>> Nick
>> njcoxstata@gmail.com
>>
>>
>> On 9 January 2014 12:53, Nick Cox <njcoxstata@gmail.com> wrote:
>>> This question gets more difficult to understand, not less. Let's focus
>>> on Abida. You say you want to get
>>>
>>> 1990 Abida 57.0
>>> 1991 Abida 44.3
>>> 1992 Abida 41.3
>>> 1993 Abida 92.3
>>> 1994 Abida 42.2
>>> 1995 Abida 82.7
>>> 1996 Abida 42.1
>>> 1997 Abida 42.5
>>> 1998 Abida 43.0
>>> 1999 Abida 43.4
>>> 2000 Abida 43.9
>>>
>>> whereas in http://www.stata.com/statalist/archive/2014-01/msg00231.html
>>> the data were stated to be
>>>
>>> 1990 Abida 57.0
>>> 1991 Abida 44.3
>>> 1992 Abida 41.3
>>> 1993 Abida 92.3
>>> 1994 Abida 42.2
>>> 1995 Abida 56.0
>>>
>>> and you said you wanted
>>>
>>> 1996 Abida 96.6
>>> 1997 Abida 113.0
>>> 1998 Abida 132.0
>>> 1999 Abida 154.4
>>> 2000 Abida 180.4
>>>
>>> What's up with 1995?
>>>
>>> What rule gets you from 82.7 to 42.1 (this post)?
>>>
>>> What rule gets you from 56.0 to 96.6 (this post)?
>>>
>>> There couldn't be good answers if the questions make no sense.
>>>
>>> Nick
>>> njcoxstata@gmail.com
>>>
>>>
>>> On 9 January 2014 04:01, Sadia Khalid <sadiakhalid234@gmail.com> wrote:
>>>> Sir
>>>> I am new to Stata and do not know how to write codes.
>>>>
>>>> Sir I have posted in the previous messages what i have and what i want to get.
>>>> year name y
>>>> 1990 Aqueela 50.1
>>>> 1991 Aqueela 39.9
>>>> 1992 Aqueela 93.4
>>>> 1993 Aqueela 53.4
>>>> 1994 Aqueela 5.9
>>>> 1995 Aqueela 41.6
>>>> 1996 Aqueela
>>>> 1997 Aqueela
>>>> 1998 Aqueela
>>>> 1999 Aqueela
>>>> 2000 Aqueela
>>>> 1990 Abida 57.0
>>>> 1991 Abida 44.3
>>>> 1992 Abida 41.3
>>>> 1993 Abida 92.3
>>>> 1994 Abida 42.2
>>>> 1995 Abida 56.0
>>>> 1996 Abida
>>>> 1997 Abida
>>>> 1998 Abida
>>>> 1999 Abida
>>>> 2000 Abida
>>>> 1990 Zubaida 68.5
>>>> 1991 Zubaida 51.0
>>>> 1992 Zubaida 41.7
>>>> 1993 Zubaida 91.5
>>>> 1994 Zubaida 40.7
>>>> 1995 Zubaida
>>>> 1996 Zubaida
>>>> 1997 Zubaida
>>>> 1998 Zubaida
>>>> 1999 Zubaida
>>>> 2000 Zubaida
>>>>
>>>>
>>>> What I want to get.
>>>> year name y
>>>> 1990 Aqueela 50.1
>>>> 1991 Aqueela 39.9
>>>> 1992 Aqueela 93.4
>>>> 1993 Aqueela 53.4
>>>> 1994 Aqueela 5.9
>>>> 1995 Aqueela 41.6
>>>> 1996 Aqueela 42.1
>>>> 1997 Aqueela 42.5
>>>> 1998 Aqueela 43.0
>>>> 1999 Aqueela 43.4
>>>> 2000 Aqueela 43.9
>>>> 1990 Abida 57.0
>>>> 1991 Abida 44.3
>>>> 1992 Abida 41.3
>>>> 1993 Abida 92.3
>>>> 1994 Abida 42.2
>>>> 1995 Abida 82.7
>>>> 1996 Abida 42.1
>>>> 1997 Abida 42.5
>>>> 1998 Abida 43.0
>>>> 1999 Abida 43.4
>>>> 2000 Abida 43.9
>>>> 1990 Zubaida 68.5
>>>> 1991 Zubaida 51.0
>>>> 1992 Zubaida 41.7
>>>> 1993 Zubaida 91.5
>>>> 1994 Zubaida 40.7
>>>> 1995 Zubaida
>>>> 1996 Zubaida
>>>> 1997 Zubaida
>>>> 1998 Zubaida
>>>> 1999 Zubaida
>>>> 2000 Zubaida
>>>>
>>>>
>>>> actually the code is not giving the above mentioed results.
>>>>
>>>> Please help me out.
>>>>
>>>>
>>>>
>>>>
>>>> Regards
>>>> Sadia Khalid
>>>> *
>>>> *   For searches and help try:
>>>> *   http://www.stata.com/help.cgi?search
>>>> *   http://www.stata.com/support/faqs/resources/statalist-faq/
>>>> *   http://www.ats.ucla.edu/stat/stata/
>> *
>> *   For searches and help try:
>> *   http://www.stata.com/help.cgi?search
>> *   http://www.stata.com/support/faqs/resources/statalist-faq/
>> *   http://www.ats.ucla.edu/stat/stata/

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/