Skip to main content

Excel Tips: Calculation & Formulas > Statistic Functions

Author: Kelly Last Modified: 2020-03-23

MEDIAN Function

How to calculate median if multiple conditions in Excel?

How to calculate median in a range in Excel?

How to calculate median in an Excel pivot table?

How to calculate the median in visible cells only in Excel?

How to median values ignore zeros or errors in Excel?

PERCENTILE or QUARTILE Functions

How to calculate rank percentile of a list in Excel?

How to calculate the percentile and quartile of a set of numbers in Excel?

How to quickly calculate percentile or quartile ignore zeros in Excel?

Others

How to calculate frequency distribution in Excel?

How to calculate standard deviation in Excel?

How to calculate standard error of the mean in Excel?

How to use countif to calculate the percentage in Excel?