en | de Excel
Apr 27, 2023 11:45 AM

# Standard Deviation in Excel using the NEW Functions

by HubSite 365 about Mynda Treacy (MyOnlineTrainingHub) [MVP]
Pro User

Excel

## How to calculate the Standard Deviation in Excel with separate functions for the standard deviation of a sample or a population.

How to calculate the Standard Deviation in Excel with separate functions for the standard deviation of a sample or a population.

Standard Deviation in Excel using the NEW Functions is a feature that was added to Excel in the Office 365 version released in 2018. This feature allows users to calculate standard deviation in Excel using the new STDEV.P and STDEV.S functions. These functions calculate the standard deviation of a population or sample of data. The STDEV.P function uses the entire population to calculate the standard deviation, while the STDEV.S function uses a sample of the population. Both functions require the user to input a range or array of data, which is then used to calculate the standard deviation.

## What is Standard deviation ?

Standard deviation is a statistical measure that quantifies the amount of variability or dispersion of a set of data values from their average or mean. It is calculated as the square root of the variance, which is the average of the squared differences between each data point and the mean.

A low standard deviation indicates that the data points are clustered closely around the mean, while a high standard deviation indicates that the data points are more spread out. Standard deviation is commonly used in various fields, including finance, engineering, and science, to describe the amount of variation in data sets and to make predictions about future data points.