Results 1 to 10 of 10

Math Help - Statistical Table

  1. #1
    Newbie
    Joined
    Jan 2013
    From
    Philippines
    Posts
    10

    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!
    Follow Math Help Forum on Facebook and Google+

  2. #2
    MHF Contributor
    Joined
    Sep 2012
    From
    Australia
    Posts
    3,668
    Thanks
    609

    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.
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Newbie
    Joined
    Jan 2013
    From
    Philippines
    Posts
    10

    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!
    Follow Math Help Forum on Facebook and Google+

  4. #4
    MHF Contributor
    Joined
    Sep 2012
    From
    Australia
    Posts
    3,668
    Thanks
    609

    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.
    Follow Math Help Forum on Facebook and Google+

  5. #5
    Newbie
    Joined
    Jan 2013
    From
    Philippines
    Posts
    10

    Re: Statistical Table

    so can we compute it now? will you show me how? all data and parameters are ready.. thanks!
    Follow Math Help Forum on Facebook and Google+

  6. #6
    MHF Contributor
    Joined
    Sep 2012
    From
    Australia
    Posts
    3,668
    Thanks
    609

    Re: Statistical Table

    What bins have you decided to use?
    Follow Math Help Forum on Facebook and Google+

  7. #7
    Newbie
    Joined
    Jan 2013
    From
    Philippines
    Posts
    10

    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
    Follow Math Help Forum on Facebook and Google+

  8. #8
    MHF Contributor
    Joined
    Sep 2012
    From
    Australia
    Posts
    3,668
    Thanks
    609

    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.
    Follow Math Help Forum on Facebook and Google+

  9. #9
    Newbie
    Joined
    Jan 2013
    From
    Philippines
    Posts
    10

    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.
    Follow Math Help Forum on Facebook and Google+

  10. #10
    MHF Contributor
    Joined
    Sep 2012
    From
    Australia
    Posts
    3,668
    Thanks
    609

    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.
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. statistical tests
    Posted in the Advanced Statistics Forum
    Replies: 1
    Last Post: December 20th 2012, 05:39 AM
  2. a statistical proof
    Posted in the Differential Geometry Forum
    Replies: 0
    Last Post: October 11th 2010, 12:24 PM
  3. Statistical Modelling
    Posted in the Advanced Statistics Forum
    Replies: 1
    Last Post: May 1st 2010, 08:59 AM
  4. does any know where can i get new cambridge statistical table
    Posted in the Advanced Statistics Forum
    Replies: 4
    Last Post: August 28th 2008, 09:37 PM
  5. table salt + table sugar
    Posted in the Math Topics Forum
    Replies: 2
    Last Post: September 9th 2007, 08:35 AM

Search Tags


/mathhelpforum @mathhelpforum