The median represents a value that separates the higher half from the lower half of a data sample. Microsoft Excel has a function that allows you to calculate the Median easily.

Formula of Median: Know to How to Calculate Median for Even, Odd Numbers along with questions with solution.

The median is the middle number in a sorted ascending or descending list. It can be more descriptive of the dataset than the average. It’s quite different from the mean.

Formula of Mode: Know to How to Calculate Median for Grouped, Ungrouped Numbers along with questions with solution.

The mode is a statistical term for the value that occurs most frequently in a set of numbers. Learn about the difference between the mean, median, and mode.

You can calculate Ratio in Excel by using the GCD function and the Substitute function. This article is a step-by-step guide to help you.