The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum for Programming
 LabTalk Forum
 How to obtain cumulative data of a column

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
praveen248 Posted - 05/24/2016 : 05:42:45 AM
Origin 2015:
Hi,
I'm having a column of data
how should i perform cumulative data and standardize functions as in excel
SUM(a$26:a26)

STANDARDIZE(x,mean,stddev)

could you please tell me the commands in labtalk for doing the same

Praveen
3   L A T E S T    R E P L I E S    (Newest First)
praveen248 Posted - 05/25/2016 : 03:18:26 AM
Thanks for the reply guys.. very helpful really

B.V.Praveen
Hideo Fujii Posted - 05/24/2016 : 5:11:15 PM
Hi Praveen,

In addition to the Snow's suggestions, if you simply want to convert all values in a column to their Z values,
you can use the rnormalize x-function (which corresponds to "Analysis: Math: Normalize Columns" menu) e.g.,
rnormalize irng:=Col(A) method:=snd orng:=<new>;
Hope this also helps.

--Hideo Fujii
OriginLab
snowli Posted - 05/24/2016 : 3:36:21 PM
Hello, we also have sum() function for this.

E.g. suppose you have col(A) filled with values.
In F(X) cell of column B, enter sum(col(A))

U will get cumulative values.


Excel's Standardize function calculates (x-mean)/sd
You can enter this (col(A)-col(B))/col(C) in F(X) cell of column D, suppose each row of your column A, B and C contains x value, mean and sd.

If mean and sd only shows in 1st cell of B and C, you can enter the following in F(X) cell of column D.
(col(A)-col(B)[1])/col(C)[1]


Thanks, Snow

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000