Fractional Factorial Designs with SigmaXL

What Are Fractional Factorial Experiments? In simple terms, a fractional factorial experiment 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 be used to screen…

Read More

Full Factorial DOE with SigmaXL

What is a Full Factorial DOE? In a full factorial experiment, 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 have 22 = 4 treatments…

Read More

Logistic Regression with SigmaXL

What is Logistic Regression? Logistic regression 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 logistic function used to model…

Read More

Multiple Linear Regression with SigmaXL

What is Multiple Linear Regression? Multiple linear regression 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 has one predictor. Multiple linear regression…

Read More

Simple Linear Regression with SigmaXL

What is Simple Linear Regression? Simple linear regression 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 of another variable. Both variables need…

Read More

Two Sample Proportion Test with SigmaXL

What is the Two Sample Proportion Test? The two sample proportion test 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 from the populations of…

Read More

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…

Read More

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. P Chart Equations Data Point:         Center Line:  …

Read More

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…

Read More

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…

Read More

U Chart with SigmaXL

What is a U Chart? The U chart 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 is the unit’s characteristic…

Read More

IR Chart with SigmaXL

What is an IR Chart? The IR chart (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 between two consecutive observations…

Read More

Xbar R Chart with SigmaXL

What is a Xbar R Chart? The Xbar R chart 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 within a subgroup as…

Read More

One Sample Wilcoxon Test with SigmaXL

What is the One Sample Wilcoxon Test? The one sample Wilcoxon test 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 data is non-normal. It is…

Read More

One Sample Proportion Test with SigmaXL

What is the One Sample Proportion Test? One sample proportion test 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 distribution with a specified…

Read More

Xbar S Chart with SigmaXL

What is a Xbar S Chart? The X-S chart (also called Xbar 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 subgroup as a data…

Read More

NP Chart with SigmaXL

What is an NP Chart? The NP chart 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. NP Chart Equations NP-chart Data Point: Center…

Read More

Mood’s Median Test with Sigma XL

What is Mood’s Median Test? Mood’s median test is a statistical test to compare the medians of two or more populations. Null Hypothesis (H0): η1 = … = ηk Alternative Hypothesis (Ha): At least one of the medians is different from the others The symbol k is the number of groups of our interest and…

Read More

Kruskal Wallis Test 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. Null Hypothesis (H0): η1 = η2 = … = ηk Alternative Hypothesis (Ha): at least one of the medians is different from others. Where: ηi is the median of…

Read More

Mann Whitney testing with SigmaXL

What is the Mann Whitney Test? The Mann Whitney test (also called Mann–Whitney U test or Wilcoxon rank-sum test) is a statistical hypothesis test to compare the medians of two populations that are not normally distributed. In a non-normal distribution, the median is the better representation of the center of the distribution. Null Hypothesis (H0):…

Read More