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

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

    Re: Standard Deviation in PowerPlay Transformer

    ‏2012-06-04T23:13:42Z  
    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

    Re: Standard Deviation in PowerPlay Transformer

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

    Where should i enter it ?

    Thanks
  • yangling
    yangling
    38 Posts

    Re: Standard Deviation in PowerPlay Transformer

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

    Where should i enter it ?

    Thanks
    Did you try measure | type | calculation? See the image.