How to Get the RMS (Root Mean Square) in Excel

To calculate the Root Mean Square (RMS) of a set of values in Excel, you’ll use a combination of Excel functions. The RMS is a statistical measure that is used to determine the magnitude of a varying quantity and is particularly useful in contexts where values vary significantly.

Here’s how to calculate RMS in Excel:

Steps to Calculate RMS:

  1. Enter Your Data:
    • Input your data into a column or row in Excel. For example, let’s say your data is in cells A1 through A10.
  2. Use the Formula:
    • In a new cell, enter the following formula to calculate the RMS of the data in cells A1 through A10:
    • Here’s what this formula does:
  3. Press Enter:
    • After entering the formula, press Enter. Excel will display the RMS of the values in the specified range.


Suppose you have the following values in cells A1 through A5:


Enter the formula =SQRT(SUMSQ(A1:A5)/COUNTA(A1:A5)) in cell A6 and press Enter. Excel will calculate the RMS of these values.

Remember, the RMS calculation is particularly useful in fields like engineering, physics, and statistics, where it provides a measure of the magnitude of a set of varying values.

Leave a Reply

Your email address will not be published. Required fields are marked *