## Creating formulas in Excel

In Excel, you can use formulas to populate the value of a cell. Formulas can be used to perform numeric calculations, such as: adding or multiplying altering text (e.g. removing …

## Measures of central tendency

A measure of central tendency is a single value that represents the centre of a data distribution. To determine the centre or central tendency of the data, we can calculate …

## Types of data analytics

Data analytics involves processing and performing statistical analysis of existing data sets. Data analytics can be of four types depending on the type and scope of analysis being conducted on …

## Causation and correlation

After learning how to describe a data set, the next step for data scientists is to start exploring the data to identify the possible interactions amongst the variables. The video …

## Descriptive statistics

In this video, you were introduced to descriptive statistics. As we learned earlier, descriptive statistics describe data to help the audience construct a mental picture of it. To do this, …

## How to test a hypothesis

After watching the video, you can recognise the five steps to testing a hypothesis. Testing a hypothesis requires data scientists to perform statistical analysis tests on the actual data set. …

## What is hypothesis testing?

The video covered three crucial concepts about hypothesis testing. These include: Why should we perform hypothesis testing? What is hypothesis testing? What are null and alternative hypotheses? It is important …

## Structured-thinking frameworks

A structured-thinking framework is a set of steps or stages that a data scientist can use to resolve a business problem in an evidence-based scientific manner. The three fundamental steps …

## Hypothesising in data science

’A hypothesis may be simply defined as a guess. A scientific hypothesis is an intelligent guess.’ – Isaac Asimov [1] ‘Hypothesis’ originates from the Greek words ‘hupo’ (under) and ‘thesis’ …

## Ethics in data visualisation

Data scientists are often the go-to people in an organisation to get a sense check on the organisation’s performance metrics. Therefore, they have a responsibility to portray the figures accurately. …

## Data ethics

While it may seem like the fields of data and ethics might not have much in common, in reality, they do. Despite tough regulations, data security and privacy breaches have …

## Creating charts in Excel

Excel offers a variety of tools to create effective and engaging data visualisations. In this video, you learned how to create different types of charts in Excel. Next, let’s engage …

## Why visualise data?

Data visualisation is the process of communicating information through charts, diagrams, dashboards, schematics, and graphics in a human-readable format. The video above explored some key examples and comparisons that demonstrate …

## The data science life cycle

When your business project involves handling big data, it is essential to have a workflow or a life cycle finalised at the beginning. There are certain advantages to locking in …

## The ‘data’ story

As the Cambridge Dictionary defines it, data is facts and statistics collected for reference, examination, or analysis that is used to help decision-making. [1] For example, at a manufacturing unit, …