2.13.1.21 statsxy


Brief Information

Statistics XY data using subgroup stats on X.

Command Line Usage

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;

Variables

Display
Name
Variable
Name
I/O
and
Type
Default
Value
Description
Input iy

Input

XYRange

<active>
This variable specifies the range of input data for which descriptive statistics will be calculated.
X Bin by bin

Input

int

0
Specify how to define the X bin range.
  • 0=size:Bin Size
  • 1=count:Number of Bins
  • 2=boundary:Custom Boundary
Start start

Input

double

0
Specify the start(minimum) of the X values of the dataset.
End end

Input

double

0
Specify the end(maximum) of the X values of the dataset.
Bin Size size

Input

double

2
When bin is set to 0, specifies the fixed step size for X bins.
Number of Bins count

Input

int

5
When bin is set to 1, specifies the number of X bins.
Boundary boundary

Input

Range

<unassigned>
When bin is set to 2, specifies a dataset to custom boundary of the bins.
Quantities quantities

Input

TreeNode

<unassigned>
Specifies which quantity to be computed and output.

See More Information section below for more details.

Output rd

Input

ReportData

<new>
Specifies the output worksheet.

More Information

Options Tree Details

  • Quantities Tree
Please refer to Details of TreeNodes in Statsxy for more information.

Related X-Functions

twodbinning , freqcounts