If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

calculating standard deviation in a crosstab

Started by johangel, 13 Aug 2012 12:46:37 PM

Previous topic - Next topic

johangel

Hi everyone,
I have a crosstab:
the row = education discipline
the colums: the points going from 0 to 20, so there are 21 colums called 'points'
the body: number of students who get the different scores
f.i.
biologie: 2 students with 0 points, 1student  with 1point,6students  with 3points,....1 student with 20 points ( ;D)
total of students for education disipline and average for education disipline is no problem,but how to calculate standarddeviation.?
I made this sd:

"total(power(points - average);2) for education disipline) / total students" give me a result, but not the result I expect, it is to high. (the aggregate properties of the data item sd  is set 2X to none)

The built in function standard deviation is not working, it gives the same result for every colum,whatever I do
"standard_deviation(points) for education discipline"
"standard_deviation(points) for all education discipline"
"standard_deviation(points) for any education discipline"
"distinct standard_deviation(points) for education discipline"
Thank you