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

note pad backgroundhow to calculate a sample variancevix futures symbolquote downloaderdelta of an option formulahow to trade with macdstandard deviation equation excelintrinsic value vs market valueacceptable skewness and kurtosisproshares vixexplain skewnesscalculation formulas for excelannualized return formula excelnormdist calculatorwhat is standard deviation in mathswhat is the formula for dividend yieldmean mode median exceloptions the greekshow to calculate market value of debt for waccrealized rate of return calculatorcalculate standard deviation calculatorrealised volatility formulavolatility as an asset classhow is the vix calculatedsell straddles&p 500 2x etfvariance calculation in excelmost liquid etf optionsscholes mertonaverages in exceltriple leveraged vix etfproshares ultra vix short term futuresmsft stock split historythe greeks financeoption straddle examplemorgan stanley historical stock pricecalculate covariance excelformula for sample variance in statisticsdjia divisormarket capitalization weightedhistorical volatility chartskewness examplecalculate sample standard deviation excelcalculating mean on excelkurtosis examplevix trading strategiestvix optionsgamma options tradingetf and etnmacd crossoversavco methodarithmetic return calculatorpositive and negative numbers calculatorultra short sp500cboe comvix index bloombergmean variance calculatorvix settlement pricesblack scholes options pricingaapl stock charthow to calculate weighted average cost of debtstandard deviation equation in excelbook on options tradingprofit and loss formulasfinance variance formulaschedule 13fmarket capitalization weightedstandard deviation excel templatevixy.comhow to download stock prices from yahoo financecalculate formula in excel