Creating a Statistical Report for a Column of Values

RockWorks | Utilities | Statistics | Univariate

This program is used to calculate statistics for a single column of samples in the current datasheet. Data may be filtered out when an appropriate filter range is selected.

Menu Options
Step-by-Step Summary

Menu Options

• Data Column (Input): Click on this item to select the name of the column in the data sheet that contains the numeric values for which statistics will be calculated.
• Titles: In the middle pane of the window, you can specify report titles.
  • Primary: Click on this item 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 on this item 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.
• Filtering: Insert a check in this box if you wish to apply a data filter. Expand this item to access the filter settings. 
  • Minimum value, Maximum value: Click on these items to type in the minimum and maximum values of the range for which the statistics will be calculated. This establishes the upper and lower limits for your data that will be included in the statistics calculations. All numbers not included within these limits will be filtered out. 
  • Show results: To include a summary of the filtering results in the Univariate Statistics report, insert a check in this check-box. This setting will also cause the program to display a pop-up window that lists the number of points that have been removed from the statistics computations. 
    
    

Step-by-Step Summary

1. Access the RockWorks Utilities program tab. 
2. Enter/open/import your data to be analyzed into the datasheet. 
3. Select the Statistics | Univariate menu option. 
4. In the displayed dialog box enter the requested information, discussed above. 
5. Click Process 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: 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.
     
     
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 bottom of the window.
   
   

Back to Statistics Menu Summary

RockWare home page