Tutorial: Compute Basic Statistics

Estimated time: 2 minutes.

The Univariate program in the Utilities | Stats menu is used to compute basic statistics for a single column of data values. (This program is also available in the Datasheet Columns menu, and as a right-click option: right-click in any datasheet cell and choose Univariate from the pop-up menu.)

  1. Be sure you’ve accessed the Datasheet program tab and opened the Samples project folder.
  2. Use the Datasheet File | Open menu option to open the sample file Maps_Surface_Geochemistry.atd.
    ! You can also open the datasheet file using the Project Manager program tab (or pane, if docked).

    RockWorks will open the file and display its contents in the datasheet editor. This data set contains geochemical assay values for 203 sample sites. Included for each site are the X and Y location coordinates for the site, a graphic symbol for the site, and a site ID.

  3. Locate the Utilities program grouping in the upper menu ribbon, and select the Stats | Univariate option.
  4. Data Column: Click on the down-arrow button on this prompt and select from the list of column names the Gold column to be analyzed.
  5. Titles: Click this tab.
    1. Primary: Type into the prompt:   Statistical Summary
    2. Secondary: Type in:  Gold Values
  6. Click on the Filter tab and be sure both options are turned OFF.
  7. Click the Output Options tab. Here you can choose the format(s) to which you want to output the statistical report.
    1. TXT (Notepad): Choose this output option.
    2. Save Output File: Check this box. This simply tells RockWorks to assign a name to the file that is created, rather than just being displayed as "untitled".
    3. Manual: Choose this option to assign a name of your choice to the report. Click inthe File Name prompte and type in the name: Gold Statistics.txt
    4. Display Output: Check this option to that the report will be displayed on completion. Choose New Tab so that the report will be displayed in a tab in the current window.
  8. Click the Continue button at the bottom of the window to proceed with the computations.

    RockWorks will scan the values in the Gold column in the datasheet and compute some basic statistics. The results are displayed in a text tab in the Options window.

    Take note of the first 6 computations.

    Population ........... 203
    Minimum Value ........ 0.0769
    Maximum Value ........ 0.1289
    Range ................ 0.052
    Mean ................. 0.100818
    Standard Deviation ... 0.009614

    In the next step, we will display the gold values in a histogram plot, with mean and standard deviation displayed.

  9. Close the statistics report window, to return to the main menu.

  Creating a Statistical Report


  Back to component menu     |     Next (histogram) 

RockWare home page