Descriptive Statistics Calculator

Save time and make sure your calculations are correct.

Download Now
  • $15 one-time payment
  • Instant download from


The main sheet with calculations and histogram:

Descriptive Statistics Calculator - the main sheet

The sheet where you enter your data. Click the "Calculate Statistics" button and you are done:

Descriptive Statistics Calculator - data entry sheet

The macro automatically checks the data for any errors or formatting issues and displays a message with advice if anything is wrong.

Download Now
  • $15 one-time payment
  • Instant download from

PDF Guide

The Descriptive Statistics Calculator package also includes a PDF guide, which provides detailed instructions to its use and explains all the calculations and concepts one-by-one.

See overview of contents below:

Descriptive Statistics Calculator PDF Guide table of contents

Excel Versions

Desc_Stat_Calculator.xlsm = default version (for Excel 2010 and newer)

DSC_for_Excel_97-2007.xls = Excel 97-2007 version

The calculator works in all versions of Excel starting from Excel 97 and including 97, 2000, 2002 (XP), 2003, 2007, 2010, 2013, 2016 and 365.

Due to changes in statistical functions and some other features, users of Excel 2007 and older should use the Excel 97-2007 version of the calculator.

Every user gets access to both versions plus the PDF guide.

Download Now
  • $15 one-time payment
  • Instant download from

If you have any questions, please see FAQ or ask us.

Related pages

what is market capitalization with exampleproshare ultravqt etntrading macd histogramhow to use normdist function in excelfx volatility calculationexcel logarithmcall spread payoffcboe definitionblack scholes calculator with dividendsformula for standard deviation in excelarithmetical averagehow to invest in vix volatility indexrelative strength index exceldef variancestatistics median calculatorskew equationcalculate volatility exceltop options trading bookscalculating the standard deviation in excelstandard deviation formula for grouped datafx implied volatilityexcel cash flow diagramdelta black scholesdisadvantages of arithmetic meancontinuously compounded returnsnasdaq historical prices yahooformula for coefficient of variation in excelnifty call put option calculatorpricing excel templatenormdist excel functionhow to calculate a variance in excelderivation of variance formulahow to short the vixdelta of a call optionhow to calculate annualized volatilityblack scholes pricermedian of numbers calculatorcontinuous compounded returnannualised standard deviationblack scholes with dividend calculatormacd histogramhow to divide big numbers without a calculatorxiv etfwhat are some components of wacccalculating implied volatilityema vs smaliquid etfslifo fifo weighted averageskewness meaningipath etfsqrt excelhighest sharpe ratioarbitrage hedge fundlist of inverse etfsformula of population meanformula of average deviationstandard deviation formula on excelexcel formulas for stock tradingeuro usd etfreturn calculator excelcall option black scholespercentile statistics calculatorexponential moving average c#using macd to tradehow to annualize standard deviationaveraging down calculatorblack scholes price calculatorexcel formula for average percentageshare price volatility calculatoroption strategy straddlehistorical stock calculatortrading vix optionshistorical implied volatility chartcboe delayedblack scholes calculation