Computing Statistics for a Single Columns of Values

RockWorks | Utilities | Columns | Column Statistics
(Right-click | Column Statistics)

Use this RockWorks Utilities program to compute basic statistics for the values stored in a single column datasheet. A filter may be applied.

Menu Options

• Data Column: Click on this item to select the name of the column in the datasheet that contains the numeric values for which statistics will be calculated.
• Titles
  • Primary Title: Enter the text to be plotted as the primary title at the top of the Statistics Report.
  • Secondary Title: Enter the text to be plotted as the secondary title beneath the Primary Title at the top of the Statistics Report.
• Minimum Filter: Insert a check in this box to apply a low-value data filter. Expand this item as necessary to access the filter settings.
  • Minimum value: Click on this item to type in the minimum data value for which the statistics will be calculated.
• Maximum Filter: Insert a check in this box to apply a high-value data filter. Expand this item as necessary to access the filter settings.
• • Maximum value: Click on this item to type in the maximum data value for which the statistics will be calculated.

Step-by-Step Summary

1. Access the RockWorks Utilities program tab.
2. Enter/open/import your data into the datasheet.
3. (Optional) Click in the column that contains the data values to be read.
4. Do one of the following:
   • Click on the Statistics menu and select the Univariate Statistics option.
   • Click on the Columns menu right above the datasheet and select Column Statistics.
5. Enter the requested menu options, described above. 
6. Click the Process button at the bottom of the window to continue.

The program will perform a variety of calculations on the user-defined range of data and display the results in a report which will include the following calculated statistics: population, minimum value, maximum value, mean, standard deviation, standard error, median, sum square root of sum, sum squared, variance, and, if previously selected, filtering results (deleted points). 

6. Once the statistics have been calculated, you may close the window, or choose to copy, save, or print the report by selecting the appropriate option at the top of the report window.
   
   

Back to Editing the Datasheet

RockWare home page