17.1.8.1 The 2D Binning Dialog Box

See more related video:2D Binning

1 Supporting Information
2 Recalculate
3 Input
4 X
5 Y
6 Quantity to Compute
7 Column to Compute Quantity
8 Base Column
9 Bin Output
10 Output Worksheet
11 Subtotal Count for Each Binned Y
12 Output Matrix
13 Matrix Plots

Supporting Information

Recalculate

Recalculate

Controls recalculation of analysis results

None
Auto
Manual

For more information, see: Recalculating Analysis Results

Input

For help with range controls, see: Specifying Your Input Data

Range1	X Specify the data range for the X values. Y Specify the data range for the Y values. Rows Choose the row ranges on which the 2D Frequency Counts/Binning is performed. From The row to begin 2D Frequency Counts/Binning. To The row to end 2D Frequency Counts/Binning.

X

Use this branch to specify the X binning range. The minimum and maximum X values are displayed to the right of the node.

Specify Binning Range by	Specify the way to define the X binning range. Bin Centers X binning range is indicated by bin centers. Bin Ends X binning range is indicated by bin ends.
Minimum Bin Beginning	Specify the minimum X bin starting value.
Maximum Bin End	Specify the maximum X bin ending value.
Step by	Specify bin construction, including Bin Size and Number of Bins.
Bin Size	Specify the fixed step size for X bins.
Number of Bins	Generated automatically by the bin range and increment.
Periodical	Specify whether or not the data is periodic.
Period	Specify a period for the data. Control available when Periodical is checked.
Border Options	Include Outliers Add outliers to lowest and highest bins. Only available when Periodical is selected. Include Outliers < Minimum Include outliers that are less than bin minimum of the lowest bin. Available when Periodical is cleared. Include Outliers >= Maximum Include outliers that are greater than or equal to the bin maximum of the highest bin. Available when Periodical is cleared. Separately Count Minimum Bin the minimum value separately. Separately Count Maximum Bin the maximum value separately.
Output Binning Order	Specify the sort order of the bin data output. Ascending Output bin data in ascending order. Descending Output bin data in descending order.

Y

Settings for Y binning range.

Specify Y Binning Range by	Specify the parameter that defines the Y binning range. Bin Centers Y binning range is indicated by bin centers. Bin Ends Y binning range is indicated by bin ends.
Minimum Bin Beginning	The minimum value for the lowest Y bin.
Maximum Bin End	The maximum value for the lowest Y bin.
Step by	Specify bin construction, including Bin Size and Number of Bins.
Bin Size	Specify the fixed step size for Y bins.
Number of Bins	Generated automatically by the bin range and increment.
Periodical	Specify whether or not the data is periodic.
Period	Specify a period for the data. It is available when Periodical is checked.
Border Options	Include Outliers Add outliers to lowest and highest bins. Only available when Periodical is selected. Include Outliers < Minimum Include outliers that are less than bin minimum of the lowest bin. Available when Periodical is cleared. Include Outliers>=Maximum Include outliers that are greater than or equal to the bin maximum of the highest bin. Available when Periodical is cleared.. Separately Count Minimum Bin the minimum value separately. Separately Count Maximum Bin the maximum value separately.
Output Binning Order	Specify the sort order of the bin data output. Ascending Output bin data in ascending order. Descending Output bin data in descending order.

Quantity to Compute

Compute selected bin statistics.

Minimum	Output minimum for each bin.
Maximum	Output maximum for each bin.
Mean	Compute and output mean for each bin.
Median	Output median for each bin.
Sum	Compute and output sum for each bin.
Count	Compute and output count for each bin.
Percent Frequency	Compute and output percent frequency for each bin.

Column to Compute Quantity

Available when an option other than Count is chosen from the Quantity to Compute drop-down list. Select a column to compute the Quantity to Compute. The Customized option allows choosing an arbitrary column in the current worksheet.

Base Column

Available only when Column to Compute Quantity = Customized. Allows you choose an arbitrary column in the current worksheet.

Bin Output

Specify whether to output the Bin, Bin Begin and Bin Center/Bin End for specified X Binning Ranges. By default, these three boxes are not checked.