## NP Chart with SigmaXL

What is an NP Chart with SigmaXL? The NP chart with SigmaXL is a control chart monitoring the count of defectives. It plots the number of defectives in one subgroup as a data point. The subgroup size of the NP chart is constant. The underlying distribution of this control chart is binomial distribution. Plot an…

## Xbar S Chart with SigmaXL

What is a Xbar S Chart with SigmaXL? The Xbar S chart with SigmaXL (also called X-S chart) is a control chart for continuous data with a constant subgroup size greater than ten. The Xbar chart plots the average of a subgroup as a data point. The S chart plots the standard deviation within a…

## Two Sample Proportion Test with SigmaXL

What is the Two Sample Proportion Test with SigmaXL? The two sample proportion test with SigmaXL is a hypothesis test to compare the proportions of one certain event occurring in two populations following the binomial distribution. Null Hypothesis(H0): p1 = p2 Alternative Hypothesis(Ha): p1 ≠ p2 Two Sample Proportion Test Assumptions The sample data drawn…

## One Sample Proportion Test with SigmaXL

What is the One Sample Proportion Test with SigmaXL? One sample proportion test with SigmaXL is a hypothesis test to compare the proportion of one certain outcome (e.g. the number of successes per the number of trials, or the number of defects per the total number of opportunities) occurring in a population following the binomial…

## One Sample Wilcoxon Test with SigmaXl

What is the One Sample Wilcoxon Test with SigmaXL? The one sample Wilcoxon test with SigmaXL is a hypothesis test to compare the median of one population with a specified value. Null Hypothesis (H0): η = η0 Alternative Hypothesis (Ha): η ≠ η0 It is an alternative test of one sample t-test when the distribution of the…

## Kruskal Wallis Test with SigmaXL

What is a Kruskal Wallis Test with SigmaXL The Kruskal Wallis test with SigmaXL is a statistical hypothesis used test to compare the medians among more than two groups. Null Hypothesis (H0): η1 = η2 = … = ηk Alternative Hypothesis (Ha): at least one of the medians is different from others.Where: ηi is the…

## P Chart with SigmaXL

What is a P Chart? The P chart plots the percentage of defectives in one subgroup as a data point. It considers the situation when the subgroup size of inspected units is not constant. The underlying distribution of the P-chart is binomial distribution. Use SigmaXL to Plot a P Chart Data File: “P” tab in…

## U Chart with SigmaXL

What is a U Chart with SigmaXL? The U chart with SigmaXL is a type of control chart used to monitor discrete (count) data where the sample size is greater than one, typically the average number of defects per unit. Defect vs. Defective Remember the difference between defect and defective? A defect of a unit…

## Xbar R Charts with SigmaXL

What is an Xbar R Chart with SigmaXL? The Xbar R chart with SigmaXL is a control chart for continuous data with a constant subgroup size between two and ten. The Xbar chart plots the average of a subgroup as a data point. The R chart plots the difference between the highest and lowest values…

## IR Chart with SigmaXL

What is an IR Chart with SigmaXL? The IR chart with SigmaXL (also called individual-moving range chart or I-MR chart) is a popular control chart for continuous data with subgroup size equal to one. The I chart plots an individual observation as a data point. The MR chart plots the absolute value of the difference…

## Fractional Factorial Designs with SigmaXL

What Are Fractional Factorial Designs with SigmaXL? In simple terms, a fractional factorial design with SigmaXL is a subset of a full factorial experiment. Fractional factorials use fewer treatment combinations and runs. Fractional factorials are less able to determine effects because of fewer degrees of freedom available to evaluate higher order interactions. Fractional factorials can…

## Full Factorial DOE with SigmaXL

What is a Full Factorial DOE with SigmaXL? In a Full Factorial DOE with SigmaXL, all of the possible combinations of factors and levels are created and tested. For example, for two-level design (i.e.each factor has two levels) with k factors, there are 2k possible scenarios or treatments. Two factors, each with two levels, we…

## Logistic Regression with SigmaXL

What is Logistic Regression with SigmaXL? The Logistic Regression with SigmaXL is a statistical method to predict the probability of an event occurring by fitting the data to a logistic curve using logistic function. The regression analysis used for predicting the outcome of a categorical dependent variable, based on one or more predictor variables. The…

## Attribute MSA with SigmaXL

Implement an Attribute MSA with SigmaXL 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 B”…

## Chi Square Test with SigmaXL

Chi Square Test with SigmaXL (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 with SigmaXL is a hypothesis test in which…

## Box Cox Transformation with SigmaXL

Box Cox Transformation Data transforms are usually applied so that the data appear to more closely meet assumptions of a statistical inference model to be applied or to improve the interpret-ability or appearance of graphs. Power transformation is a class of transformation functions that raise the response to some power. For example, a square root…

## Multiple Linear Regression with SigmaXL

What is a Multiple Linear Regression with SigmaXL? the Multiple Linear Regression with SigmaXL is a statistical technique to model the relationship between one dependent variable and two or more independent variables by fitting the data set into a linear equation. The difference between simple linear regression and multiple linear regression: Simple linear regression only…

## Simple Linear Regression with SigmaXL

What is a Simple Linear Regression with SigmaXL? The Simple linear regression with SIgmaXL is a statistical technique to fit a straight line through the data points. It models the quantitative relationship between two variables. It is simple because only one predictor variable is involved. It describes how one variable changes according to the change…