res.marcus
New Member
- Joined
- Oct 18, 2012
- Messages
- 19
Hi,
I´m trying to calculate the standard deviation of a calculated measure per variable.
I have a table like this:
<colgroup><col><col span="3"></colgroup><tbody>
</tbody>
And I would like to calculate the standard deviation of these values per vaiable. The requested result for variable 1 in this example is 7,067208565.
When I try to do standard deviation calculations I get one unique value for each week - see below.
<colgroup><col><col span="3"></colgroup><tbody>
</tbody>
But what I really want is one value that I can use to identify large deviations in the calculated measure.
Does anyone know how to get it right?
Best,
Marcus
I´m trying to calculate the standard deviation of a calculated measure per variable.
I have a table like this:
Date | Sum of percentage in variable 1 | Sum of percentage in variable 2 | Sum of percentage in variable 3 |
201230 | 83,03094145 | 55,97272878 | 92,24959921 |
201231 | 73,84489647 | 51,94341392 | 89,37820926 |
201232 | 82,12073478 | 53,02193946 | 85,39993252 |
201233 | 84,68759472 | 48,88206236 | 90,67685169 |
201234 | 82,72898164 | 53,49932194 | 90,95449111 |
201235 | 83,16780315 | 61,96303925 | 90,53065014 |
201236 | 83,0222436 | 50,07188196 | 87,64743282 |
201237 | 87,80138219 | 58,30828708 | 87,8565807 |
201238 | 69,67478891 | 48,17744327 | 89,66835717 |
201239 | 77,23106208 | 48,57926405 | 94,64372303 |
201240 | 75,83743425 | 52,9489093 | 92,00524078 |
201241 | 98,60519992 | 61,07069471 | 88,33355519 |
<colgroup><col><col span="3"></colgroup><tbody>
</tbody>
And I would like to calculate the standard deviation of these values per vaiable. The requested result for variable 1 in this example is 7,067208565.
When I try to do standard deviation calculations I get one unique value for each week - see below.
Date | Standard deviation in variable 1 | Standard deviation in variable 2 | Standard deviation in variable 3 |
201230 | 9,316525234 | 7,352119492 | 8,057547247 |
201231 | 9,207568311 | 8,429782405 | 10,98418204 |
201232 | 8,750427961 | 7,513874159 | 8,509357209 |
201233 | 7,454698147 | 6,340021167 | 9,557455606 |
201234 | 9,183196767 | 7,64569251 | 8,434229083 |
201235 | 10,5959783 | 10,6020819 | 9,622005673 |
201236 | 8,357464059 | 5,613602674 | 8,517430214 |
201237 | 8,233784973 | 6,476803186 | 8,00956014 |
201238 | 7,056305771 | 6,842067964 | 10,06065965 |
201239 | 7,38807439 | 6,308675159 | 8,938462481 |
201240 | 7,940419973 | 7,766297405 | 11,25859248 |
201241 | 10,60519428 | 8,016290404 | 7,702836064 |
<colgroup><col><col span="3"></colgroup><tbody>
</tbody>
But what I really want is one value that I can use to identify large deviations in the calculated measure.
Does anyone know how to get it right?
Best,
Marcus