Forum Discussion
ONeed help with quintile in Excel or Power Query
Hi bsrujan022
For quintile I think you may need to categorize the scores into 5 categories (A, B, C, D, E). For quartiles, you can categorize them into 4 categories. But nevermind the calculation logic is similar. Below is my result for quintiles. You can download the sample file attached at bottom to see detailed Excel formulas.
References:
How to Perform a Percentile IF Function in Excel (statology.org)
How to Calculate Quintiles in Excel (With Examples) (statology.org)
IFS function - Microsoft Support
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Community SupportHi bsrujan022
For quintile I think you may need to categorize the scores into 5 categories (A, B, C, D, E). For quartiles, you can categorize them into 4 categories. But nevermind the calculation logic is similar. Below is my result for quintiles. You can download the sample file attached at bottom to see detailed Excel formulas.
References:
How to Perform a Percentile IF Function in Excel (statology.org)
How to Calculate Quintiles in Excel (With Examples) (statology.org)
IFS function - Microsoft Support
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.