Underlying Calculation for Standard Deviation Factors | Tableau Software

KNOWLEDGE BASE

Underlying Calculation for Standard Deviation Factors

Published: 28 Feb 2017
Last Modified Date: 20 Jul 2023

Question

What is the underlying calculation tableau uses for standard deviation. More specifically, what is the underlying calculation for the standard deviation factors in Tableau?

Environment

Tableau Desktop

Answer

The calculation Tableau Desktop is running for Standard Deviation is what every text book lists as the definition of standard deviation.

The -1/1 factor is AVG - 1*STDEV and AVG + 1*STDEV and the -2/2 factor is AVG - 2*STDEV and AVG + 2*STDEV.

Additional Information

The attached workbook contains examples of calculating the -1/+1 manually using Table Calculation Functions.

Click here to return to our Support page.

Open a new case

Click here to go to our Support page.

Get detailed answers and how-to step-by-step instructions for your issues and technical questions.

Find and share solutions with our active community through forums, user groups and ideas.

Browse a complete list of product manuals and guides. Available online, offline and PDF formats.

Learn how to master Tableau’s products with our on-demand, live or class room training.

All Support

SUPPORT BY PRODUCT

TOOLS & DOWNLOADS

INFORMATION

ASSISTANCE