SigmaXL
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…
Read MoreXbar 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…
Read MoreTwo 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…
Read MoreOne 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…
Read MoreOne 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…
Read MoreKruskal 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…
Read MoreP 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…
Read MoreU 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…
Read MoreXbar 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…
Read MoreIR 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…
Read MoreFractional 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…
Read MoreFull 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…
Read MoreLogistic 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…
Read MoreAttribute 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”…
Read MoreChi 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…
Read MoreBox 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 MoreMultiple 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…
Read MoreSimple 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…
Read MoreCorrelation Coefficient with SigmaXL
What is a Correlation Coefficient with SigmaXL The Correlation Coefficient with SigmaXL or Pearson’s Product Moment correlation coefficient is also called Pearson’s r or coefficient of correlation, where r is a statistic measuring the linear relationship between two variables. What is Correlation? Correlation is a statistical technique that describes whether and how strongly two or…
Read MoreMedian Test with SigmaXL
What is a Mood’s Median Test with SigmaXL? The Mood’s median test with SigmaXL 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…
Read More