SOLVED
Data Imputation
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Raj
16 - Nebula
‎07-04-2023
03:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have data where i want to replace the blank with average of next 5 values
and the filling should start with bigger values first such as it should first fill for 2002 then 2001 and then 2000 so it considers new values as well in the calculation
for eg as 2000 is blank it should take average of new 2001, new 2002,, 2003, 2004 and 2005
Year Price
2000
2001
2002
2003 68
2004 73
2005 74
2006 50
2007 51
2008 52
2009 59
2010 64
2011 89
2012 60
2013 71
2014 60
thanks in advance
Solved! Go to Solution.
Labels:
- Labels:
- Help
2 REPLIES 2
ed_hayter
12 - Quasar
‎07-04-2023
03:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎07-04-2023
04:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@ed_hayter thanks for help