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 …
Course: Essential Mathematics for Data Analysis in Microsoft Excel
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 …
These articles are from the online course:
Essential Mathematics for Data Analysis in Microsoft Excel