Whats the meaning of resting 0.5 to each position and then divide it by the N in the percentile formula?I can not get whats the specific meaning of 0.5, is it related to percentile instead of any other quantile?
Is the rank really just the ordinal number or is it the rank in the mathematical sense, the arithmetic mean of the ordinal numbers? So instead of giving the two 67s in the beginning rank 1 and 2, they would both get rank 1.5 = (1 + 2) / 2. For that excel provides the function rank().
The ranking is ordinal, for the two 67, the one in the first cell is in the rank 1 and the second cell rank 2.. The same reasoning for box plot and median... the value does not count to attribute a position. Just sort the data and label them accordingly.
Thank you so much
Thanks
Whats the meaning of resting 0.5 to each position and then divide it by the N in the percentile formula?I can not get whats the specific meaning of 0.5, is it related to percentile instead of any other quantile?
Is the rank really just the ordinal number or is it the rank in the mathematical sense, the arithmetic mean of the ordinal numbers?
So instead of giving the two 67s in the beginning rank 1 and 2, they would both get rank 1.5 = (1 + 2) / 2. For that excel provides the function rank().
The ranking is ordinal, for the two 67, the one in the first cell is in the rank 1 and the second cell rank 2..
The same reasoning for box plot and median... the value does not count to attribute a position.
Just sort the data and label them accordingly.
@@cococnk388 So can we use same idea to check the Likert scale data points distribution where we getting duplicate ratings , please