+ Reply to Thread
Results 1 to 7 of 7

Root Mean Square

  1. #1
    Registered User
    Join Date
    10-27-2008
    Location
    Portland, OR
    Posts
    3

    Root Mean Square

    Does Excel have a function for calculating the RMS of a list of values (as for a tolerance analysis) without having to do it manually?

    ie: SQRT(a^2+b^2+c^2+...+n^2)

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile Re: Root Mean Square

    Good evening bkeavney
    Quote Originally Posted by bkeavney View Post
    Does Excel have a function for calculating the RMS of a list of values (as for a tolerance analysis) without having to do it manually?
    Try using the SUMSQ instruction. If your numbers from 1 to 10 occupied the range A1:A10, then use thus :

    =SQRT(SUMSQ(A1:A10))

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

  3. #3
    Valued Forum Contributor scaffdog845's Avatar
    Join Date
    02-01-2008
    Location
    Aston, PA. USA.
    MS-Off Ver
    Microsoft 365
    Posts
    373

    Re: Root Mean Square

    bkeavney

    Analysis toolpack contains a SUMSQ function tha tshould give you the results you need when used in conjunction with SQRT and COUNTA as follows, assuming A1:A10 as your data range

    =SQRT(SUMSQ(A1:A10)/COUNTA(A1:A10))
    Click here to read the Forum Rules
    Whatever it is in life you decide to go after, go after with great ferocity.

  4. #4
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile Re: Root Mean Square

    Quote Originally Posted by scaffdog845 View Post
    Analysis toolpack contains a SUMSQ function
    You don't need to invoke the Analysis ToolPak to use SUMSQ.

    DominicB

  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: Root Mean Square

    if its rms shoulnt it be along the lines of
    SQRT(SUMSQ(A1:A10)/COUNTA(A1:A10))
    or
    SQRT(average(SUMSQ(A1:A10)))

    or
    SQRT(mean(SUMSQ(A1:A10)))
    or then i could be well off the target lol
    Last edited by martindwilson; 12-17-2009 at 04:09 PM.
    "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

  6. #6
    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: Root Mean Square

    =SQRT(SUMSQ(A1:A10) / COUNT(A1:A10) ) (not COUNTA)
    Entia non sunt multiplicanda sine necessitate

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

    Re: Root Mean Square

    oops wrong one lol

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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