LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Measuring Average Changes

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA - Measuring Time -subsecond PShield Excel Discussion (Misc queries) 2 August 22nd 06 10:17 AM
measuring historical volatility JELLO Excel Discussion (Misc queries) 7 January 18th 06 08:12 AM
Error Handling #N/A with AVERAGE Function - Average of values in Row Sam via OfficeKB.com Excel Worksheet Functions 13 July 31st 05 03:59 PM
how does one convert text to a formula "average(A:A)" to =average( phshirk Excel Worksheet Functions 4 April 14th 05 01:20 AM
Formating fractions so they read like a measuring tape Cabinet_maker Excel Discussion (Misc queries) 1 December 15th 04 08:27 PM


All times are GMT +1. The time now is 10:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"