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

option spread calculatorcoefficient in excelformula for kurtosisnormdist functionwhat does oversold mean in the stock marketacceptable skewness and kurtosis valueshow to calculate excel formulasdollar weighted return calculatorannual rate of return formula excelblack scholes options pricing modelvxx etnstd deviation definitionaverages on excelcalculating exponential moving averageetf ticker listinverse s&p 500kurtosis of normal distribution3x leveraged etf liststd deviation and variancesp500 short etfoverbought stocksp500 short etfberkshire hathaway holdings changescall option strike pricearithmetic mean roughnessnorm.s.distspx chartweighted average cost of debt formulablack scholes deltathinkback thinkorswimvariance and standard deviation formulasblack scholes model formulayahoo finance spreadsheetmean variance and standard deviation formuladividends yield formulaskewness interpretationdelta of put optionmacd crosswhat is a macro hedge fundvelocityshares daily inversequote uvxyscholes mertonbullish call spreadwhat are the components of waccoptions futures hulleuro currency etfpercent relative standard deviation calculatorcalculating sample covarianceweighted standard deviation excelarithmetic mean return formulatypes of hedge fund strategiesspx historical chartwhat is a formula in excel definitionput black scholesonline black scholes option calculatorhow to interpret implied volatilitydifferent hedge fund strategiesexcel calculations formulascalculating sample varianceskewness examplesweighted average costingcalculating median in excelhow to find population mean in excelgeometric mean advantages and disadvantagesbullish call spreadcalculate the mean variance and standard deviationexcel macro formulassoros fund management 13fvariance and standard deviation formulasgeometric average return calculatorcompute implied volatilityskewness formulapopulation variance in excelhistorical volatility calculationoption deltasaverage true range formulacalculate wacc exampleblack scholes option pricing model explained