Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
So here is what I'm looking at...
December - 100 - N/A January - 200 - 100% change (1.0) February - 300 - 50% change (.5) March - 100 - 66% change (.66) I can tell what the percentage change is from month to month, but I'm not sure what the best way is to figure out the average percentage change, overall. I can't add up the decimal versions of each percentage difference and then divide by the number of months to get some kind of overall average, right? In this case, that would turn out to be an average variance of 72%. Please help - thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA - Measuring Time -subsecond | Excel Discussion (Misc queries) | |||
measuring historical volatility | Excel Discussion (Misc queries) | |||
Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
how does one convert text to a formula "average(A:A)" to =average( | Excel Worksheet Functions | |||
Formating fractions so they read like a measuring tape | Excel Discussion (Misc queries) |