2.13.1.19 rowstats
Brief Information
Compute descriptive statistics on data rows
Command Line Usage
1. rowstats irng:=col(1)[1]:col(10)[1] mean:=mymean
2. rowstats irng:=col(1)[1]:col(5)[3] min:=Col(6) max:=Col(7)
X-Function Execution Options
Please refer to the page for additional option switches when accessing the x-function from script
Variables
Display
Name
|
Variable
Name
|
I/O
and
Type
|
Default
Value
|
Description
|
| Input
|
irng
|
Input
Range
|
<active>
|
The input data range.
|
| Mean
|
mean
|
Output
vector
|
<new>
|
The mean score of the input data.
|
| Standard Deviation
|
sd
|
Output
vector
|
<new>
|
The standard deviation of the input data.
|
| SE of Mean
|
sem
|
Output
vector
|
<optional>
|
The standard error of mean
|
| Minimum
|
min
|
Output
vector
|
<optional>
|
The minimum value of the input data.
|
| Maximum
|
max
|
Output
vector
|
<optional>
|
The maximum value of the input data
|
| Number of Points
|
n
|
Output
vector
|
<optional>
|
The number of non-missing values of the input data.
|
| Sum
|
sum
|
Output
vector
|
<optional>
|
The sum of the input data.
|
Description
This X Function can be used to describe the basic aspects of each row of data in a specific range, including the mean score, standard deviation, standard error of mean, minimum value, maximum value, sum and number of non-missing values.
Examples
1. To return the standard deviation of an active rows, use the script command:
rowstats sd:=mysd; mysd=
2. To open the dialog of rowstats, use the script command:
rowstats -d;
Algorithm
Let  denote the input values for each row, the computation equations can be expressed as follows
1. Sum:  </sub>
2. Mean: </sub>
3. Standard deviation:  </sub>
4. Standard error for mean: </sub>
References
Silverman, B.W. 1986. Density Estimation for Statistics and Data Analysis, New York: Chapman and Hall.
Tukey, J.W. 1977. Exploratory Data Analysis, Reading, MA: Addison-Wesley.
Erickson B H and Nosanchuk T A. 1985. Understanding Data. Open University Press.
Related X-Functions
rowquantiles, stats, moments, quantiles
Keywords:mean, median, standard deviation, sum
|