Thread: 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!

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.

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!

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.

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

What bins have you decided to use?

i want to use interval of "6"

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

thats for male or female

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.

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.

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.