If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
creating chart with average and standard deviation ?
Could someone please refer me to a faq or an illustrative internet site
about creating charts, in which average and standard deviation of the data are displayed. The chart data are ratings for various persons, hence x-axis is not numerical. Thanks, Marcel |
#2
|
|||
|
|||
creating chart with average and standard deviation ?
Are you looking to chart a regression line?
No, I would like a line graph, where the average data are the points on the line and for each point a line for the standard deviation. Marcel |
#3
|
|||
|
|||
creating chart with average and standard deviation ?
On Fri, 17 Oct 2003 06:24:41 +0200, Marcel Verduyn =
wrote: Could someone please refer me to a faq or an illustrative internet sit= e about creating charts... http://pubs.logicalexpressions.com/P...e.asp?ID=3D209 ...in which average and standard deviation of the data are displayed. The chart data are ratings for various persons, hence = x-axis is not numerical. Thanks, Marcel Calculate the average and standard deviation numbers in the spreadsheet = (see STDEV and related functions if you need to calculate them). Chart = the average in a line chart using your favorite technique (i.e. the char= t = wizard). Select the plotted line by clicking on it, then go to the menu= = and click Format | Selected Data Series... | Y error bars tab. Select t= he = Custom boxes and enter the range that contains your standard deviations.= = Format the Y error bars as desired. -- = Dave dvt at psu dot edu |
Thread Tools | |
Display Modes | |
|
|