Tableau - Standard Deviation

To find the standard deviation for a measure in tableau, right click on the measure and select standard deviation:

stats_calculations

Note: The standard deviation calculates the dispersion or spread of data. When data points are close together, the standard deviation is low. When data points are more spread out, the standard deviation is high.

How does tableau calculate standard deviation? By default tableau uses the formula for the standard deviation a sample size. This is often called the sample standard deviation for short and is an unbiased estimate for the population standard deviation.

Note: For those with an Excel bacgkround, tableau uses Excel's STDEV.S by default.

Formula:

$$ s = \sqrt{\frac{\sum_{i=1}^N (x_i - \overline{x})^2}{N-1} }$$

Relationship between the variance and standard deviation: Standard deviation is the square root of variance.


Dash-Intel is a Power BI and Tableau resource site for data visualization and building BI dashboards.

Data Analyst & Consultant

Copyright 2015-2023 Dash-Intel.com Terms