distribute the collaborators in 3 groups
 

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

distribute the collaborators in 3 groups
 

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?

--
Thanks,
Shane Devenshire


"Alexandra Lopes" wrote:

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

distribute the collaborators in 3 groups
 

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 wrote:
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?

distribute the collaborators in 3 groups
 

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/
--
Thanks,
Shane Devenshire


"Alexandra Lopes" wrote:

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 wrote:
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?

distribute the collaborators in 3 groups
 

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


ShaneDevenshire wrote:
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/

distribute the collaborators in 3 groups
 

Hi,

can you send me a sample, please?

Thanks in advance!

Alexandra

Alexandra Lopes wrote:
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


ShaneDevenshire wrote:
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/