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

standard deviation on financial calculatorarithmetic mean calculation formulavix symbolhow to calculate variance excelsection 13f securitiessp500 vixsharpe ratiosstock calculator excelsharpe ratio for stocksrelative average deviation calculatorvolatility etf 3xadaptive moving average formulaatr indicator explainedshort vixmodified black scholeshow to buy vixcboe delayed quotesvariance function excelapple stock history graphaapl price historyyahoo finance historical exchange ratese excel formulahow is dow jones industrial average calculatedat symbolvix optionexcel formulas for calculationcut your losses origin13f securities listhow to average percentages in excelvariance calcintrinsic value of call optioncboe vix quoteannualized volatilitycalculate std deviationsample variance formula excelmarket value of debt waccblack scholes theorydefine vixgeometric mean advantages and disadvantagesoption calculator excelgood sharpe ratiocharacteristics of a hedge fundgeometric mean negative numbersexcel mean deviationspx vs spywhat is a straddle option13f-hrcumulative excel formulaavco advantages and disadvantagespayoff diagrams for call and put optionsavatageformula for sample varianceprofit loss calculator optionsoption greeks formulaoptions yahoo financespot markets versus futures marketsforecast variance formulacalculator with negative signspayoff short putvxx indexdelta hedge optionsgamma call optioncalculation of waccdow divisorblack & scholes modelvix options expirationdefine macdstandard deviation population calculatorvariance shortcut formulaexcel function stdevoptions straddlekurtosis calculationoptions greek calculator