Topic
• 3 replies
• Latest Post - ‏2012-06-05T15:28:35Z by yangling
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
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.

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
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
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.