Help

Stats Templates

Stats templates can be used to add statistical templates to your active workbook. Stats templates can be found under Add Templates in the main menu.

The following templates are available within Stats:

Basic Stats

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

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.

Customer Survey Analysis

This template can be used to analyze customer survey 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.

Distribution Identification

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

Generate Random Numbers

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

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).

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.

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.

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.

Process Capability

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.

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.