Results 1 to 1 of 1

Horizontal boxplots - Issues with mean values

This is a discussion on Horizontal boxplots - Issues with mean values within the Excel Questions forums, part of the Question Forums category; Hello all, I am trying to create a horizontal boxplot for 15 different categories. I am pretty much done with ...

  1. #1
    New Member
    Join Date
    May 2013
    Posts
    4

    Default Horizontal boxplots - Issues with mean values

    Hello all,


    I am trying to create a horizontal boxplot for 15 different categories. I am pretty much done with creating the 5th, 25th, 50th, 75th, and the 95th percentiles. I tried to introduce the mean values onto the boxplot as mentioned in the peltiertech boxplot website (Excel Box and Whisker Diagrams (Box Plots) - Peltier Tech Blog). However, for some wierd reason my mean values are not exactly aligning with their respective boxplots. I do not understand the exact reason for this although I am suspecting that it could be due to the offset value specification. Below, I have provided the mean values along with the offset values. Also, I am providing a link to the the chart below. Can anyone kindly suggest me the best offset values (or another suggestion if this is not the cause for this misalgnment)




    Mean 22 17 16 13 17 19 20 16 17 16 16 18 17 18 17
    Offset 0.5 1.5 2.5 3.5 4.5 5.5 6.5 7.5 8.5 9.5 10.5 11.5 12.5 13.5 14.5


    http://postimg.org/image/5ormgktw1/a8a51276/
    Last edited by hornofgondor; Oct 10th, 2013 at 11:46 PM. Reason: Add image

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com