| Author |
 Topic  |
|
|
bedibra
France
35 Posts |
 Posted - 08/23/2017 : 09:47:38 AM
|
Dear all,
I am looking for a way using the set values function to get get the mean of values in columns a to c in row 1.
I will really appreciate your help.
Thanks |
|
|
arstern
USA
237 Posts |
Posted - 08/23/2017 : 11:13:55 AM
|
Hi,
You can use the Statistics on Rows dialog.
Select Statistics --> Descriptive Statistics --> Statistics on Rows
Input tab --> Select all rows that you want to find the mean for.
Quantities tab --> select Mean.
Output tab --> Under Column tab
select Next to Source
This will add the Mean value for each row in the column next to your selected rows i.e. col(D).
Aviel
OriginLab |
 |
|
|
bedibra
France
35 Posts |
Posted - 08/23/2017 : 11:23:34 AM
|
Thanks for your fast response, I am aware of this possibility, but I want to do it with set values function if possible.
Thanks |
|
|
|
couturier
France
291 Posts |
Posted - 08/23/2017 : 2:34:43 PM
|
If all your columns have the same numbers of rows:
Col(D)=
(mean(col(A))+mean(col(B))+mean(col(C)))/3
In case your columns don't have the same numbers of rows:
Before Formula Script:
range r1=1, r2=2, r3=3;
dataset ds=r1; ///copy col(A) into temporary dataset
copy -a r2 ds; // append col(B)
copy -a r3 ds; // append col(C)
Col(D)=
mean(ds)
|
Edited by - couturier on 08/23/2017 2:36:18 PM |
|
|
|
bedibra
France
35 Posts |
Posted - 08/23/2017 : 6:00:23 PM
|
Thank you for your response, but I am trying to calculate the mean within the first row of col(A) to col(C).
quote:
Originally posted by couturier
If all your columns have the same numbers of rows:
Col(D)=
(mean(col(A))+mean(col(B))+mean(col(C)))/3
In case your columns don't have the same numbers of rows:
Before Formula Script:
range r1=1, r2=2, r3=3;
dataset ds=r1; ///copy col(A) into temporary dataset
copy -a r2 ds; // append col(B)
copy -a r3 ds; // append col(C)
Col(D)=
mean(ds)
|
|
|
|
arstern
USA
237 Posts |
|
|
bedibra
France
35 Posts |
Posted - 08/24/2017 : 6:39:11 PM
|
thank you for your response, this partially solved the problem .
BUT I don't understand why it is automatically creating the book2(as in picture) and I don't understand what are those values in this book2.
any help ?
quote:
Originally posted by arstern
Hi,
you can use rowstats x function
http://www.originlab.com/doc/X-Function/ref/rowstats
Aviel
OriginLab
 |
|
|
|
arstern
USA
237 Posts |
Posted - 08/28/2017 : 1:01:35 PM
|
Hi,
You can select the green lock to view the output. I believe the new worksheet is recording the standard deviation for each row. I am not exactly sure how to turn this off.
However, I found another way to to calculate row mean.
http://www.originlab.com/doc/LabTalk/ref/Sum-func
Aviel
OriginLab |
|
|
|
bedibra
France
35 Posts |
Posted - 08/28/2017 : 7:15:57 PM
|
finally this is doing the job well:
rowstats irng:=5! mean:=col(B) sd:=<none>;
thanks |
|
|
| |
Topic |
|
Get mean value of rows