+ Reply to Thread
Results 1 to 5 of 5

median absolute error function

  1. #1
    Registered User
    Join Date
    04-25-2011
    Location
    Boston, MA
    MS-Off Ver
    Excel 2003
    Posts
    24

    median absolute error function

    Does anyone off hand have a formula for calculating the median absolute error for a set of xy points?

    LMHmedchem

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: median absolute error function

    is that involve subtracting values in one column from the other and summing the absolute results as per
    http://www.ehow.co.uk/how_6426845_ca...ute-error.html
    if so it would be

    =SUMPRODUCT(ABS(A1:A10-B1:B10))/ROWS(A1:A10)
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Registered User
    Join Date
    04-25-2011
    Location
    Boston, MA
    MS-Off Ver
    Excel 2003
    Posts
    24

    Re: median absolute error function

    I believe you are describing the mean absolute error. The median absolute error is a bit different but related. I will look for a reference and post it.

    LMHmedchem

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: median absolute error function

    Maybe

    =MEDIAN(SQRT((xRng1 - xRng2)^2 + (yRng1 - yRng2)^2))

    ... confirmed with Ctrl+Shift+Enter
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: median absolute error function

    is this valid then as a non array entered it gives the same result
    =MEDIAN(INDEX(SQRT(($A$1:$A$7 - $B$1:$B$7)^2 + ($D$1:$D$7 - $E$1:$E$7)^2),0))

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Median Absolute Deviation (MAD) Calculation
    By Arand in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-08-2013, 04:07 PM
  2. [SOLVED] Median Ifs, need to find median $ amount per deal for each year
    By xenomorph8472 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-13-2012, 02:01 PM
  3. Calculating median on a filtered range. custom defined function. #NAME error in cell
    By Lifeseeker in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-22-2012, 11:20 AM
  4. Using Median with a look up function
    By rgold in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-08-2008, 02:37 AM
  5. [SOLVED] Getting MEDIAN and PERCENTILE to exclude #ERROR values
    By THOMAS CONLON in forum Excel General
    Replies: 2
    Last Post: 06-01-2006, 03:50 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1