Results 1 to 3 of 3

How to create a box and whisker plot with SD and SEM

Threaded View

  1. #1
    Registered User
    Join Date
    03-11-2019
    Location
    Sweden
    MS-Off Ver
    Office 365
    Posts
    12

    How to create a box and whisker plot with SD and SEM

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Box and Whisker Plot - highlight a point
    By rcal43 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 12-16-2019, 05:01 PM
  2. box and whisker plot x axis
    By DominikaM in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-25-2017, 08:52 PM
  3. Box and Whisker Plot
    By marshymell0 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-08-2013, 10:32 PM
  4. Excel 2007 : Error in making a box-and-whisker plot
    By flyingcurry in forum Excel General
    Replies: 3
    Last Post: 12-01-2011, 08:49 AM
  5. box whisker plot
    By flyingmeatball in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-09-2007, 11:11 AM
  6. how do I create a box-plot (or whisker plot ) graph?
    By raal in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-08-2005, 04:05 PM
  7. [SOLVED] How do I draw a Box and Whisker Plot in Excel?
    By angela268 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-24-2005, 04:06 PM

Tags for this Thread

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