MrExcel Publishing
Your One Stop for Excel Tips & Solutions

standard error bars vs standard deviation


Posted by sean on May 05, 2001 1:32 PM

hi,

can anyone explain the difference between standard error bars and standard deviation bars? how do you calculate standard error?

thanks


Posted by Dave Hawley on May 06, 2001 2:39 AM

Hi sean

Perhaps the below will help ?

Error bars in charts

Error bars graphically express potential error amounts relative to each data marker in a data series. You can add error bars to data series in area, bar, column, line, xy (scatter), and bubble charts. For xy (scatter) and bubble charts, you can display error bars for the x values, the y values, or both.

http://www.tass-survey.org/tass/mailarchive/1998-09/msg00042.html

Dave

OzGrid Business Applications