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)
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)
Please familiarise yourself with the rules before posting. You can find them here.
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.
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
=SQRT(SUMSQ(A1:A10) / COUNT(A1:A10) ) (not COUNTA)
Entia non sunt multiplicanda sine necessitate
oops wrong one lol
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks