Topic
3 replies Latest Post - ‏2012-06-05T15:28:35Z by yangling
Damien63
Damien63
2 Posts
ACCEPTED ANSWER

Pinned topic Standard Deviation in PowerPlay Transformer

‏2012-06-01T09:45:48Z |
Hi,

I'm working on a new cube and i need to create a measure : "Std Dev of Value"

Transformer just don't do that. How can i do this calculation using external rollup or something else please ?

Example of datas :
Month Country Value
201202 FRANCE 15
201202 USA 12
201203 BRAZIL 3
I would like to show for year 2012 : sqrt((15-10)²+(12-10)²+(3-10)²/3) = sqrt((25+4+49)/3) = sqrt(26)

Do you have an idea?

Thanks !
Updated on 2012-06-05T15:28:35Z at 2012-06-05T15:28:35Z by yangling
  • yangling
    yangling
    38 Posts
    ACCEPTED ANSWER

    Re: Standard Deviation in PowerPlay Transformer

    ‏2012-06-04T23:13:42Z  in response to Damien63
    PowerPlay for Windows plots these lines at 1.5 standard deviations from the mean. An example can be found by looking at Great Outdoors.
    Hope this online help helps:

    Standard-Deviation
    Description
    Returns the standard deviation of selected data items.

    You can use standard deviation to measure the deviation or dispersal of values from the mean. A low standard deviation indicates that most values are distributed close to the mean, and a high standard deviation indicates that values are more spread out from the mean.

    Example
    If the average mark for an exam is 63, approximately sixty-eight percent of the scores fall within the one standard deviation and approximately ninety-five percent of scores fall within two standard deviations of the average value. So if the standard deviation is 5, approximately sixty-eight percent of the group scored between 58 (63-5) and 68 (63+5). Approximately ninety-five percent of the group scored between 53 63-(2*5) and 73 63-(2*5).

    The following formula represents the standard deviation for a sample: √(∑(-∑())2

    Syntax
    standard-deviation (numeric_exp)
    Example
    standard-deviation (Product Cost)
    Returns the result: A value indicating the deviation between product costs and the average product cost.
    Note
  • Damien63
    Damien63
    2 Posts
    ACCEPTED ANSWER

    Re: Standard Deviation in PowerPlay Transformer

    ‏2012-06-05T06:57:40Z  in response to Damien63
    Thanks for your reply but i can't insert this function into the measure calculation (unknonw function)

    Where should i enter it ?

    Thanks