Select Page

Welcome to Helpful Stats!

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

Talking about Quartiles

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

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

Measuring the Spread of Data

We have already seen how it is easier to describe data using a single measure of central tendency, such as, average. Now, take a look at the following data: The average score for both students is equal. However, John is consistent at everything, while Arun is...

What is Linear Correlation?

The analysis of correlation is an extremely useful technique in business. Naturally, correlations are extremely popular in various analyses. Correlation is measured by a coefficient that is a statistical estimation of the strength of relationship between data. The...

The Basics

Statistics Stuff

Creating Models with Data