Select Page

Welcome to Helpful Stats!

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

Spearman’s Rank Correlation between Rice and Rainfall

Spearman's Coefficient of Rank Correlation (denoted by rho) is named after the British psychologist, Charles Edward Spearman. Rank correlation is a non-parametric variant of Karl Pearson's Coefficient of Correlation. This means, while Pearson's r requires an...

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-If Analysis Tools in Excel

What-If is a function built in to Microsoft Excel to compute answers to "what if" questions, exactly as the name suggests! A business would be faced many such "what if" questions - "What if we need to earn a profit of Rs. 10000, given that the profit per unit is Rs....

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