# Thread: Statistical Table

1. ## Statistical Table

What will i do if the question is

'Make a statistical table reflecting the distribution of employees by age and by gender'

is that Mean, Median, Mode? or just a simple Frequency Distribution table..

example data..

 Employee Gender Age 1 Male 29 2 Female 38 3 Female 24 4 Female 41 5 Female 31 6 Male 49 7 Male 28 8 Female 38 9 Male 30 10 Female 29 11 Male 31

Please teach me how you do it... or the steps.

Thank you!

2. ## Re: Statistical Table

Hey jayramir.

You need to decide what "bins" you will use for the distribution.

For example one bin may be "Male and Ages 29-31". Another can be "Ages 29-31". Another can be "Female and 32-35".

So first you have to decide what the bins are and then get a histogram of your distribution.

3. ## Re: Statistical Table

Thanks!

well, basically can we make 3 tables from this data? 1st "male and female to age distribution", 2nd "male to age distribution", 3rd "female to age distribution"? am i correct?

hmm... can we use "29 - 38"
"39 - 48"
"49" if it is applicable....

so basically "bins" are subjectively assigned by me? or are there any computation to get that?

thanks alot!

4. ## Re: Statistical Table

Yes the bins are defined by you and you do it in a way that best suits the data you have and the application of the data that you have in mind.

These things are determined by you and it will also be important for you to consider how you will use the data and what kinds of questions you are trying to answer with it.

5. ## Re: Statistical Table

so can we compute it now? will you show me how? all data and parameters are ready.. thanks!

6. ## Re: Statistical Table

What bins have you decided to use?

7. ## Re: Statistical Table

i want to use interval of "6"

22-27
28-33
34-39
40-45
46-51

thats for male or female

8. ## Re: Statistical Table

What you do is count the number of times something goes into each bin (also known as the frequency) and then write these down somewhere.

Then to get the distribution divide all these numbers by the total number of observations and that will give you the probability distribution of your sample.

9. ## Re: Statistical Table

22-27 - 1 = 1 / 5 = 0.2 (how will i write this data, is it in percentage like 0.2% or its just 0.2?)
28-33 - 1+1+1+1+1+1 = 6 / 5 = 1.2
34-39 - 1+1 = 2 / 5 = 0.4
40-45 - 1 = 1 / 5 = 0.2
46-51 - 1 = 1 /5 = 0.2
Total = 11 Total = 2.0 (is this correct)

hey thanks by the way for stopping by to this thread and make some suggestions.

10. ## Re: Statistical Table

You need to divide your bin totals by the number of total elements and not the size of the bin.

So divide by 11 instead of 5 and you will have a probability distribution with those bins you selected.