Tuesday, 1 April 2025

Standard Deviation P and Standard Deviation S - SD

In Power BI, Standard Deviation P and Standard Deviation S refer to two different methods for calculating standard deviation, and they differ in the way they handle sample data versus population data. Here’s an overview of each:

1. Standard Deviation P (Population Standard Deviation)

  • Formula:

    σ=(Xiμ)2N\sigma = \sqrt{\frac{\sum{(X_i - \mu)^2}}{N}}