Hello, maybe it's not brand new, but I don't know how to calculate a percentage.
I have these absolute events observed
a - 28
b - 8
c - 3
d - 4
e - 3
f - 6
g - 5
h - 3
i - 7
And I want to know the percentage on the total (67), How do I proceed? I tried Frequencies Tables, but it's not what I am looking for.
a - 28 (28/67*100=41.8%) and so on
b - 8
c - 3
d - 4
e - 3
f - 6
g - 5
h - 3
i - 7
Percentages?
Re: Percentages?
I did it via the transform function: $source/VSUM(A)*100
$source = column A (which contains all your values on separate rows)
VSUM(A)= sum of variable A
$source = column A (which contains all your values on separate rows)
VSUM(A)= sum of variable A
Re: Percentages?
Thanks it's working!
Do u know how can I round to the first decimal? 41.8% and so on?
I used ROUND ('Column of variable I need', digits=1) but I got an error: DIGITS is not an argument for ROUND ()
If I use only ROUND ('Column of variable I need') it works
Do u know how can I round to the first decimal? 41.8% and so on?
I used ROUND ('Column of variable I need', digits=1) but I got an error: DIGITS is not an argument for ROUND ()
If I use only ROUND ('Column of variable I need') it works
Re: Percentages?
I just tried this and it seems to work:
ROUND(($source/VSUM(A)*100), 1)
ROUND(($source/VSUM(A)*100), 1)