Select Page

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

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

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

## Building Nonlinear Regression Models

We have talked about regression models in the context of linear regression models in the previous post. A nonlinear regression model is one that describes a nonlinear relationship between the dependent and the independent variables. Naturally, the equation of the...

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

#### Statistics Stuff

• Correlations
• Estimation techniques
• Confidence intervals
• Hypothesis testing
• One-way ANOVA
• Parametric tests
• Non-parametric tests
• What’s a time-series?
• Forecast by smoothing a time-series
• What’s seasonality?