What you are posting is inconsistent.
If each of your 500 people make one choice, then there are 500 choices made.
That has to be the denominator. Unless your 500 people are making more than
one choice apiece.
Also, in your example, the first entry (under the 1) was a 10; the second
entry, under the 2, was a 4.
=10/500 is 0.02; not 0.113065327
=4/500 is 0.008; not 0.045226131
So there is clearly something inconsistent between what you've posted and what
you are getting for results.
If your frequency is in A2:Z2, then in A3 try the formula:
=A2/SUM$A$2:$Z$2) and copy/drag across
Unfortunately, when I use that formula, all I get in the A3 to Z3 cells are
numbers like [ 0.113065327 0.045226131 0.118090452 0.170854271
0.108040201 0.005025126 0.06281407 0.047738693 0.211055276 0.118090452
...].
Assuming, based on those numbers that I need to format the cells with a
PERCENT format, the numbers all add up wrong...I end up with numbers higher
than 100%.
Any other ideas?
Thanx.
Elkar said:
In cell A3 you could put the formula:
=A2/sum($A$2:$Z$2)
Then just copy A3 to all cells from B3 to Z3. The $ above will prevent
Excel from automatically incrementing those references as the formula is
copied over. And by using the SUM function rather than 500, you can get an
accurate percentage regardless of how many total results you have.
:
I have a row of numbers from 1 to 26 in cells A1 to Z1 representing numbers
'chosen' at random by 500 unique people.
I have another row of numbers representing the 'frequency' that the
aforementioned number was chosen in cells A2 to Z2.
Example:
1 2 3 4 5 6 7 8 9 10 11 ...
10 4 16 9 23 20 61 13 18 43 17 ...
Is there a formula that I could use to calculate the percentage (0%-100%)
that each number was chosen?
Thanx.
--ron