Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

From |
Sadia Khalid <[email protected]> |

To |
[email protected], [email protected] |

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

Date |
Thu, 9 Jan 2014 21:08:11 +0500 |

Thanks @ David Hoaglin for your valuable comments. Actually I am not filling(extrapolating) all the missing values. I am only extrapolating the missing values if there are only five or less missing values. if i will not extraploate the data , no of observation will be less. What are your comments on Intrapolation . are people comfortable with intraploation ( filling the in between missing values). Regards Sadia Khalid On 9 January 2014 20:49, Sadia Khalid <[email protected]> wrote: > @ 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 <[email protected]> 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 <[email protected]> wrote: >>> <> >>> >>> In fact >>> >>> http://www.stata.com/statalist/archive/2014-01/msg00231.html >>> >>> is not even internally consistent. >>> Nick >>> [email protected] >>> >>> >>> On 9 January 2014 12:53, Nick Cox <[email protected]> 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 >>>> [email protected] >>>> >>>> >>>> On 9 January 2014 04:01, Sadia Khalid <[email protected]> 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/

**References**:**st: Re: Fill Missing values at the End***From:*Nick Cox <[email protected]>

**Re: st: Re: Fill Missing values at the End***From:*Sadia Khalid <[email protected]>

**Re: st: Re: Fill Missing values at the End***From:*Nick Cox <[email protected]>

**Re: st: Re: Fill Missing values at the End***From:*Sadia Khalid <[email protected]>

**Re: st: Re: Fill Missing values at the End***From:*Nick Cox <[email protected]>

**Re: st: Re: Fill Missing values at the End***From:*Sadia Khalid <[email protected]>

**Re: st: Re: Fill Missing values at the End***From:*Nick Cox <[email protected]>

**Re: st: Re: Fill Missing values at the End***From:*Nick Cox <[email protected]>

**Re: st: Re: Fill Missing values at the End***From:*Sadia Khalid <[email protected]>

**Re: st: Re: Fill Missing values at the End***From:*Sadia Khalid <[email protected]>

- Prev by Date:
**st: From: Sadia Khalid <[email protected]>** - Next by Date:
**Re: st: From: Sadia Khalid <[email protected]>** - Previous by thread:
**Re: st: Re: Fill Missing values at the End** - Next by thread:
**Re: st: Re: Fill Missing values at the End** - Index(es):