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.

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

Re: percentage and cumulative percentage distribution on excel?

i figured it out, thanks anyways =)