Results 1 to 3 of 3
  1. #1
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: different results (2003)

    You get different results because you are doing two entirely different things. Lets take a simple example using just four numbers: 1,1,2,4. Your first formula is the equivalent of:


    (1+1)/(2+4) = 2/6 =1/3

    Your second formula is the equivalent of (the AVERAGE function does nothing since the average of one number, the sum of all the fractions) is the same number):

    (1/2)+(1/4) = (2/4)+(1/4) = 3/4

    Which one is more correct depends on what you are trying to calculate, both are correct mathematical expressions. Also, your first formula is not calculating an average, it is calculating a ratio of two sums, and your second formula is calculating a sum of ratios since the AVERAGE is doing nothing.
    Legare Coleman

  2. #2
    4 Star Lounger
    Join Date
    May 2002
    Posts
    410
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: different results (2003)

    Got it.
    Sorry for posting my mind warp.
    Thanks.

  3. #3
    4 Star Lounger
    Join Date
    May 2002
    Posts
    410
    Thanks
    1
    Thanked 0 Times in 0 Posts

    different results (2003)

    Edited by HansV to break extremely long line

    Why would you get different results when

    (a) you divide 2 sums:
    =SUM(N4:S18)/SUM(H4:M18)
    =1.505E-03
    (cell Z4, attached spreadsheet)

    ([img]/forums/images/smilies/cool.gif[/img] divide each pair and then average
    =1.609E-03
    T4 through Y18 and Z5, attached spreadsheet

    And when you divide each pair and then average the results:
    =AVERAGE(N4/H4+O4/I4+P4/J4+Q4/K4+R4/L4+S4/M4+N5/H5+O5/I5+P5/J5+Q5/K5+R5/L5+S5/M5+
    N6/H6+O6/I6+P6/J6+Q6/K6+R6/L6+S6/M6+N7/H7+O7/I7+P7/J7+Q7/K7+R7/L7+S7/M7+N8/H8+O8/I8+
    P8/J8+Q8/K8+R8/L8+S8/M8+N9/H9+O9/I9+P9/J9+Q9/K9+R9/L9+S9/M9+N10/H10+O10/I10+P10/J10+
    Q10/K10+R10/L10+S10/M10+N11/H11+O11/I11+P11/J11+Q11/K11+R11/L11+S11/M11+N12/H12+
    O12/I12+P12/J12+Q12/K12+R12/L12+S12/M12+N13/H13+O13/I13+P13/J13+Q13/K13+R13/L13+
    S13/M13+N14/H14+O14/I14+P14/J14+Q14/K14+R14/L14+S14/M14+N15/H15+O15/I15+P15/J15+
    Q15/K15+R15/L15+S15/M15+N16/H16+O16/I16+P16/J16+Q16/K16+R16/L16+S16/M16+N17/H17+
    O17/I17+P17/J17+Q17/K17+R17/L17+S17/M17+N18/H18+O18/I18+P18/J18+Q18/K18+R18/L18+S18/M18)

    =1.448E-01
    (cell Z6, attached spreadsheet)

    Assuming I haven't screwed anything up and the answers are truly different, Is one way more correct than another?

    Thanks.

Posting Permissions

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