Select Page

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

## Using Central Tendency Measures to Describe Data

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

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

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

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

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

#### Statistics Stuff

• Correlations
• What’s Probability?
• Introducing the Normal Distribution
• What are sampling techniques?
• Estimation techniques
• Confidence intervals
• Hypothesis testing
• Z tests
• Paired and Unpaired t-tests
• One-way ANOVA
• Parametric tests
• Non-parametric tests