Course: Essential Mathematics for Data Analysis in Microsoft Excel

Sometimes we can’t use the mean, either because we have too much skew, or we have extreme scores. In those situations, we’re going to use the median. The median is …

Now that you understand the mean, let’s have a look at when you would use the mean and when you should avoid it. In most instances, the mean gives us …

Instead of using the mode, the mean is the most useful measure of what a typical score is doing because it is, by definition, the average. We use symbols for …

In the previous activity, we differentiated between histograms and bar graphs. Let’s have a look at why it is better to use a histogram or a bar graph, rather than …

In this activity, we’ll look at the three M’s of data analysis: Mode, Mean and Median. They each measure the ‘centre’ of a data set in a slightly different way …

Now that we understand histograms, let’s have a look at the difference between a histogram and a bar graph. Histogram Histograms make sense when a range of (x)-values is continuous, …

In the previous steps, we have discovered the skewness of our histogram. But, not every histogram will have a bell curve or a skewed bell curve. In this step, we …

Now we’re going to have a look at a variable when you have counted something. This is really common in data analysis. Often, the variables that we are analysing represent …

Now that we are able to make a histogram, let’s have a look at what the shape of the histogram is telling us about our data. The above image shows …

In Week 1 we discovered data and explored basic functions with data. Let’s take a look at how we can visually represent data. The most useful way to do so …

Now that we understand how to find the mean, let’s have a look at how to apply standard deviation. Remember that we had a look at this equation earlier in …

Now that we understand the basics of Sigma notation, let’s begin with some statistical formulas. The first one we’re going to look at is how to calculate the average of …

Let’s unpack our knowledge of Sigma notation a little further now. In the previous step, we recapped our math experience of following the order of operations: Parentheses Exponents Multiplication / …

Now that we understand how to work with an operation inside the parentheses after (Sigma), let’s take it to the next step. In maths, we always follow the order of …

In the previous step, we learned that (Sigma) is a basic instruction that tells you to add up data. Let’s take our knowledge of (Sigma) one step further. The basic …