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]
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.,
How to obtain cumulative data of a column
Posted - 05/24/2016 : 05:42:45 AM
