Hi,
I would like to create a box and whisker plot in Excel that displays the mean, the standard error of the mean as the boxes and the standard deviation as the whiskers. When I try to do it myself I can only manage to create a box and whisker plot with the interquartile range as the boxes and the minimum/maximum values as the whiskers. I've tried to search for solutions for a couple of hours, but to no avail. It would mean a lot if anyone here could help me out!
Here's a picture of what I want it to look like: Box-Whisker-plot-Mean-value-standard-deviation-and-standard-error-of-the-results-in-the_Q320.jpg
I'll also post my spreadsheet with the "faulty" box and whisker plot.
Thanks in advance!
Lymoz
Bookmarks