Course: Essential Mathematics for Data Analysis in Microsoft Excel

In order to work with KPIs, we’re going to get some hands-on experience by using labs. There are four areas that you are going to explore in the following labs: …

Our second approach to forecasting is called Time Series Analysis, and we’re going to use this when we have time-series data. Time series data is simply historical data that’s date …

In the previous step, we learned that we can reject the null hypothesis if we can get a small (p)-value. If we are able to reject the null hypothesis, it …

The null hypothesis says that there are no real trends in our data and that everything we’re seeing in your sample is just noise. We want to find a way …

Null hypothesis testing is just a simple question we’re going to ask of our data: are the trends that we see in the data real or just random noise? We …

In this activity, we’ll get a quick introduction to two methods for exploring future trends in data: null hypothesis testing and time-series analysis. With data analytics, we can actually tell …

In the previous step, we discovered KPIs. This lesson will look at some common examples so that we can create some context around how KPIs are used in a business …

In this short activity, we’ll dip our toes into the wide, wonderful world of business math and KPIs. We need to be able to keep score on all the different …

A Key Performance Indicator (KPI) is a measurable value that demonstrates how effectively a company is achieving key business objectives. Organisations use KPIs at multiple levels to evaluate their success …

Crosstabs are a useful way to look at relationships among categorical (nominal or ordinal) variables. Cross tabs are basically a table of data where there are two categories that need …

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 …

Just as we have a backup for the mean, which is the median, we also have a backup for standard deviation, which is the semi-interquartile range. The semi-interquartile range is …

Sometimes we can’t use the mean because we have too much skew or extreme scores. In those situations, the mean is meaningless. In the above example, we have data with …

We used the equation for standard deviation at the beginning of this course as an example of a formula. In this activity, we’re going to learn what the equation does …

So far, we have had a look at the formula for standard deviation. In this activity, we are going to learn what standard deviation is and how we are going …