In another empty cell, type: =SQRT(that cell). Replace “that cell” with the one where you stored the MSE. For example, =SQRT(E1).
Hit Enter. Boom! That’s your RMSE. A single, glorious number. If it’s 2.5, your predictions are off by about 2.5 units on average. If it’s 500, maybe pivot to a new hobby.
How to Calculate Root Mean Square Error in Excel - ExcelDemy
You just did statistics with a spreadsheet. Pat yourself on the back. Maybe buy Excel a drink—it earned it.
