Statistics

Leapfrog Works has a number of tools that help you to analyse your data. This topic describes the different statistics visualisations available and is divided into:

What options are available depends on the type of object.

Variations of each of these visualisations are described relative to the data objects for which they are relevant.

Leapfrog Works uses fixed 25%/75% quartiles.

Table of Statistics

For many data tables, you can view a table of statistics for multiple attributes. If the table has one or more category columns, data can, optionally, be grouped by category. To open a table of statistics, right-click on a data table then select Statistics. In the window that appears, select the Table of Statistics option.

In this example, we have the initial table of statistics for a merged table that has two category columns and four numeric columns, plus an Interval Length column. However, nothing is displayed in the table because data columns have not yet been selected.

The Statistics weighting dropdown list will contain different options depending on the object being inspected. For this merged table example, the options are Un-weighted and Length-weighted.

For a block model, the options are Un-weighted, Volume-weighted and Mass-weighted. When Mass-weighted is selected, you can also specify the Density as a constant number or by referencing a data column that contains density information. There is also an Additional weighting column which allows the selection of another numeric column to use for scaling. This is especially useful for selecting a stored proportion as illustrated here:

For columns other than stored proportions, you will need to specify the Weighting unit as Decimal or Percentage depending on the content of the data column.

Select from the Numeric items available for the table. In this merged table example, all columns have been selected, including the Interval Length column:

Click the Add button to select from the category columns available in the table. An entry will be added to the Categories list. Click on the arrow to select from the available category columns:

Statistics for the selected category column will be displayed in the table. You can change what categories are displayed by clicking on the second button and enabling or disabling categories:

If there is more than one category column, you can set lower levels. Here there are two category columns displayed in the table, “ROCK” and “Domain”:

You can hide empty categories (those with a count of zero) and inactive rows using the options below the Categories list:

Group by category and Group by numeric item provide further options for the table organisation. Here the Group by numeric item option has been selected:

You can filter the data using any Query filter defined for the data table. Statistics for interval tables can be unweighted or weighted by interval length.

Change the columns displayed in the table by clicking on the Edit table columns button ():

Once you have set up a table of statistics on a particular table, its settings will be saved so you can easily review the statistics and export the table using the same settings.

To export the table in CSV format, click on the Export button in the toolbar ().

Click rows to select them, and select multiple rows by holding down the Shift or Ctrl key while clicking rows. You can then copy rows by clicking the Copy button (), which allows you to copy the selected row(s) or all rows in the table.

The arrow buttons quickly expand () or collapse () rows.

Scatter Plots

Scatter plots are useful for understanding relationships between two variables. An additional variable can be introduced by setting the Colouring option to a data column. The example below plots the two variables lead and zinc against each other, with gold being indicated by the colouring. You can make either axis a log scale with the Log scale in X and Log scale in Y options. A Query filter may also be applied.

The appearance of the chart can be modified by adjusting the Point size, Point shape, and White background settings.

Enable Show X = Y line to aid in assessing how far off equal the distributions are.

When you select Show linear regression, a regression line is added to the chart and a function equation is added below the chart title.

Show conditional expectation plots a line that attempts to find the expected value of one variable given the other. The X axis is divided into a number of bins specified by Bin count, and the data in each bin is used to predict the expected Y value.

By default, the limits of the chart are automatically set to range between zero and the upper limit of the variable data. You can adjust this by turning off Automatic X axis limits and/or Automatic Y axis limits and specifying preferred minimum and maximum values for each axis.

There are three select tools at the top of the window:

With these tools, you can select or deselect points on the graph.

  • Use the Replace button () to select points. This tool clears any previous selection.
  • Use the Add button () to add more points to an existing selection.
  • Use the Remove button () to deselect points.

There are three ways to use each tool:

  • Click on individual points to select/deselect them.
  • Drag the cursor across points to select/deselect them.
  • Draw around a set of points to select/deselect them.

For example, here, using the Replace button () to draw a loop around points selects those points:

You can also:

  • Select all visible points by clicking on the Select All button () or by pressing Ctrl+A.
  • Clear all selected points by clicking on the Clear Selection button () or by pressing Ctrl+Shift+A.
  • Swap the selected points for the unselected points by clicking on the Invert Selection button () or by pressing Ctrl+I.

Selected points can be filtered in the scene by selecting the scatter plot from the Query filter options in the shape properties panel.

Q-Q Plots

Quantile-Quantile plots are useful for validating your assumptions about the nature of distributions of data. Select the data columns to show on the X Axis and Y Axis (which can optionally be set as log scales). You can also select an X filter and/or Y filter to limit the values used from the data columns.

Enable Show X = Y line to plot the mirror line for the chart, which may not always be obvious when the X and Y axis have different scales.

Show quartile line draws a line through two points on the chart, the lower quartiles and the upper quartiles for each of the axes.

Box Plots

The box plot (or box-and-whisker plot) provides a visualisation of the key statistics for a data set in one diagram.

A box plot window for a block model has some additional fields at the top not present on the box plot statistics window for other objects. There is a Statistics weighting option that can be set to Un-weighted, Volume-weighted or Mass-weighted, and a Density option that can be set to Constant or a data column containing density data. There is also an Additional weighting field which allows the selection of another numeric column to use for scaling. This is especially useful for selecting a stored proportion but another numeric data column can be used for the analysis. If the option selected is not a stored proportion, set the Weighting unit column to Decimal or Percentage as appropriate for the data in the selected column.

Select a Numeric column to display, enabling Log scale if it helps to visualise the data more clearly. If the table includes category data, set the Category column to one of the category columns to help visualise the data. Select which categories to include from the Categories list.

You can also use a pre-defined Query filter to limit the data included in the chart.

Note these features of the plot:

  • The mean is indicated by the red diamond.
  • The median is indicated by the line that crosses the inside of the box.
  • The box encloses the interquartile range around the median.
  • The whiskers extend out to lines that mark the extents you select, which can be the Min/Max whiskers, the Outer fence whiskers or the Inner fence whiskers. Outer and inner values are defined as being three times the interquartile range and 1.5 times the interquartile range respectively.

Univariate Graphs

There are several different visualisation options. Histogram shows a probability density function for the values, and Cumulative Histogram shows a cumulative distribution function for the values as a line graph:

There are three options that show the charts with a log scale in the X-axis:

  • Select Histogram and enable Histogram of the log to see the value distribution with a log scale X-axis.
  • Select Cumulative histogram and enable Histogram of the log to see a cumulative distribution function for the values with a log scale X-axis.
  • Log probability is a log-log weighted cumulative probability distribution line chart.

Percentage is used to change the Y-axis scale from a length-weighted scale to a percentage scale.

Bin width changes the size of the histogram bins used in the plot.

The Box Plot options control the appearance of the box plot drawn under the primary chart. The whiskers extend out to lines that mark the extents you select, which can be the Min/max whiskers, the Inner fence whiskers or the Outer fence whiskers. Inner and outer values are defined as being 1.5 times the interquartile range and 3 times the interquartile range respectively.

Some univariate graphs may include a Filtering option containing where a Query filter defined for the data set can be selected.

The Limits fields control the ranges for the X-axis and Y-axis. Select Automatic X axis limits and/or Automatic Y axis limits to get the full range required for the chart display. Untick these and manually adjust the X limits and/or Y limits to constrain the chart to a particular region of interest. This can effectively be used to zoom the chart.

The bottom left corner of the chart displays a table with a comprehensive set of statistical measures for the data set.