Results 1 to 8 of 8
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Box and whiskers (2003)

    I would like to create a graph which plots grades 1 through 6 as x-axis. The y-axis plots salaries (as a scatter graph) of staff members of these grades. However, I additionally want to add a box which surrounds these from a minimum to maximum salary within each grade. That is, several "stars" appear vertically and most staff members salaries would fall within the box.. I believe this might be called a box and whiskers graph?! Any clues? Thanks, Andy.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Box and whiskers (2003)

    Check out Jon Peltier's Box-Whisker for some ideas

    Steve

  3. #3
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Box and whiskers (2003)

    Thanks. The Box and Whisker is perhaps not the one I want - that only seems to show one value between a maximum and minimum value. Any other thoughts? Andy.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Box and whiskers (2003)

    Does the attached do what you want? The yellow boxes show the interval from the average minus 1 standard deviation to the average plus 1 standard deviation for each grade. If the salaries are more or less normally distributed, about two thirds of the salaries should fall within the box. (If you use 2 standard deviations instead of 1, about 95% should fall within the box).
    The chart was created as an XY scatter chart based on the salary data, then the average-1SD and 2SD data were added, plotted on the secondary axis, and changed to a stacked column chart. The average-1SD series was made transparent. Finally, a bit of fiddling with the axes made everything fit together.
    Attached Files Attached Files

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Box and whiskers (2003)

    Hans,
    <img src=/S/whisper.gif border=0 alt=whisper width=29 height=17>I am not sure why you want to have separate Y-Axes for the 2 data sets since they should match up on the same scale. There is much less playing with the axes if you allow them to use the same Y axis

    Steve

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Box and whiskers (2003)

    You're correct - I thought I needed a secondary Y axis for the stacked column chart, but I only need a secondary X axis. Thanks!

    Modified example attached.
    Attached Files Attached Files

  7. #7
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Shetland Isles, Shetland, Scotland
    Posts
    154
    Thanks
    3
    Thanked 1 Time in 1 Post

    Re: Box and whiskers (2003)

    Don't know if this is any help at all but I built this graph from:
    x= job evaluation score
    y=current hourly rates
    blue box=future grade.
    I've attached a picture of the graph showing the output

    Jim
    Attached Files Attached Files

  8. #8
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Box and whiskers (2003)

    Thank you very much everyone for the solution. Andy.

Posting Permissions

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