Select Page

Welcome to Helpful Stats!

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

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

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

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

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

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

More on Statistics