Manipulate Columns of Values

When you right-click on a LogPlot datasheet, a pop-up menu will appear. The following Columns tools are available (depending on the type of data in the datasheet):

Columns | Math is used to perform arithmetic operations with the values in one of the data columns in the active datasheet. LogPlot offers operations either with a constant or with the data listed in another column in the sheet.

Columns | Resample is available for datasheets containing point-sampled (curve) quantitative data. It is used to transform data which was sampled at randomly or densely spaced depth intervals, to evenly spaced depth intervals for plotting. This is a handy way to delete extraneous data that can be the result of stream digitizing or overly-sensitive sampling equipment.

! This tool will resample all of the columns in the active datasheet.

Columns | Smooth is also available for datasheets containing quantitative data. This program is used to "smooth" out data values by averaging them with a user-specified number of neighboring data values.

Columns | Filter is also available for datasheets containing quantitative data, and is used to remove low and/or high out data values, re-assigning them a threshold minimum or maximum. This can be helpful if you are importing data sets with very high or low "null" values, or if you suspect recording error.

Columns | Statistics computes a quick summary of the population, range, sum, and average of the column's data values.

 

 

 


Back to Other Data Tools

RockWare home page