How do you calculate RMS value using Microsoft Excel?

You can use the correlation coefficient to calculate the RMSE value using the Microsoft Excel. The correlation coefficient is used to establish the relationship between the values in question.