Hi,
I have 479 funds in a column. Next to each fund (a name) I have a precentage of how much they lost or gained over August. I want to plot a kind of bell curve or if possible. I was trying to group data between say -50 to -49, -49 to -48 and so until 49 to 50. And then plot how many funds were in each group.
I was attempting to use a pivot table but have failed terribly.
Any help would be much appreciated.
Once we (my frustrated colleague and I) have done this we want to get standard deviations.
Cheers!
I have 479 funds in a column. Next to each fund (a name) I have a precentage of how much they lost or gained over August. I want to plot a kind of bell curve or if possible. I was trying to group data between say -50 to -49, -49 to -48 and so until 49 to 50. And then plot how many funds were in each group.
I was attempting to use a pivot table but have failed terribly.
Any help would be much appreciated.
Once we (my frustrated colleague and I) have done this we want to get standard deviations.
Cheers!