| Author |
 Topic  |
|
|
teecross
Germany
3 Posts |
 Posted - 11/22/2020 : 05:39:34 AM
|
Hello everyone,
I have a question regarding the standard deviation. I want to create the StandardDeviation of multiple colums so that I have a StdDev for each row of my matrix.
How would that work?
StdDev(col(A), col(B)) doesnt work and I dont know which command I have to use for it. Is it StdDev(row(1)) or something?
If thats not possible, is there any way to import the Standard Deviations from Excel and let the error bars show? Everytime I enable error bars it uses a weird formula which I wouldnt need.
Id appreciate any advice! |
Edited by - teecross on 11/23/2020 01:13:14 AM |
|
|
Echo_Chu
China
Posts |
Posted - 11/23/2020 : 04:33:49 AM
|
Hi,
I would suggest you use Statistics on Rows tool to generate the SD of rows. You can access the tool from menu "Statistics: Descriptive Statistics: Statistics on Rows"
Anyway, sure you can also import the standard deviation from Excel. That should be numeric values in Excel, right? They should be able to be imported as other numeric values. Then you can set the column to be Y Error so that the values can be plotted as error bar.
Echo
OriginLab Technical Service |
 |
|
|
teecross
Germany
3 Posts |
Posted - 11/23/2020 : 04:56:48 AM
|
Hey,
thank you very much for the informative reply!
The Row Statistic works and importing the numeric value from excel works also (even though the StdDev does differ a little bit).
Now when I imported the numeric value, edit the column to Y Error and want to include it in my diagram it gets drawn as a line but not as Error Bars. How can I change that? I dont find the option. |
|
|
|
snowli
USA
1412 Posts |
Posted - 11/23/2020 : 09:31:07 AM
|
See this FAQ
https://www.originlab.com/doc/Quick-Help/errbar-display-in-plot
Columns in Origin have plot designations such as X, Y, see column header e.g. A(X), B(Y), C(Y), etc. Y columns will be plotted against X column.
If u want a column as YError, in recent new versions, u can left click column header, and click, Y Error symbol on mini toobar to set it as Y Error column first.
If you have X, Y, YErr columns, select Y and YError columns to plot, the YErr column will be plotted as Error bars.
In older versions, u can right click the column and choose Set as: Y Error context menu to set the column first.
Thanks, Snow |
|
|
|
teecross
Germany
3 Posts |
Posted - 11/23/2020 : 4:35:02 PM
|
Thank you!
This was so helpful and I was able to complete my task :) |
|
|
| |
Topic |
|
|
|
Standard Deviation OriginPro2019