W is the weight applied to each comparison. Weight is an attribute, fact, or metric representing a list of numbers to define the weight of each comparison. A correlation is calculated on these values to determine the level of association between the two values. WeightedCorr ( Argument1, Argument2, Weight )įactID is a parameter that forces a calculation to take place on a fact table that contains the selected fact.Īrgument1 and Argument2 are attributes, facts, or metrics representing lists of numbers for comparison. To determine the correlation of two values without applying a weight to the comparisons, see Correlation. Correlation comparisons with a higher value for their weight are considered as more significant when compared to the other value comparisons. Values that are closely related with either a positive or negative correlation will have a correlation close to 1 or -1 respectively, while values that are not correlated at all will have a correlation close to 0.Ī weighted correlation allows you to apply a weight, or relative significance to each value comparison. Standard Functions » OLAP functions » WeightedCorr (weighted correlation) WeightedCo rr (weighted correlation)Ī correlation of two values describes the degree to which the values are related or associated.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |