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

How to calculate quartile

Started by midhl, 16 Mar 2011 08:25:10 AM

Previous topic - Next topic

midhl

Hi,

We have a requirement were in we need to display a summarized row of data showing the average,mean,mode,median and 25% ile and 75 %tile of salaries for all employees (1 row of data).
Could someone please let me know how to calculate 25th %ile and 75 th %ile columns.Based on quartile function (Quartile (salary),i tried to calculate them but its just returning rank value 1 for 25% ile but need salary for that quartile and also no value is getting displayed for
75 %ile. Does this mean only 25% can be calculated for the given scenario and not 75 %ile since quartile value is showing only 1?(As it is only one row).
Could someone help me if at all any ideas

Thanks in advance