OriginLab Corporation - Data Analysis and Graphing Software - 2D graphs, 3D graphs, Contour Plots, Statistical Charts, Data Exploration, Statistics, Curve Fitting, Signal Processing, and Peak Analysis                           
 

16 Statistics

Apps for Statistics

Origin 2016 introduced add-on tools called Apps. Since being introduced, a number of statistics-related graphing and analysis Apps have been added to OriginLab's File Exchange and more tools are being released all the time.

A few Apps are installed with your Origin software but note that as of the summer of 2018, all Apps are available at no extra cost and they are easily downloaded and added to Origin. Point to the Add Apps button in the "Apps Gallery" to the right-side of your workspace and double-click. In the App Center dialog that opens, you will find New and Popular Apps. Using this dialog, you can download new Apps or update existing Apps.

Origin 2019 includes a pre-installed App called Statistics Advisor that will be of particular interest to those doing statistical analyses in Origin. This App uses an interactive "wizard" interface to help you choose appropriate tests and tell you where you will find them in Origin, or on the OriginLab File Exchange.Statistics stats advisor app.png

Basic Statistics

Origin provides several tools and methods to compute basic statistics on data from either the worksheet or from a graph.

Basic Statistics on Worksheet

Descriptive Statistics Menu entry with worksheet active
  • Statistics on Columns
  • Statistics on Rows
Statistics:Descriptive Statistics
  • Cross Tabulation and Chi-Square (Pro Only)
Statistics:Descriptive Statistics
Frequencies/Counts
  • Frequency Counts
  • 2D Frequency Counts/Binning
  • Discrete Frequency
Statistics:Descriptive Statistics
Distribution
  • Normality Test
  • Distribution Fit (Pro Only)
Statistics:Descriptive Statistics
Relationship
  • Correlation Coefficient (Pro Only)
  • Partial Correlation Coefficient (Pro Only)
Statistics:Descriptive Statistics
Detecting Outliers
  • Grubbs Test
  • Dixon's Q-test
Statistics:Descriptive Statistics


Origin 2019 supports Conditional Formatting of worksheet cells, with which you can apply color to worksheet cells based, among other things, on worksheet statistics. For more information, see Conditional Formatting.User guide stats conditional format.png

Descriptive Statistics on Graph

Origin provides a couple of gadgets to explore and summarize data plotted in graphs.

Descriptive Statistics Menu entry with graph active
  • Cluster Gadget (Pro Only)
Gadgets:Cluster...
  • Statistics Gadget
Gadgets:Statistics...

Statistics on Selected Range

Origin provides some quick ways to obtain basic statistics on a selected range of worksheet cells, or data plot(s) in a graph.

Status Bar

Select a range of cells in a worksheet. Note that the selection can include cells from one or more columns, and you can use the CTRL key to select non-contiguous groups of cells.

Basic statistics (average, sum, count, min, max) for your selected data will be displayed in the status bar. Right click on the status bar to customize what quantities to display.

Gsb statistics statistics on status bar.png

Command or Script Window

Statistics, Report to Script/Command Window

  1. Select a range of cells in a worksheet, or click and select a group of data plots or an individual data plot in a graph.
  2. Open the Command Window or the Script Window from the Windows menu, and type one of these commands, then press ENTER:
stats
moments
quantiles

With the Command Window, the results are typed out below the command line. With the Script Window, you will need to issue an additional command to return your results:

stats;
stats.=;


Note: For more information, please refer to the:

Help: X-Function > X-Function Reference > Statistics


Statistical Graphs

Origin provides numerous statistical graph types. All graphs can be easily customized and saved as a template for repeat use. View the Graphing and Customizing Graphs chapters of this guide for more information.

Graph Type Menu Entry

Box Charts: Box, Interval Plot, Marginal Box Charts, Bar Charts, Box Overlap, Box Normal, Half Box, Bar Overlap, Bar Normal, Scatter Interval, Double-Y Box.

Plot > 2D: Box

Box Charts, Grouped: Grouped Box Charts - Indexed Data, Grouped Box Charts - Raw Data.

Plot > 2D: Group Box

Violin Plots: Violin Plot, Violin with Box, Violin with Point, Violin with Quartile, Violin with Stick, Split Violin, Half Violin.

Plot > 2D: Violin Plot

Histograms: Histogram, Histogram + Probabilities, Multi-Panel Histogram, Marginal Histograms, Histogram + Distribution, Histogram + Label, Stacked Histograms.

Stacked Histograms

Plot > 2D: Histogram

2D Kernel Density

Plot > 2D: 2D Kernel Density

Heatmap: Heatmap, Heatmap with Labels

Heatmap with Labels

Plot > 2D: Heatmap

Contour - Categorical Z

Plot > 2D: Contour

Cluster Plots

Plot > 2D: Cluster Plot

Probability: Probability Plot, Q-Q Plot.

Plot > 2D: Probability

Pareto and QC Chart: Pareto Chart - Binned Data, Pareto Chart - Raw Data, QC (X-bar R) Chart.

Plot > 2D: Pareto and QC Chart

Scatter Matrix

Plot > 2D: Scatter Matrix

Trellis Plot: Trellis Plot, Double-Y Trellis Plot

Double-Y Trellis Plot

Plot > 2D: Trellis

Parallel Plot: Parallel Plot, Parallel Sets, Parallel Index.

Plot > 2D: Parallel Plot


The following statistical graphs are only available within the Plots branch of the statistical analysis dialogs.

Graph Type Menu Entry
  • Means Plot
  • Means Comparison Plot
Statistics: ANOVA: One-Way ANOVA, Two-Way ANOVA

Statistics: ANOVA: One-Way Repeated Measure ANOVA (Pro Only)
  • Survival Curve
  • One Minus Survival Curve
  • Hazard Curve
  • Log Survival Curve
Statistics: Survival Analysis: Kaplan-Meier Estimator (Pro Only)
  • Scree Plot
  • Component Plot
Statistics: Multivariate Analysis: Principal Component Analysis (Pro Only)
  • Dendrogram
Statistics: Multivariate Analysis: Hierarchical Cluster Analysis (Pro Only)
  • Classification Summary Plot
  • Classification Fit Plot
  • Canonical Score Plot
Statistics: Multivariate Analysis: Discriminant Analysis (Pro Only)
  • ROC Curve
Statistics: ROC Curve (Pro Only)

Comparing One, Two or More Groups

Origin provides parametric and non-parametric tests to compare one, two, three or more groups.

Parametric Hypothesis Tests

Feature Menu Entry
  • One-Sample t-Test
  • Two-Sample t-Test
  • Pair-Sample t-Test
  • One-Sample Test for Variance (Pro Only)
  • Two-Sample Test for Variance (Pro Only)
Statistics: Hypothesis Testing
  • One-Sample Proportion Test (Pro Only)
  • Two-Sample Proportion Test (Pro Only)
Statistics: Hypothesis Testing
  • Two-Sample t-Test on Rows (Pro Only)
  • Pair-Sample t-Test on Rows (Pro Only)
Statistics: Hypothesis Testing

ANOVA

Feature Menu Entry
  • One-Way ANOVA
  • Two-Way ANOVA
  • Three-Way ANOVA
  • One-Way Repeated-Measures ANOVA (Pro Only)
  • Two-Way Repeated-Measures ANOVA (Pro Only)
(Supports both Balanced and Unbalanced data)
Statistics: ANOVA

Non-parametric Tests (Pro Only)

Feature Menu Entry
  • One-Sample Wilcoxon Signed Rank Test
  • Paired-Sample Wilcoxon Signed Rank Test
  • Paired-Sample Sign Test
  • Mann-Whitney Test
  • Two-Sample Kolmogorov-Smirnov Test
  • Kruskal-Wallis ANOVA
  • Moods Median Test
  • Friedman ANOVA
Statistics:Nonparametric Tests
Notes:

Multiple nonparametric tests can be run simultaneously. (Accessible from the Statistics:Nonparametric Tests menu ) Available options are:

  • (NPH) K Independent Samples: Kruskal-Wallis ANOVA and Mood's Median Test
  • (NPH) Paired Samples: Paired-Sample Wilcoxon Signed Rank Test and Paired-Sample Sign Test
  • (NPH) Two Independent Samples: Mann-Whitney Test and Two-Sample Kolmogorov-Smirnov Test

Advanced Statistics

Several additional tools are available in OriginPro.

Multivariate Analysis (Pro Only)

Origin offers several multivariate analysis methods to help you simplify, classify, or make predictions from your data.

Feature Menu Entry
  • Principal Component Analysis
  • K-Means Cluster
  • Hierarchical Cluster
  • Discriminant Analysis
  • Canonical Discriminant Analysis
  • Partial Least Squares
Statistics:Multivariate Analysis
Notes: Canonical Discriminant Analysis is integrated with Discriminant Analysis. It is accessible from the Statistics:Multivariate Analysis:Discriminant Analysis: Canonical Discriminant Analysis(System) menu.

Survival Analysis (Pro Only)

OriginPro includes widely used survival tests to quantify survivorship in a population.

Feature Menu Entry
  • Kaplan-Meier Product-limit Estimator
  • Comparing Survival Curves
  • Cox Proportional Hazards Model
  • Weibull Fit Model
Statistics:Survival Analysis
Notes: Comparing Survival Curves is accessible in the Kaplan-Meier Product-limit Estimator feature.

Power and Sample Size (Pro Only)

Statistics, Power and Sample Size Origin provides eight types of power and sample size analysis, useful in designing experiments. Origin can compute the power of the experiment for a given sample size and can also compute the required sample size for given power values.

Feature Menu Entry
  • One-Proportion Test
  • Two-Proportion Test
  • One-Sample t-Test
  • Two-Sample t-Test
  • Paired-Sample t-Test
  • One-Variance Test
  • Two-Variance Test
  • One-Way ANOVA
Statistics: Power and Sample Size

ROC Curve (Pro Only)

ROC Curve analysis is useful in determining if an incident has occurred, or in comparing the accuracy of two methods that are used to discriminate between diseased and healthy cases.

Feature Menu Entry
  • ROC Curve
Statistics: ROC Curve

Topics for Further Reading

 

© OriginLab Corporation. All rights reserved.