Skip main navigation

Sigma Notation Part 1

Now that we understand that (X) represents a column of data, let’s take a look at how we can perform operations on the data that is represented by (X). In …

X Subscripts

In the last activity, we learnt that (X) represents a column of data in your data set. We still need a way to identify single variables in our data set, …

X is Not a Number

From algebra, we understand that (X) is a variable, but in statistics, (X) works a little differently. (X) is still a variable, but it does not represent a single number …

Formula Sneak Peek

In this section, we’ll dig into some of the actual math behind data analysis. The tools we’ll pick up in this lesson will form the bedrock of everything that comes …

Levels of Measurement Summary

There are four levels of measurement that we shall use when we are statistically analysing data. Let’s have a look at these briefly. Nominal Data These pieces of data indicate …

Numeric Data

Numeric data is not always as simple as it seems. Sometimes numbers represent items rather than giving us a simple count of the value of the items. We generally have …

Categorical Data

In the previous lesson, we learned about the different types of data. Here we’re going to look at different levels of measurement. Levels of measurement are different ways that we …

Maths and Data

In this introductory lesson, we’ll explore the basics of data set anatomy including variables, observations, and how a tidy data set is organised. We’ll also look at some concrete examples …

Tidy Data

It’s important that you know how to layout your data in an orderly way so that it is easy to work with. We shall call this a tidy data set. …

Introduction to Types of Data

In this lesson, we’ll explore a few different types and kinds of data. We’ll also talk about how these different types form a hierarchy, depending on how much information each …

Welcome to the Course

Welcome to the Essential Mathematics for Data Analysis in Microsoft Excel course. Starting with the absolute basics of maths and data, this course builds up your analyst skills while removing …

Welcome to the Course

Welcome to Microsoft Future Ready: Data Analysis Using Excel with Essential Mathematics course. Starting with the absolute basics of maths and data, this course builds up your analyst skills while …

Time Series Forecasting

Lesson 3: Time Series Forecasting In this lesson, we’ll look at another forecasting method. This one is useful if we have a long history of data (for example, revenue over …