Generating a Statistical Report for a Column of I-Data Values

RockWorks | Borehole Manager | I-Data | Statistics

This program is used to calculate statistics for a single column of I-Data measurements in the current project, for all enabled boreholes.  This can be a handy way to get a quick look at the range and distribution of values prior to, or after, modeling.  This is the same tool that is present in the Utilities | Statistics | Univariate menu.

Feature Level: RockWorks Standard and higher

Menu Options
Step-by-Step Summary

Menu Options

• I-Data Track: Click to the right to select the name of the I-Data column for which statistics will be calculated.  Expand this heading to establish any spatial or value filters to apply to the data before running the statistics.
  • Spatial (XYZ) Filtering: Insert a check in this box to activate a data filter based on spatial coordinates. Expand this heading to establish the filter settings. 
  • Filter Based on G-Values: Activate this option to filter the data based on the measured values, and expand the heading to establish the filter parameters.  (More.)
  • Resample at Regularly-Spaced Intervals: Check this box to resample the data.  (More.)
  • Create Filter / Sampling Report: If you've selected any filter/resampling options, this tool will create a summary report of the results. (More.)
• Titles: Here you can specify report titles.
  • Primary: Click to the right to enter the text to be plotted as the primary title at the top of the Statistics Report. The text should be limited to 80 characters. If no title is desired, click on the Primary heading and delete any text that's displayed there.
  • Secondary: Click to the right to enter the text to be plotted as the secondary title beneath the Primary Title at the top of the Statistics Report. The text should be limited to 80 characters.  If no title is desired, click on the Secondary heading and delete any text that's displayed there.

Step-by-Step Summary

1. Access the RockWorks Borehole Manager program tab. 
2. Enter/import your data into the Borehole Manager.
3. Be sure the boreholes for which you wish to generate the statistical report are enabled.
4. Select the I-Data | Statistics menu option. 
5. Enter the requested menu settings, described above.
6. Click the Process button to continue.

The program will read the selected track of data for the enabled boreholes, apply any requested filtering operations, and then compute the general statistics. The statistical summary will be displayed in a Text tab in the Options window.

7. You can adjust any of the input options, and click the Process button again to create a new report.

From here you can print the information, copy it to the clipboard for pasting into another application, save the information on disk, etc.

The results will include the following calculated statistics: 

• Population: The number of values the program found for the selected data which fell within the specified filtering range and which were included in the statistics calculations.
• Minimum Value: The minimum value for the data included within the calculations.
• Maximum Value: The maximum value for the data included within the calculations.
• Mean: The arithmetic average of the sample data, equaling the sum of the values divided by the number of measurements.
• Standard Deviation: A measurement that indicates the way in which the data is centered around its mean, equal to the positive square root of the variance of the sample.
• Standard Error: A measurement that indicates the variability that can be expected in the means computed for samples taken randomly from the same population.
• Median: The value that is in the middle of the frequency distribution of the data.
• Sum: The total of all data included within the calculations added together.
• Square Root of Sum: The arithmetic square root of the total of all data included within the calculations added together.
• Sum Squared: The value of the total of all data included within the calculations added together and multiplied by itself.
• Variance: The measured degree of difference between all data included within the calculations.
• Deleted Points: The number of measurements that were excluded from the calculations because they fell outside a specified filtering range.
• Statistical cutoff data, such as Mean + and - 1 Standard Deviation, 2 Standard Deviations, 3 Standard Deviations, and the populations represented within these groupings.

 Back to I-Data Menu Summary

RockWare home page