Advertisements

Using Excel to calculate the RMSE for LiDAR vertical ground control points

(source: http://dominoc925.blogspot.com/)

The height accuracy of the collected LiDAR data can be verified by comparing with independently surveyed ground control points on hard, flat, open surfaces. It is essentially just calculating the height differences for all the control points and then determining the height root mean squared error (RMSE) or differences. Most LiDAR processing software have the reporting function built-in. However, plain Microsoft Excel can also do the job (except for extracting the elevation from the LiDAR data).

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.

  1. In a cell, type in the formula:= SQRT(SUMSQ(A2:A18)/COUNTA(A2:A18))where A2:A18 are the values from cell A2 to A18 in the spreadsheet. Simply replace these with the actual locations on your spreadsheet.
  2. Press RETURN.
    The RMSE value is calculated.

(source: http://dominoc925.blogspot.com/)

Advertisements

Tags: , , , , , , , , , , , , , ,

2 Responses to “Using Excel to calculate the RMSE for LiDAR vertical ground control points”

  1. DTM validation using Google Earth (and RMSE extraction) | 3D Geovisualization by Alberto Concejal Says:

    […] Lost regarding RMSE calculation?. Think you have to take a look at this other post. […]

  2. Comparación de DTM usando Global Mapper 17.0.1 | Geovisualization.net by Alberto Concejal Says:

    […] Using Excel to calculate the RMSE for LiDAR vertical ground control points […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: