Thank you for the example. I know what you need now. I am afraid that Origin does not have such feature yet. But you can get used to our set column value tool and save the worksheet as analysis template for future use.
Let me take two sample t-test as an example.
Assumed that we have a worksheet where mean 1 is in the first column, sd1 is in the 2nd column, n1 in the 3rd column, mean2 is in the 4th column ,sd2 is in the 5th column and n2 in the 6th column, then you can
1. Hightlight the 7th column, right click and select Set Column Value from the context menu
2. In the Set Column values dialog, copy/paste the script blow in the Before Formula Script box of the dialog
range x1 = wcol(1);
range sd1 = wcol(2);
range n1 = wcol(3);
range x2 = wcol(4);
range sd2 = wcol(5);
range n2 = wcol(6);
double sp = sqrt(((n1-1)*sd1^2 + (n2 - 1)*sd2^2)/(n1+n2-2));
tvalue = (x1 - x2)/(sp*sqrt(1/n1+1/n2));
Enter "tvalue" in the upper panel of the dialog as the image blow
You can enter other mean, sd and n of two groups in the other rows of column 1 ~ column 6 then corresponding t value will be calculated automatically in the 7th column.
But if for anova, the algorithm requires you to calculate the sum of squares from the sample so you can not simply get the result from the known mean and sd of the samples.
Query regarding use of statistical analysis
Posted - 01/07/2014 : 07:03:48 AM
