| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming
|
|||
|
|||
average rate of change per given time period between 2 moments in time of a value
I could not find any Excel function for a very basic task: Calculating
the average percentile (or other) rate of change of a value between two time periods. Example: if in 1990 Ed weighed 100 and in 2000 Ed weighed 200, this means that his weight rose by 7.18 percent in an average year between 1990 and 2000, as I can tell from using the compound interest calculator at http://www.moneychimp.com/calculator...calculator.htm. |
|
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
average rate of change per given time period between 2 moments in
There is a whole host of functions for statistical analyis functions.
The one that you wanted was growth. =GROWTH(D1:D2,C1:C2,1991)-100 where d1:d2=100,200 c1:c2=1990,2000 -- Hope this helps Martin Fishlock Please do not forget to rate this reply. "David Virgil Hobbs" wrote: I could not find any Excel function for a very basic task: Calculating the average percentile (or other) rate of change of a value between two time periods. Example: if in 1990 Ed weighed 100 and in 2000 Ed weighed 200, this means that his weight rose by 7.18 percent in an average year between 1990 and 2000, as I can tell from using the compound interest calculator at http://www.moneychimp.com/calculator...calculator.htm. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to average values based on time period | Excel Worksheet Functions | |||
| average rate of change per given time period between 2 moments in time of a value | Excel Worksheet Functions | |||
| Change colour once a certain time period passed | Excel Discussion (Misc queries) | |||
| Making cells change color after a specified period of time. | Excel Programming | |||
| Making cells change color after a specified period of time. | Excel Programming | |||
Linear Mode
