Course: Essential Mathematics for Data Analysis in Microsoft Excel

Lesson 2: Business KPIs In this lesson, we’ll roll up our sleeves and calculate a few different types of KPIs used often in the business world, with a special focus …

Lesson 1: Introduction to KPIs In this short lesson, we’ll dip our toes into the wide, wonderful world of business math and KPIs.

Proportions are percentages but written as a decimal such as 0,5 for 50%. People often think of these as averages but they’re actually a little bit different. In the above …

Lesson 4: Bar Graphs and Pie Charts This lesson throws a couple new types of data visualization into the mix: bar graphs and pie charts. We’ll see why bar graphs …

Lesson 2: Skew In the second lesson of this module, we’ll look at a new concept called “skewness,” which measures how asymmetrical (or skewed) a set of data is. We’ll …

Lesson 3: Non-Normal Distributions In this lesson, we’ll take a brief look at some other distributions of data. We’ll also explore the differences between “discrete” and “continuous” data. Lab: Count …

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 …

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 …

Lesson 1: Histogram Overview and Normal Distribution This lesson gives some hands-on experience with our first data visualization: the histogram. It’s much easier to understand what our data are saying …