Statistics XY data using subgroup stats on X.
statsxy -r 2 iy:=[Book1]Sheet1!(A,B) bin:=count start:=1 end:=10 quantities.bincenter:=0 quantities.sd:=1 quantities.max:=1 quantities.count:=1;
statsxy -r 2 iy:=[Book1]Sheet1!(A,B) bin:=boundary boundary:=[Book1]Sheet2!1 quantities.posminy:=1 quantities.posmaxy:=1;
Display Name |
Variable Name |
I/O and Type |
Default Value |
Description |
---|---|---|---|---|
Input | iy |
Input XYRange |
|
This variable specifies the range of input data for which descriptive statistics will be calculated. |
X Bin by | bin |
Input int |
|
Specify how to define the X bin range.
|
Start | start |
Input double |
|
Specify the start(minimum) of the X values of the dataset. |
End | end |
Input double |
|
Specify the end(maximum) of the X values of the dataset. |
Bin Size | size |
Input double |
|
When bin is set to 0, specifies the fixed step size for X bins. |
Number of Bins | count |
Input int |
|
When bin is set to 1, specifies the number of X bins. |
Boundary | boundary |
Input Range |
|
When bin is set to 2, specifies a dataset to custom boundary of the bins. |
Quantities | quantities |
Input TreeNode |
|
Specifies which quantity to be computed and output.
See More Information section below for more details. |
Output | rd |
Input ReportData |
|
Specifies the output worksheet. |
Options Tree Details