Help

Stats Templates

Stats templates can be used to add statistical templates to your active workbook. These templates help analyze the data that you have collected on your projects using different types of statistical analysis.

Stack/Unstack Columns

This template can be used to pre-process any data prior to statistical analysis. It can handle missing values and be used to stack and unstack columns.

Generate Random Numbers

This template can be used to generate random numbers for a given distribution.

Basic Stats

This template can be used to calculate the basic descriptive statistics of the given data set, such as mean ,median etc.

Capability Analysis

This template can be used to determine the capability of a process such as Sigma Level, process capability index such as Cpk, and defects per million opportunities.

Compare Data Sets

This template can be used to perform hypothesis testing and draw inferences.

Control Charts

This template can be used to plot the control charts for a given set of data.

Correlation Analysis

This template can be used to determine correlation between two or more variables.

Customer Survey Analysis

This template can be used to analyze customer survey data.

Distribution Identification

This template can be used identify the closest distribution for a given set of data.

DOE 2-level Factorial

This template can be used to create and analyze 2-level designed experiments (both full and fractional factorials).

DOE Taguchi

This template can be used to create and analyze a Taguchi designed experiment to design a robust product/service.

Lot Acceptance Sampling

This template can be used to determine a sampling plan for accepting large lots (for example from a supplier into a warehouse).

Monte Carlo Simulation

This template can be used to run simulation studies to determine capability of a process or identify most sensitive factors affecting the model.

MSA Linearity & Bias

This template can be used to determine if a given gage is linear or has any bias in its measurements.

MSA Gage R&R

This template can be used to quantify the measurement variation due to repeatability or reproducibility errors.

Normality Analysis

This template can be used to determine if a given data set is normally distributed.

Probability Calculations

This template can be used to determine the probability of different scenarios for a given distribution.

Regression Analysis

This template can be used to perform a simple or multiple regression on a given data set.

Reliability Analysis

This template can be used to fit a Weibull model to the given data set and draw reliability conclusions.

Sample Size Analysis

This template can be used to determine the minimum sample size for a given data set.

Time Series Analysis

This template can be used to fit a Time Series model to the data and forecast future values.

Transform Data

This template can be used to transform the data to a normal distribution.