+ Reply to Thread
Results 1 to 19 of 19

How to plot frequency distribution graph with 2 distribution plots

  1. #1
    Registered User
    Join Date
    08-16-2017
    Location
    new york
    MS-Off Ver
    2010
    Posts
    9

    How to plot frequency distribution graph with 2 distribution plots

    Hello, I am making a distribution frequency graph (histogram) but i need to have 2 distribution plots (One for males and one for females). I am able to get Male and Females together charted but I've tried for hours and I am unable to separate Males and Females on the graph. Below is a sample of data i have to work with, I appreciate all replies. Thanks

    Distance between the two points (cm)
    M/F LEG
    M 3.27
    F 3.61
    F 2.87
    F 3.08
    M 2.72
    M 3.79
    F 3.61
    F 2.01
    M 2.49
    F 1.92
    F 1.22
    M 1.35
    F 5.13
    F 3.43
    F 3.01
    F 2
    F 2.64
    M 2.35
    F 2.43
    F 2.96
    M 1.57
    M 4.4
    F 4
    F 2.79
    F 2.71
    F 2.75
    f 3.73
    f 4.67
    m 4.32
    M 2.17
    F 2.29
    F 2.81
    M 5.46
    F 3.06
    F 5.71
    F 1.97
    F 2.58
    M 2.49
    F 17.84
    F 17.99
    F 13.03
    M 3.75
    F 3.1
    M 2.44
    f 3.8
    f 2.86
    m 2.68
    F 1.4
    F 2.43
    M 2.19
    F 2.68
    F 2.68
    M 4.93
    F 2.27
    F 1.79
    F 2.26
    F 3
    M 3.15
    M 3
    F 1.52
    F 2.37
    F 2.83
    F 3.34
    F 2.4
    M 2.48
    F 1.96
    F 3.01
    F 1.87
    F 1.57
    M 2.05
    F 3.41
    F 3.04
    F 3.15
    F 2.23
    F 2.01
    M 2.14
    M 3.84
    F 4.85
    F 4.62
    M 1.42
    F 1.42
    F 1.26
    M 2.71
    M 1.8
    F 1.79
    F 2.86
    F 1.78
    M 2.47
    M 3.55
    M 3.38
    F 2.71
    M 1.20
    F 1.67
    M 3.15
    M 2.86
    F 3.03
    F 3.21
    F 2.29
    M 3.15
    F 2.74
    f 3.14
    F 3.19
    M 3.32
    F 2.24
    F 2.41
    F 2.09
    F 2.60
    F 2.30
    M 2.35
    F 2.84
    F 2.76
    M 2.90
    F 2.50
    F 2.98
    M 2.00
    F 2.56
    F 2.56
    M 2.56
    F 2.00
    F 2.00
    M 2.00
    M 4.47
    f 2.45
    f 2.45
    m 2.83
    M 3.10
    F 1.50
    F 1.60
    M 2.05
    F 2.04
    M 1.84
    F 3.81
    F 2.41
    M 3.81
    F 3.15
    M 4.66
    F 3.67
    F 3.00
    F 4.00
    F 5.00
    M 5.82
    F 5.28
    F 6.12
    F 2.00
    M 4.71
    M 6.59
    F 3.57
    f 2.00
    f 5.98
    M 0.23
    F 1.15
    F 1.37
    f 3.51
    f 2.30
    f 2.22
    f 1.84
    f 2.24
    f 2.15
    F 2.62
    F 2.14
    F 2.82
    M 2.30
    F 2.50
    M 2.50
    F 2.62
    M 2.54
    F 2.41
    F 1.89
    F 1.53
    M 3.25
    F 10.56
    M 9.93
    F 4.00
    f 3.00
    m 2.38
    f 2.84

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: How to plot frequency distribution graph with 2 distribution plots

    something like this?
    pareto.jpg

  3. #3
    Registered User
    Join Date
    08-16-2017
    Location
    new york
    MS-Off Ver
    2010
    Posts
    9

    Re: How to plot frequency distribution graph with 2 distribution plots

    Thank you for reply, no i mean a frequency distribution graph similar to the one in this video only I would like separate bars for Male and Female. I can only get one bar for all results.

    https://www.youtube.com/watch?v=UASCe-3Y1to

  4. #4
    Registered User
    Join Date
    08-16-2017
    Location
    new york
    MS-Off Ver
    2010
    Posts
    9

    Re: How to plot frequency distribution graph with 2 distribution plots

    So my graph would be similar to this graph in the video only there would be bars for Males and bars for Females. The two bars would be different color to differentiate between them
    https://www.youtube.com/watch?v=UASCe-3Y1to

  5. #5
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: How to plot frequency distribution graph with 2 distribution plots

    have you bin defined ?

  6. #6
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: How to plot frequency distribution graph with 2 distribution plots

    maybe like this one?
    frq.jpg

  7. #7
    Registered User
    Join Date
    08-16-2017
    Location
    new york
    MS-Off Ver
    2010
    Posts
    9

    Re: How to plot frequency distribution graph with 2 distribution plots

    OMG yes that is it, how did you separate the Males and Females? I just get Males and females combined

  8. #8
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: How to plot frequency distribution graph with 2 distribution plots

    could you answer for my Q ? have you bin defined?

  9. #9
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: How to plot frequency distribution graph with 2 distribution plots

    ok, doesn't matter
    here is and define your own bin
    Attached Files Attached Files

  10. #10
    Registered User
    Join Date
    08-16-2017
    Location
    new york
    MS-Off Ver
    2010
    Posts
    9

    Re: How to plot frequency distribution graph with 2 distribution plots

    oh sorry yeah I have used bins, i'm not sure what bin defined is?

  11. #11
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: How to plot frequency distribution graph with 2 distribution plots

    watch your linked video
    see post #9

    Bin numbers - These numbers represent the intervals that you want the Histogram tool to use for measuring the input data in the data analysis.

    Because your LEG is between 0-17.99 I assumed interval 0.8


    If that takes care of your original question, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you) then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED. Thanks.
    Last edited by sandy666; 08-16-2017 at 08:13 AM.

  12. #12
    Registered User
    Join Date
    08-16-2017
    Location
    new york
    MS-Off Ver
    2010
    Posts
    9

    Re: How to plot frequency distribution graph with 2 distribution plots

    Thank you, this is how my graph turns out but still no differentiation between males and females. I was wondering how i can have a bar for males and a bar for females like the graph you posted? Snapchat-1113756572.jpg

  13. #13
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: How to plot frequency distribution graph with 2 distribution plots

    This uses a pivot table to create the bins.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  14. #14
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: How to plot frequency distribution graph with 2 distribution plots

    do you want fast&easy way or complicated way ?

  15. #15
    Registered User
    Join Date
    08-16-2017
    Location
    new york
    MS-Off Ver
    2010
    Posts
    9

    Re: How to plot frequency distribution graph with 2 distribution plots

    ah yes Andy thats exactly what i need to do, how do you do that as unfortunately i have 5 or 6 different graphs to make?

    Sandy666 the fast and easy way if there is one? this is the graph i am only able to get up (sorry last image wasn't the graph) Snapchat-181729772.jpg

  16. #16
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: How to plot frequency distribution graph with 2 distribution plots

    create 5 or 6 pivot table/charts.

    once you have put the LEG field in to the Row field you can right click and select Group.

  17. #17
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: How to plot frequency distribution graph with 2 distribution plots

    on keyboard you've PrintScreen key (PrtSc or whatever) so use it instead of camera

  18. #18
    Registered User
    Join Date
    08-16-2017
    Location
    new york
    MS-Off Ver
    2010
    Posts
    9

    Re: How to plot frequency distribution graph with 2 distribution plots

    guys i got it, thank you for your help

  19. #19
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: How to plot frequency distribution graph with 2 distribution plots

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Frequency Distribution Example Question
    By zanshin777 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-27-2015, 04:22 PM
  2. Frequency Distribution Graph
    By kavin in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-26-2013, 01:31 PM
  3. Frequency distribution plot
    By mmmd_yaseen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-07-2010, 07:35 AM
  4. Frequency distribution and histogram
    By case in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-22-2010, 08:42 PM
  5. Graph help (frequency distribution)
    By burnsie in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-14-2009, 06:00 AM
  6. How to graph a Relative frequency distribution???
    By globulous in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-29-2007, 05:25 AM
  7. [SOLVED] Frequency distribution
    By Ms MIS in forum Excel General
    Replies: 1
    Last Post: 04-06-2005, 01:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1