Assuming that you are able to calculate the height differences for all the control points and place in a spreadsheet as shown in the figure below. I have a column of delta Z values in column A.
Then to calculate the RMS value for the elevation differences, I can do the following.
- In a cell, type in the formula:
where A2:A18 are the values from cell A2 to A18 in the spreadsheet. Simply replace these with the actual locations on your spreadsheet.
- Press RETURN.
The RMSE value is calculated.