Course: Data Analytics for Decision Making: An Introduction to Using Excel

Congratulations on finishing all the activities in this course. Based on the popularity of this course, Bond University is offering a 2-week course that flows on from this subject, which …

Graphs? Why Graphs? Do you think of graphs when you think of data analysis? Maybe you do, but if you don’t then it’s time to start. Often people consider effective …

Welcome to our final activity for the course. Here, we want to take a big step back away from learning specific methods and instead look at the environment in which …

In this activity, we introduce the idea of discrete random variables. A random variable is simply a variable where the value is uncertain. For example, we may record the number …

In the last activity, we introduced the idea of simple events. Now, we’ll turn our attention to more complex events and look at how we can calculate probabilities for combinations …

Welcome to week 2! Last week you saw graphical techniques, descriptive statistics, and heard about ethics in analysis. This week will focus on how we can work with probability. The …

Most people don’t think of ethics when they think of data analysis, but it plays an important role. Ethics should be considered in being careful in how you do your …

In the last activity, we addressed the ‘what’ and the ‘why’. You now know what some common and useful graphical techniques are and you also know why we use them. …

Often, we don’t struggle from a lack of data but instead too much of it. By having too much information, it is difficult to identify important features of the data …

To Lease or Not To Lease (Continued) Coefficient of variation is our solution to the scenario when one project has better expected cash flows but worse variance. It provides a …

This video is also used at the end of a longer, more detailed data analytics course taught in the MBA at the Bond Business School, Bond University. It’s actually the …

To Lease or Not To Lease In this video we started applying what we have learned so far for a real business problem. This is an example, but it isn’t …

To Lease or Not To Lease (Continued) Using the expectation and variance from the last video, we can now make a decision as to which project was better. To do …

Expectation of a Random Variable In Week 1, we spoke about how we can describe the central location of a variable. This is also important to measure for random variables. …

Spread for Discrete Random Variables Spread of a random variable is also important to know to understand how different outcomes are likely to be from our expectation. To measure this …