Skewness Formula

This page provides and explains the formula for skewness and sample skewness. Skewness is one of the summary statistics; it is used for describing or estimating symmetry of a distribution (relative frequency of positive and negative extreme values). Skewness is very important in portfolio management, risk management, and option pricing and trading. You can easily calculate skewness in Excel using the Descriptive Statistics Excel Calculator.

If you don’t want to go through the lengthy derivation and explanation below, the formulas are here:

Population Skewness Formula

Population skewness formula

Sample Skewness Formula

Sample skewness formula

Detailed derivation and explanation of the formulas follows.

Skewness Definition

Skewness is the ratio of (1) the third moment and (2) the second moment raised to the power of 3/2 (= the ratio of the third moment and standard deviation cubed):

Skewness formula - moments Skewness formula - third moment and standard deviation

Deviations from the Mean

For calculating skewness, you first need to calculate each observation’s deviation from the mean (the difference between each value and arithmetic average of all values). The deviation from the mean for ith observation equals:

Deviation from the mean for i-th observation

Third Moment Formula

The third moment about the mean is the sum of each value’s deviation from the mean cubed, which (the whole sum) is then divided by the number of values:

Third moment formula

Second Moment Formula

The second moment about the mean is the sum of each value’s squared deviation from the mean, divided by the number of values. This is the same formula as the one you probably know as variance (σ2). Variance is standard deviation (σ) squared.

Second moment formula Variance formula Standard deviation formula

Skewness Formula

The direct skewness formula (ratio of the third moment and standard deviation cubed) therefore is:

Skewness formula (using standard deviation) Skewness formula (applying the standard deviation formula) Skewness formula (directly from deviations from the mean)

Sample Skewness Formula

The formulas above are for population skewness (when your data set includes the whole population). Very often, you don’t have data for the whole population and you need to estimate population skewness from a sample.

When calculating sample skewness, you need to make a small adjustment to the skewness formula (the function of the adjustment is to correct a bias inherent in small samples):

Sample skewness formula (using sample standard deviation)

Where:

n = sample size

s = sample standard deviation:

Sample standard deviation formula

Therefore:

Sample skewness formula (applying sample standard deviation formula) Sample skewness formula (directly from deviations from the mean)

For a very large sample (very high n), the differences between and among n, n-1, and n-2 are becoming negligible, and the sample skewness formula approximately equals:

Sample skewness formula for large sample size

And therefore approximately equals population skewness formula:

Population skewness formula

You can easily calculate skewness, kurtosis, and other measures in Excel using the Descriptive Statistics Excel Calculator.


Related pages


annualizing standard deviationformula for standard deviation excelhow to manually calculate standard deviationexcel formula explainedvix hedge3x vix etfcost of ending inventory formulacboe trading hoursskewness in statisticshistorical volatility datasample excel formulasstandard deviation formula in exceloptions futures and other derivatives solutionsintrinsic value of put option formulaatr technical analysisnormsdist calculatorvxv etfsum of squared deviation calculatoratr average true rangesvxy prospectusskewness and kurtosis examplesvix historical chartskew definition mathimplied volatility calculator excelspx settlement valuecost of equity formula waccdelta of put option formulaspot markets versus futures marketsshort uvxyblack schole option pricing modelportfolio weight calculatorbearish call spreadbullish divergence macdwhat is the macd indicatorlong straddle option strategys&p 500 calculationn d1 calculatorhow to calculate variance excelstock price volatility calculationwww.proshares.comfloat adjusted market capleveraged inverse vix etfexcel std deviationblack scholes calculatormacd signal line crossoverdow jones industrial average calculationvix etn listcalculating skewsharpe calculatorexplain kurtosishow to calculate bep in exceletn tickerstock rsi meaningmacro hedge fund definitionnormdist function in exceloptions trading booksfinding the median in excelwhat is stdevhow to convert standard deviation to percentageadvantages and disadvantages of mean median modemeasures of skewness in statisticsstandard deviation without calculatorhow to plot break even graph in excelwhat is standard deviation in mathsintraday volatilitysample covariance excelvxx etf ipathformula for finding the sample meanunbiased standard deviation calculatorblack and scholes formulashortcut standard deviation formulac# exponential moving averagebull call spread calculatorintrinsic value of put optionscholes merton