Hello!
I'm hoping that someone here knows of a way to evenly spread these values into 10 groups of approximately 10% each.
Each letter must appear after the other in the order of the alphabet, and can not be divided between groups.
I am able to do this manually but would be very grateful if someone were able to inform me (or attach an example) on how to do this
using excel, as this could be useful with larger sets of data. My excel skills are sadly basic.
I have attached an excel sheet with what I am attempting to accomplish.
Kind Regards,
TildesleyH
a 3.75%
b 8.96%
c 6.38%
d 5.65%
e 2.03%
f 3.63%
g 5.34%
h 5.59%
i 0.76%
j 1.36%
k 5.70%
l 5.24%
m 8.28%
n 2.13%
o 1.63%
p 5.27%
q 0.26%
r 4.80%
s 10.93%
t 3.88%
u 0.47%
v 2.55%
w 3.46%
x 0.02%
y 0.65%
z 1.29%
Bookmarks