Select Page

Welcome to Helpful Stats!

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

Are All Variables the Same?

Ernest Rutherford The aim of analytics is to find answers to problems. How do we find answers to the problems? We do that using data. When we begin to statistically analyse some data gathered through an experiment, we come across different types of data or variables....

How to Compute the Measures of Dispersion using Microsoft Excel

Calculating Range in Excel Excel does not offer a function to compute range. However, we can easily compute it by subtracting the minimum value from the maximum value. The formula would be =MAX()-MIN() where the dataset would be the referenced in both the parentheses....

The Assumptions in Linear Correlations

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...

Building Linear Regression Models

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...

When Things are Correlated, Do they Cause Each Other?

We've talked about how popular the concept of correlation is in business analytics. Causation, and its variants are also used rather commonly. This makes it easy to mistakenly connect the two popular terms and even use them interchangeably. The Latin phrase, cum hoc...

The Basics

Statistics Stuff

Creating Models with Data