Process Capability Process capability measures how well the process performs to meet given specified outcome. It indicates the conformance of a process to meet given requirements or specifications. Capability analysis helps to better understand the performance of the process with respect to meeting customer’s specifications and identify the process improvement opportunities. Process Capability Analysis Steps […]

# Archive | How to with SigmaXL

## Attribute MSA with SigmaXL

Use SigmaXL to Implement an Attribute MSA Data File: “Attribute MSA” tab in “Sample Data.xlsx” (an example in the AIAG MSA Reference Manual, 3rd Edition). Step 1: Reorganize the original data into four new columns (i.e., Appraiser, Assessed Result, Part, and Reference). Select the entire range of the original data (“Part”, “Reference”, “Appraiser A”, “Appraiser […]

## Variable Gage R&R with SigmaXL

Variable Gage R&R Variable Gage Repeatability & Reproducibility (Gage R&R) is a method used to analyze the variability of a measurement system by partitioning the variation of the measurements using ANOVA (Analysis of Variance). Whenever something is measured repeatedly or by different people or processes, the results of the measurements will vary. Variation comes from […]

## Run Chart with SigmaXL

Why we use a Run Chart A run chart is a chart used to present data in time order. These charts capture process performance over time. The X axis indicates time and the Y axis shows the observed values. A run chart is similar to a scatter plot in that it shows the relationship between X and […]

## Scatter Plot with SigmaXL

What is a Scatter Plot A scatter plot is a diagram to present the relationship between two variables of a data set. It consists of a set of data points set on two axis. On the scatter plot, a single observation is presented by a data point with its horizontal position equal to the value of […]

## Histogram Rendering with SigmaXL

What is a Histogram? A histogram is a graphical tool to present the distribution of the data. These plots are used to better understand how values occur in a given set of data. The X axis represents the possible values of the variable and the Y axis represents the frequency of the value occurring. This graphical […]

## Box Plot with SigmaXL

What is a Box Plot? In statistics, graphical analysis is a method to visualize the quantitative data. Graphical analysis is used to discover structure and patterns in the data. The presence of which may explain or suggest reasons for additional analysis or consideration. A complete statistical analysis includes both quantitative analysis and graphical analysis. When […]

## One Sample t Test with SigmaXL

What is a One Sample t Test? A One sample t test is a hypothesis test to study whether there is a statistically significant difference between a population mean and a specified value. Where: What is a t-Test? In statistics, a t-test is a hypothesis test in which the test statistic follows a Student’s t […]

## Central Limit Theorem with SigmaXL

Central Limit Theorem The Central Limit Theorem is one of the fundamental theorems of probability theory. It states a condition under which the mean of a large number of independent and identically-distributed random variables, each of which has a finite mean and variance, would be approximately normally distributed. Let us assume Y1, Y2 . . […]

## Multi Vari Analysis with SigmaXL

Multi-Vari Analysis Multi Vari Analysis is a graphic-driven method to analyze the effects of categorical inputs on a continuous output. It studies how the variation in the output changes across different inputs and helps us quantitatively determine the major source of variability in the output. Multi Vari charts are used to visualize the source of […]

## Kruskal Wallis with SigmaXL

Kruskal–Wallis One-Way Analysis of Variance The Kruskal Wallis one-way analysis of variance is a statistical hypothesis test to compare the medians among more than two groups. It is an extension of Mann–Whitney test. While the Mann–Whitney test allows us to compare the samples of two populations, the Kruskal–Wallis test allows us to compare the samples […]

## Chi Square Test with SigmaXL

Chi Square (Contingency Tables) We have looked at hypothesis tests to analyze the proportion of one population vs. a specified value, and the proportions of two populations, but what do we do if we want to analyze more than two populations? A chi-square test is a hypothesis test in which the sampling distribution of the […]