Archive | How to with SigmaXL 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 [...] 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 [...] 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 [...] One Sample Proportion 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 [...] Two Sample t Test with SigmaXL

Two Sample t Test Two sample t test is a hypothesis test to study whether there is a statistically significant difference between the means of two populations. Null Hypothesis (H0): μ1 = μ2 Alternative Hypothesis (Ha): μ1 ≠ μ2 Where: μ1 is the mean of one population and μ2 is the mean of the other [...] Paired t Test with SigmaXL

Paired t Test The third type of a Two Sample t-Test is the Paired t Test.  This test is used when the two populations are dependent of each other, so each data point from one distribution corresponds to a data point in the other distribution. When using a paired t test, the test statistic is calculated [...] 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 [...] One Way ANOVA with SigmaXL

What is One Way ANOVA? One way Analysis of Variance is a statistical method to compare means of two or more populations. It is a generalized form of the two sample t-test since a two sample t-test compares two population means and one way ANOVA compares k population means where k ≥ 2. Null Hypothesis (H0): μ_1=μ_2=...=μ_k [...] 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): [...] 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 [...] Pareto Analysis with SigmaXL

Pareto Principle The Pareto principle is an observation not a law.  Named after Italian economist Vilfredo Pareto, this principle states that for a variety of situations, 80% of consequences come from 20% of the causes, thus the Pareto principle is also known as the 80/20 rule. The 80/20 rule basically reminds us that the comparison of [...] Moods Median Test with SigmaXL

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 [...]