distribute the collaborators in 3 groups

[Alexandra Lopes]

Good afternoon,

I have a list of collaborators with one score associated to each one. I
intend to distribute the collaborators in 3 groups: the good one, the
medium and the bad one, using a normal distribution. How I can make
appealing it to excel?

Thanks in advance!

Alexandra Lopes

 

[ShaneDevenshire]

Hi,

What do you mean "distribute" - what do you want to do - a chart, and what
do you want to show - place of each within the total collection?

Are you making a presentation, giving a talk, sending out report cards,
sending out pink slips, having a meeting of senior staff to decide who stays
and who goes, or presenting to all the staff to encourage better performance?

 

[Alexandra Lopes]

Hi,

I want to group the collaborators in 3 groups (Good, average and bad),
in accordance with its score and to represent them graphically, in
charts. And also show the place of each within the score in one column.
I'm having a meeting of senior staff to decide who stays and who goes.


Thanks in advance.

 

[ShaneDevenshire]

Hi,

If you want to do charts there are many possiblities -
- You could plot a radar chart but this might be confusing to the audience,
I can send you a sample if you want.
- You can plot an XY-Scatter or Line chart showing Mean and +/- 1 or more
Standard Deviations - I can send you a sample.

If you just want to show data, then you can present the scores and mean and
+/- 1 or more standard deviations. You can also present the Percentile or
PercentRank for each score.

The functions to consider would be =AVERAGE(range), =STDEVP(range),
=PERCENTRANK(range,k), PERCENTILE(range,k)
Remember Standard Deviation is statistically meaningful when you reach a
population size of about 30.

As for charts, you might look at Jon Poltier's web site to see a lot of
samples and see if any strike your fancy.

http://peltiertech.com/Excel/Charts/

 

[Alexandra Lopes]

Hello,

I was thankful that you sent me the sample.

Thank you for the explanation and for the web site, it's very interesting.

Tanks in advance,

Alexandra

 

[Alexandra Lopes]

Hi,

can you send me a sample, please?

Thanks in advance!

Alexandra