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