+ Reply to Thread
Results 1 to 4 of 4

how do I plot mean and standard deviation in excel

  1. #1
    amg
    Guest

    how do I plot mean and standard deviation in excel

    I want to take a data series and plot the mean and standard deviation on a
    bar graph. How do I do this in excel?

  2. #2
    Barb Reinhardt
    Guest

    Re: how do I plot mean and standard deviation in excel

    Do you want something akin to an X bar Schart? Or do you want a graph that
    shows X bar with maybe an Inner Quartile Range?

    "amg" <amg@discussions.microsoft.com> wrote in message
    news:4FA33F07-C472-4645-A4F8-E5E35986CAFA@microsoft.com...
    > I want to take a data series and plot the mean and standard deviation on a
    > bar graph. How do I do this in excel?




  3. #3
    John Mansfield
    Guest

    RE: how do I plot mean and standard deviation in excel

    This might describe one way to approach the creation of the chart:

    Assuming your data starts in cell A1, as an example create a simple
    clustered column chart based on the following data. The data range for this
    example should span A1:E8.

    Data Mean -1sd +1sd
    A 55 44.71 34.62 54.81
    B 34 44.71 34.62 54.81
    C 31 44.71 34.62 54.81
    D 48 44.71 34.62 54.81
    E 58 44.71 34.62 54.81
    F 46 44.71 34.62 54.81
    G 41 44.71 34.62 54.81

    The data in the column “Data� is your original source.

    The “Mean� is calculated using the formula

    =AVERAGE($B$2:$B$8)

    The “-sd� is calculated using the formula

    =$C2-STDEV($B$2:$B$8)

    The “+sd� is calculated using the formula

    =$C2+STDEV($B$2:$B$8)

    Put you curser in cell A1 and create a simple clustered column chart. After
    the chart is created, you should have four columns for each Y-axis tick mark
    label. Now, convert the “Mean�, “-1sd�, and “+1sd� series to lines. To
    convert each series to a line, click on one of the columns for the “Mean�.
    Right-click on your mouse -> Chart Type -> Line. Go through the same process
    for the “-1sd� and “+1sd� series. Now all you have to do is format the chart
    to your liking.

    ----
    Regards,
    John Mansfield
    http://www.pdbook.com



    "amg" wrote:

    > I want to take a data series and plot the mean and standard deviation on a
    > bar graph. How do I do this in excel?


  4. #4
    Jon Peltier
    Guest

    Re: how do I plot mean and standard deviation in excel

    I've just posted a sample on my web site:

    http://peltiertech.com/Excel/Charts/RunChtLines.html

    - Jon
    -------
    Jon Peltier, Microsoft Excel MVP
    Peltier Technical Services
    Tutorials and Custom Solutions
    http://PeltierTech.com/
    _______

    amg wrote:

    > I want to take a data series and plot the mean and standard deviation on a
    > bar graph. How do I do this in excel?



+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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