I'm pretty proficient with excel but I need help on something. I have to do an X-Y plot. I'm plotting averages of certain multiple trials, but I also have to calculate the standard deviation and the standard error of the individual trials and apply error bars to the graphs. Does anyone know a quick way to do this in excel? Or any tips other than doin this manually?
2006-10-21 11:56:40 · 3 answers · asked by Hard Rocker 3 in Science & Mathematics ➔ Mathematics
In excel go to help and type standard deviation. There are two functions that you can use, stdev or stdeva. One is for use with a sample, and one is used for use with a complete set.
2006-10-21 12:42:27 · answer #1 · answered by sparrowhawk 4 · 0⤊ 0⤋
The easiest way is probably to use a column for standard deviation and another column for standard error. Use the forlmulas to calculate the first one in each column and then copy to the next columns. Go to the website below for discussion and Excel Spreadsheet example.
2006-10-21 12:14:22 · answer #2 · answered by The Answer Man 5 · 0⤊ 0⤋
there's a fashion. once you maintain the Excel report on place of work 2007, in case you prefer place of work 2003 to study it you may desire to maintain it as a .xls report. to try this you pass to report>save As and choose Excel ninety seven-2003 Workbook. wish this helped.
2016-11-24 21:41:25 · answer #3 · answered by ? 4 · 0⤊ 0⤋