Is there a simple way to get the RMS of a range in google sheets?

Question

Is there a simple direct way to calculate the root mean square / quadratic mean in google sheets? I'd rather not have to create another array with squares of the first one in order to sum the squares.

Answer 1

One way to do it is to use SUMSQ.

Assuming your array is A1:A4, the RMS would be

SQRT(SUMSQ(A1:A4)/COUNT(A1:A4))