When you need to select a random data sample from a larger group or population, you can use Excel to generate the sample and avoid any bias in your sampling technique. In this short video you will learn how to select a sample of 10 from a population of 10...

From Eugene O'Loughlin

If you have two sets of data to plot on the same chart, but the values are vastly different from each other - you may need use a secondary axis. In this video, learn how to show two lines on the same chart in easy steps in a great data visualization.
Fac...

From Eugene O'Loughlin

If you want to visualize hierarchical data, then a sunburst diagram may be suitable for you. Sunburst diagrams help you to visualize hierarchical data beyond the classic bar and line charts.
This example uses ficticious bookshop sales data taken from th...

From Eugene O'Loughlin

Creating a Pareto Chart in Excel is now easier than ever. Learn how to create a simple chart to help identify the 20% of causes that account for 80% of effects. Based on the Pareto Principle, a pareto chart helps us to identify and prioritise the most imp...

From Eugene O'Loughlin

The Wilcoxon Signed Rank Test is a non-parametric test for comparing two paired (dependent) data sets. It is an alternative to Students Paired t-Test and is used when one or more of the data sets is not normally distributed, and sometimes when sample siz ...

From Eugene O'Loughlin

When you want to compare the means of three or more samples, a one-way ANOVA test is the appropriate test to use.
This video shows you how to open an Excel file in SPSS, and to set up the data for running an ANOVA test. It compares the means of three sam...

From Eugene O'Loughlin

Use Student's t-test to compare the means of two samples. However, the formulas that you use depends on whether the samples are paired or unpaired. If unpaired you also have to check for equality of variance. This video maps out a path to each of the thre...

From Eugene O'Loughlin

Use IBM's SPSS tool to test for significant difference between two unpaired groups. In this step-by-step video you will learn how to first prepare your data for analysis, run, and analyse the output of the test....

From Eugene O'Loughlin

Learn how to generate the range, variance, and standard deviation (which are measures of variability in sample data), to determine how variable a data set is. IBM's SPSS is an ideal tool that can be used to quickly determine these measures - this video sh...

From Eugene O'Loughlin

Learn how to perform a chi-square test for independence. The test is applied when you have two categorical variables from a single population. It is used to determine whether there is a significant association between the two factors.
In this video, the ...

From Eugene O'Loughlin

Learn how to perform the Mann-Whitney U Test by hand when you need to test for significant differences between two groups. Use this test instead of the Student T Test when data are not normally distributed, or when you are using ordinal (such as ratings) ...

From Eugene O'Loughlin

Learn how to make predictions using Simple Linear Regression. To do this you need to use the Linear Regression Function (y = a + bx) where "y" is the dependent variable, "a" is the y intercept, "b" is the slope of the regression line, and "x" is the indep...

From Eugene O'Loughlin

Also known as a "Goodness of Fit" test, use this single sample Chi-Square test to determine if there is a significant difference between Observed and Expected values. This video shows a step-by-step method for calculating Chi-square....

From Eugene O'Loughlin

To test if there is a significant difference between two sets of data, Student's t Test is used. In this video the t Test is for unpaired (independent) samples. An F test is conducted first to determine if variance is equal or unequal - in this example th...

From Eugene O'Loughlin