Help Manual

Contents






Sigma Magic Help Version 15

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.

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.

DOE > Factorial Design

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

DOE > Taguchi Design

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

Distribution > Distribution Identification

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

Distribution > Probability Calculations

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

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 > Normality Analysis

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

Normality > Transform Data

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

Optimization

This template can be used to determine the optimal set of inputs in order to achieve a certain objective.

Random Numbers > Generate Random Data

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

Random Numbers > Sample from Column

This template can be used to sample data from a population based on specified sampling criteria.

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 > Lot Acceptance Plan

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

Sample Size > 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.