Question description:
This user has given permission to use the problem statement for this
blog.
how do you calculate percentile rank in excel when the question mean is known for 10 companies. Example the Mean is 3.58 from the sum of the 10 companies Mean divided by 10. The lowest Mean of the 10 organizations is 2.85 and the highest Mean is 4.22
Our goal is to be able to show the percentile rank of the 10 companies for their mean.
Solved by X. W. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
07/08/2018 - 02:00
Hi
Excelchat Expert
07/08/2018 - 02:00
Welcome to Got it Pro
Excelchat Expert
07/08/2018 - 02:01
Are you there?
User
07/08/2018 - 02:01
yes
Excelchat Expert
07/08/2018 - 02:02
Do you have any excel sheet
User
07/08/2018 - 02:02
yes
Excelchat Expert
07/08/2018 - 02:02
Can you please send me
User
07/08/2018 - 02:04
Well it isn't that easy due to propriety issues with clients. If you give me 5 minutes I could work with the file
Excelchat Expert
07/08/2018 - 02:04
please create sample file
Excelchat Expert
07/08/2018 - 02:05
Once you completed please let me know'
Excelchat Expert
07/08/2018 - 02:16
ARe you there?
Excelchat Expert
07/08/2018 - 02:16
Our timing is going to expire
Excelchat Expert
07/08/2018 - 02:16
please extend the time
Excelchat Expert
07/08/2018 - 02:16
Are you there?
User
07/08/2018 - 02:17
Yes, can you see what I just typed or do I need to email it to you. If so, what is your email.
Excelchat Expert
07/08/2018 - 02:18
No need.
Excelchat Expert
07/08/2018 - 02:18
I will work on it
Excelchat Expert
07/08/2018 - 02:22
I am working on it
Excelchat Expert
07/08/2018 - 02:27
Is it fine
User
07/08/2018 - 02:29
Appears so, but did you insert a formula to get what you have showing here and is there a way I can keep this.
Excelchat Expert
07/08/2018 - 02:29
yes.I inserted formula
Excelchat Expert
07/08/2018 - 02:30
Shall I download this excel and send it to you
User
07/08/2018 - 02:31
that would be great debdwyer@hsdmetrics.com or it appears I may be able to save.
Excelchat Expert
07/08/2018 - 02:31
FYI
[Uploaded an Excel file]
Excelchat Expert
07/08/2018 - 02:31
Its always available anyway you can download this sheet
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
