
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

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 2931". Another can be "Ages 2931". Another can be "Female and 3235".
So first you have to decide what the bins are and then get a histogram of your distribution.

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!

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.

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

Re: Statistical Table
What bins have you decided to use?

Re: Statistical Table
i want to use interval of "6"
2227
2833
3439
4045
4651
thats for male or female

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.

Re: Statistical Table
2227  1 = 1 / 5 = 0.2 (how will i write this data, is it in percentage like 0.2% or its just 0.2?)
2833  1+1+1+1+1+1 = 6 / 5 = 1.2
3439  1+1 = 2 / 5 = 0.4
4045  1 = 1 / 5 = 0.2
4651  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.

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.