This example shows a report where the standard deviation and a weighted standard deviation of the revenue are calculated. For entire populations, see StDevP (standard deviation of a population). In this function, arguments correspond to a population sample as opposed to the entire population. N’: The number of weights that are not equal to zero. Values with a higher value for their weight are considered as more significant to a sample as compared to the other values in a sample. Weight is an attribute, fact, or metric representing a list of numbers to define the weight of each value.įactID is a parameter that forces a calculation to take place on a fact table that contains the selected fact. This is a group-value function.Īrgument is an attribute, fact, or metric representing a list of numbers. WeightedStDev returns the weighted standard deviation of a population based on a sample. It is useful for comparing different sets of values with a similar mean.Ī weighted standard deviation allows you to apply a weight, or relative significance to each value in a set of values. The standard deviation is an indicator of how widely values in a group differ from the mean (see StDev (standard deviation of a sample)). Standard Functions » OLAP functions » WeightedStDev (weighted standard deviation of a sample) WeightedSt Dev (weighted standard deviation of a sample)