Skip navigation

Standard error of mean for column/bar graphs

409 Views 2 Replies Latest reply: Mar 21, 2013 10:20 AM by Jerrold Green1 RSS
Valliance Calculating status...
Currently Being Moderated
Mar 21, 2013 6:20 AM

Hi,

 

Is it possible for me to have different standard errors in a column graph? (i.e. in a graph with 2 or more columns/bar to have their individual error bars drawn out?) So far I have only been able to have a single number for both columns in the graph.

 

V

  • Wayne Contello Level 6 Level 6 (12,580 points)
    Currently Being Moderated
    Mar 21, 2013 9:59 AM (in response to Valliance)

    You can superimpose multiple charts... one with the error bard set with one value, then another chart  with error bars set to another

  • Jerrold Green1 Level 7 Level 7 (28,135 points)
    Currently Being Moderated
    Mar 21, 2013 10:20 AM (in response to Valliance)

    V,

     

    Numbers does the best it can with the information you give it. If you ask for Error Bars, Numbers will calculate the standard deviation for the series and assign that calculation result to each of the bars in the series.

     

    If each of your values represents some statistic that in itself is accompanied by a standard error, that's another thing, but Numbers doesn't know what the error values are unless you tell it. The way to tell Numbers what the error bar values should be in these special cases is to use Custom values.

     

    Here's an example:

    Screen Shot 2013-03-21 at 1.16.00 pm.png

    I like to use the Scatter Chart, but you will find similar controls for the bar chart.

     

    Jerry

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.