Welcome to Helpful Stats!

Follow along the content using the topic names below. The topics are grouped for easier navigation.

The Assumptions in Linear Correlations

by Soumyadip Pal | March 2, 2017 | Statistics | 0 Comments

Given how simple Karl Pearson's Coefficient of Correlation is, the assumptions behind it are often forgotten. It is important to ensure that the assumptions hold true for your data, else the Pearson's Coefficient may be inappropriate. The assumptions and requirements...

Talking about Quartiles

by Soumyadip Pal | May 5, 2019 | Statistics | 0 Comments

Quartiles are a frequently used method to split the data and understand the spread. In general, data can be divided in various groupings such that an equal number of points are in each group. Such groups are formed by cutting at specific points called quantiles. If...

Using Central Tendency Measures to Describe Data

by Soumyadip Pal | March 9, 2017 | Statistics | 0 Comments

The term central tendency refers to some values that tend to describe the centre of the complete data set. There are different measures of central tendency. Each of them give us one single number that attempts to summarise the entire data set within itself. Why do we...

Building Linear Regression Models

by Soumyadip Pal | March 16, 2017 | Statistics | 0 Comments

What is regression? In the dictionary, the word regression basically means 'to go back'. In terms of statistics too, the meaning is not too different - it means 'to go back to the past data to explain the process that generates the data'. In statistics, a model is a...

Building a Multiple Linear Regression Model

by Soumyadip Pal | April 3, 2017 | Statistics | 0 Comments

Previously, we have seen situations where an outcome (the dependent variable) is based on a single input variable (independent variable). Sadly, real life is rarely as simple. Most outcomes in real situations are affected by multiple input variables. To...

What’s the deal about data?
Are all data created equal?
- Quiz – Test your understanding
Describe data with central tendency
What’s Data Visualisation?
- Common chart types
- Create awesome charts on Excel
- Create your first dashboard on Excel
What’s Probability?
Introducing the Normal Distribution
What are sampling techniques?

Statistics Stuff

Correlations
Estimation techniques
Confidence intervals
Hypothesis testing
One-way ANOVA
Parametric tests
Non-parametric tests
What’s a time-series?
Forecast by smoothing a time-series
What’s seasonality?

Creating Models with Data

Linear regression models
Nonlinear regression models
Multiple regression models
What-if and Goal-seek in Excel
Linear optimisation
Nonlinear optimisation
Binary models
Integer models
Decision analysis