Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
y error bars
0 views
Skip to first unread message
Peggy
Jan 10, 2005, 5:42:03 PM1/10/05
to
I have graphed some data where each data point is the
average of 5 replicates. I did the statistics in a program
other than Excel. In my Excel graph, under 'Format Data
Series' I have never understood how to add y error bars.
It seems to me the data set that generated the graph
doesn't have enough information to do this. It doesn't
know the value of each of the five replicates, just the
average.
What am I missing?
average of 5 replicates. I did the statistics in a program
other than Excel. In my Excel graph, under 'Format Data
Series' I have never understood how to add y error bars.
It seems to me the data set that generated the graph
doesn't have enough information to do this. It doesn't
know the value of each of the five replicates, just the
average.
What am I missing?
Michael R Middleton
Jan 10, 2005, 7:43:32 PM1/10/05
to
Jon Peltier
Jan 10, 2005, 11:38:57 PM1/10/05
to
Peggy -
When Brand X computes the average, it could also compute the standard deviation.
These could be placed in an adjacent worksheet range, and used as the custom +/-
error bar values. For more detailed instruction, look here:
http://peltiertech.com/Excel/ChartsHowTo/ErrorBars.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Peggy
Jan 11, 2005, 12:46:35 AM1/11/05
to
Thank you. I have printed out the info you suggested and am
in the process of studying it. I might have to get back to
you later.
in the process of studying it. I might have to get back to
you later.
>.
>
Jon Peltier
Jan 11, 2005, 9:41:13 PM1/11/05
to
I'm always open, he he.
0 new messages