The weighted standard deviation also takes into account the weights of each revenue value. WeightedStDev(Revenue, Revenue) įor this example, the revenue values are also used as the weights given to each revenue value included in the standard deviation. The definition of the standard deviation metrics are as follows: The report contains the attributes Customer Region and Customer State, and the metrics Revenue, Standard Deviation, and Weighted Standard Deviation. The calculation is based on the revenue values for each state within a region and calculated at the region level. This calculation is based on the assumption that the list of values supplied in the metric represents a sample of the data for which you want to obtain the standard deviation. 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).
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. FactID is a parameter that forces a calculation to take place on a fact table that contains the selected fact.Weight is an attribute, fact, or metric representing a list of numbers to define the weight of each value.Argument 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)).
WeightedSt Dev (Weighted Standard Deviation of a Sample)
0 kommentar(er)
