Results 1 to 3 of 3

Math Help - Weighted percentage discrepancy.

  1. #1
    jaj
    jaj is offline
    Newbie
    Joined
    Mar 2011
    Posts
    1

    Weighted percentage discrepancy.

    Weighted percentage discrepancy.xls
    Hi,
    I have attached a file, to show the issue.
    Does the discrepancy result because of rounding figures?
    If somebody can give me some insight that would be great.

    Thank you,
    JAJ
    Follow Math Help Forum on Facebook and Google+

  2. #2
    MHF Contributor
    Joined
    May 2010
    Posts
    1,027
    Thanks
    28
    in the example at the bottom, there is an (almost) constant relationship between value1 and value2. value2 is 63% of value1 (with tiny differences that i assume are due to rounding). Since you are just scaling all the weights down by 62%, this results in the same weighted average.


    In your case at the top, the "value2" is not always a fixed percentage of "value1", so the same thing doesn't happen.
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Senior Member
    Joined
    Nov 2010
    From
    Hong Kong
    Posts
    255
    Quote Originally Posted by jaj View Post
    Hi,
    I have attached a file, to show the issue.
    Does the discrepancy result because of rounding figures?
    If somebody can give me some insight that would be great.

    Thank you,
    JAJ
    The way you set up your spreadsheet is not ideal - in column F I would rather make a reference to the original ratio (B/A) which I did in the spreadsheet attached, and the both ratios are exactly the same.

    There must have been some minor error in copying/formatting, otherwise, the two methods would have given the same result (exactly equal ratios), because Excel calculates numbers with higher accuracy than it shows in the spreadsheet - ie unless you insert 'rounding' formula (which you didn't seem to do) the calculation will be accurate to the highest order.

    Copy of Weighted percentage discrepancy.xls
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Integration discrepancy with wolfram Online
    Posted in the Calculus Forum
    Replies: 1
    Last Post: August 23rd 2010, 11:51 AM
  2. Integration by Substitution Discrepancy
    Posted in the Calculus Forum
    Replies: 4
    Last Post: March 6th 2010, 07:26 AM
  3. MacClaurin series discrepancy
    Posted in the Calculus Forum
    Replies: 2
    Last Post: May 7th 2009, 02:06 PM
  4. Textbook discrepancy
    Posted in the Calculus Forum
    Replies: 9
    Last Post: May 14th 2008, 09:47 PM
  5. Replies: 5
    Last Post: August 28th 2007, 09:01 PM

Search Tags


/mathhelpforum @mathhelpforum