#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 30
Default Index vs %

What's the difference between an index and percentage growth/decline?

Example: Last year's volume was 158 vs 2006's volume of 97. If I
divide 158 / 97 I get 162.9. Isn't that the same as 62.9%? Why would I
use one over the other and if I decide I don't want it to read 162.9,
just 62.9, how do I get that to happen?

Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default Index vs %

-1 or -100%
--
David Biddulph

wrote in message
...
What's the difference between an index and percentage growth/decline?

Example: Last year's volume was 158 vs 2006's volume of 97. If I
divide 158 / 97 I get 162.9. Isn't that the same as 62.9%? Why would I
use one over the other and if I decide I don't want it to read 162.9,
just 62.9, how do I get that to happen?

Thanks.



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,059
Default Index vs %

On Mar 15, 7:00*am, " wrote:
What's the difference between an index and percentage growth/decline?


It is largely semantics. But it affects how you use each number in
formulas


Example: Last year's volume was 158 vs 2006's volume of 97. If I
divide 158 / 97 I get 162.9.


No, you get 1.629 (rounded). Apparently, you chose to multiply by 100
to get your index. That is an arbitrary choice, albeit a common one.


Isn't that the same as 62.9%?


Well, 62.9% is derived from that. Specifically, 158/97 - 1, formatted
as Percentage.


Why would I use one over the other


Percentage growth can be negative as well as positive; some people
have trouble dealing with that. For example, if the 2007 volume had
been 36, you would have a "growth" of -62.9% (rounded). Of course, we
say "loss", not "growth". When growth goes from 63% to 126%, it
doubled; similarly when loss goes from -63% to -126%. But what if the
loss goes from -63% to 63%? (Rhetorical.)

In contrast, an index is never negative, at least when we are talking
about volume and other counting numbers that cannot themselves be
negative.


and if I decide I don't want it to read 162.9,
just 62.9, how do I get that to happen?


Just as the index was computed by 100*(158/97), you could compute the
"percentage" by 100*(158/97 - 1).

But I prefer to use 158/97 - 1, and format it as percentage.
Otherwise, you always have to remember to divide the "percentage"
figure by 100 when you use it aritmetic formulas.
Reply
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
How to use Index? Eric Excel Discussion (Misc queries) 1 October 5th 07 02:04 AM
Chart axes color index vs font color index [email protected] Charts and Charting in Excel 4 December 7th 06 04:05 PM
How do I pull the col. index value as well as row index value Vikram Dhemare Excel Discussion (Misc queries) 1 March 29th 06 07:48 AM
Index? HJ Excel Discussion (Misc queries) 8 February 9th 06 04:29 PM
Using INDEX twice?? Joe Gieder Excel Worksheet Functions 3 March 8th 05 01:21 PM


All times are GMT +1. The time now is 08:23 PM.

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

About Us

"It's about Microsoft Excel"