# Math Help - percentage and cumulative percentage distribution on excel?

1. ## percentage and cumulative percentage distribution on excel?

does anyone know how to construct percentage and cumulative percentage distribution for the variable of age on Excel?
also, i have been given 3 data set.
1. males
2. females
3. total

what is the most appropriate data to construct the percentage and cumulative percentage distribution for? Total age?

any ideas?
Thanks.

2. ## Re: percentage and cumulative percentage distribution on excel?

Do you have the numbers for your data set?

Is it like this?

X Frequency Relative Freq Cumulative Freq
M 2 2/5 2/5 = 40%
F 3 3/5 (2+3)/5 = 100%
T 5 5/5

Or you could just try this? Google

3. ## Re: percentage and cumulative percentage distribution on excel?

i figured it out, thanks anyways =)