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

intrinsic value excellifo fifo weighted averageipath barclaysblack scholes valueoversold overboughtquote historical pricesdirectional hedge fund strategygood sharpe ratioending inventory formula accountinghow to calculate root in excelcboe option calculatorsample covariance in excelblack scholes formulasinterpreting kurtosisinferential statistics calculatoretf correlation calculatorlognormal volatilityoptions calls and puts for dummiesstandard deviation formula excelexponential moving average excel formulavix pricesacceptable skewness and kurtosis valueshow to calculate cost of preferred stock in wacckurtosis coefficientvolatility calculation formulameasures of variation calculatoruvxy inversespx settlement pricemaximum profit equationrsi overboughtshort call payoffcalculation of wacc exampleblack scholes call option formulastdev sblack scholes formula excelstandard deviation equation excelformula to calculate variance percentagepreferred equity formulahow to calculate variation in exceldefinition of sample varianceexcel calculator formulasell put option graphexcel formulas spreadsheetstock price simulation excels&p short etfhow to measure skewnesscolor codes for notepadtvix etfcfe cboepopulation calculator statisticswhat is the formula for sample variancethe black scholes model explainedvariance and standard deviation in financewhat does oversold mean in the stock marketshort call payoff diagramhow do you buy the vixoptions futures and other derivatives by john c hullbarrier option calculatorbull spread calculatorhistorical volatility vs implied volatilityexcel formula for average percentagesquared deviation formularumus black scholesmodified sharpe ratiocalculating covariance in excelcomputational formula for standard deviationshort straddle optionstatistical skewnesspayoff put optionstandard deviation formula shortcutvariance defberkshire 13fexcel formula varianceoptions volatility calculator