# Statistical Table

• Jan 19th 2013, 07:10 AM
jayramir
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! :D
• Jan 19th 2013, 02:41 PM
chiro
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.
• Jan 20th 2013, 08:34 AM
jayramir
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!
• Jan 20th 2013, 03:21 PM
chiro
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.
• Jan 20th 2013, 08:09 PM
jayramir
Re: Statistical Table
so can we compute it now? will you show me how? all data and parameters are ready.. thanks!
• Jan 21st 2013, 12:39 AM
chiro
Re: Statistical Table
What bins have you decided to use?
• Jan 21st 2013, 06:46 AM
jayramir
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
• Jan 21st 2013, 01:31 PM
chiro
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.
• Jan 21st 2013, 05:21 PM
jayramir
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.
• Jan 25th 2013, 02:56 AM
chiro
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.