Results 1 to 3 of 3

Thread: Percentage increases!!!

  1. #1

    Thread Starter
    VBA Nutter visualAd's Avatar
    Join Date
    Apr 2002
    Location
    Ickenham, UK
    Posts
    4,906

    Percentage increases!!!

    I have two datasets:

    Code:
    	A  	B   	C   	D   	E   	F   	G   	H   	I   	J   
    1	13%	21%	14%	27%	42%	74%	74%	76%	74%	82%
    2	4173	3653	4335	7154	9891	10230	11664	19460	22059	23988
    Now I want to find the the percentage increase / decrease between the current and previous values (e.g: A & B). Which of the following are correct?

    1. Value B (21%) is 8% greater than value A (13%).
    2. Value B (21%) is 62% greater that value A (13%).
    3. Value B (3653) is 12% less than value A (4173).


    Now if I want to compare the percentage increases between the values in dataset 1 and dataset 2 which scenarios do I use for the comparison to be correct from above; 1 and 3 or 2 and 3?
    PHP || MySql || Apache || Get Firefox || OpenOffice.org || Click || Slap ILMV || 1337 c0d || GotoMyPc For FREE! Part 1, Part 2

    | PHP Session --> Database Handler * Custom Error Handler * Installing PHP * HTML Form Handler * PHP 5 OOP * Using XML * Ajax * Xslt | VB6 Winsock - HTTP POST / GET * Winsock - HTTP File Upload

    Latest quote: crptcblade - VB6 executables can't be decompiled, only disassembled. And the disassembled code is even less useful than I am.

    Random VisualAd: Blog - Latest Post: When the Internet becomes Electricity!!


    Spread happiness and joy. Rate good posts.

  2. #2
    Super Moderator manavo11's Avatar
    Join Date
    Nov 2002
    Location
    Around the corner from si_the_geek
    Posts
    7,171

    Re: Percentage increases!!!

    Value B (21%) is 8% greater than value A (13%).

    It's not 8% greater, it's 8 units greater (and the units happen to be %), but 62% greater if you are comparing the two. If that makes any sense...
    Last edited by manavo11; Apr 14th, 2008 at 03:35 PM.


    Has someone helped you? Then you can Rate their helpful post.

  3. #3
    I don't do your homework! opus's Avatar
    Join Date
    Jun 2000
    Location
    Good Old Europe
    Posts
    3,863

    Re: Percentage increases!!!

    ..and for your 3. Statement, Yes the Value B(3653) is 87,5% of the Value A(4173), therefor it 12,5% less then Value A (based on Value A as 100%)
    You're welcome to rate this post!
    If your problem is solved, please use the Mark thread as resolved button


    Wait, I'm too old to hurry!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width