Limits and Data Handling Specifications

XLMiner™ has different maximum limits on the size of data, depending on its version#, build# and edition. See the following table. To know the version and build# of XLMiner™ that you are using, see the "About XLMiner" box in the XLMiner™ menu.

Note: Academic Research edition capabilities are similar to those of Professional edition; exceptions noted.

  Professional / Research Edition Education Edition
Partitioning    
# of Rows

Original data : 500,000 (65,000 in Excel 2003)

Output : 500,000 (65,000 in Excel 2003), subject to training partition being 10,000

Original data : 65,000

Output : 65,000 subject to training partition being 10,000

# of Columns

Original data : No limit

Output : 200

Original data : No limit

Output : 100

Sample from worksheet    
# of Rows Original data: Max. Excel limit.

Sample output: 500,000 (65,000 in Excel 2003)

Original data: 65,000

Sample output: 65,000

# of Columns Original data : No limit

Output : 200

Original data : No Limit

Output : 100

# of Categories for Stratum Variable (in Stratified Sampling) 30 (Stratum values are not case sensitive) 30 (Stratum values are not case sensitive)
Sample from Database    
# of Fields

In the table: No limit

Sample output: 200

In the table: No limit

Sample output: 100

# of Records In the table: 10,000,000

Sample Output: 500,000 (65,000 in Excel 2003)

In the table: 1,000,000

Sample Output: 65,000

# of Categories for Stratum Variable (in Stratified Sampling) 30 (Stratum values are not case sensitive) 30 (Stratum values are not case sensitive)
Handling Missing Values    
# of Rows 500,000 (65,000 in Excel 2003) 65,000
# of Columns 200 100
# of Missing Values that can be treated at a time 500,000 (65,000 in Excel 2003) 65,000
Bin Continuous Data    
Sum of # of columns in the data range and # of columns selected for binning 200 100
# of rows 500,000 (65,000 in Excel 2003) 65,000
# of columns in the output 200 (Inclusive of all columns in the data range and binned columns) 100 (Inclusive of all columns in the data range and binned columns)
Transform Categorical Data    
# of rows 500,000 (65,000 in Excel 2003) 65,000
# of Columns 200 (Inclusive of all columns in the data range and the ones in the output) 100 (Inclusive of all columns in the data range and the ones in the output)
# of Distinct Classes 30 30
# of Output Variables 30 30
Time Series    
# of Rows 10,000 10,000
Classification and Prediction    
# of Rows 10,000 for Training

500,000 (65,000 in Excel 2003) for Training + Validation + Test

(if partitioning is used)

65000 in new data used as Scoring target

10,000 for Training

65,000 for Training + Validation + Test

(if partitioning is used)

65000 in new data used as Scoring target

# of Columns (input variables) 100 (The data set can contain up to 200 columns, out of which, up to 100 can be selected for the model as input variables) 100 (The data set can contain up to 100 columns, out of which, up to 100 can be selected for the model as input variables)
# of Distinct Classes for a categorical variables 30 (Class values are not case sensitive) 30 (Class values are not case sensitive)
# of Distinct Values for any input variable for Naive Bayes classification 1,000 (Values are not case sensitive) 100 (Values are not case sensitive)
# of Nearest neighbors for k-Nearest Neighbors 20 (or # Training rows, whichever is smaller) 20 (or # Training rows, whichever is smaller)
# of Splits for Regression Tree 5,000 (or [# of Training rows -1], whichever is smaller 1,000 (or [# of Training rows -1], whichever is smaller
# Levels in Tree Drawing for Regression and Classification trees 7 (Actual tree may contain more levels) 7 (Actual tree may contain more levels)
# Epochs for Neural Networks 500,000 (65,000 in Excel 2003) 65,000
# of Iterations for Logistic Regression 100 100
Affinity - Association Rules    
# of Transactions *500,000 (65,000 in Excel 2003) *65,000
# of Distinct items in data set 5,000 1,000
# of Items in a Transaction *200 *100
# of Rules 500,000 (65,000 in Excel 2003) (Additional rules may exist, they are not displayed) 65,000 (Additional rules may exist, they are not displayed)
Data Exploration & Reduction    
# of Rows 20,000

Exception: when using Hierarchical Clustering, the number of rows is limited to 4000.

10,000

Exception: when using Hierarchical Clustering, the number of rows is limited to 2000

# of Columns (variables) 200 100
# of Clusters displayed in a Dendrogram 30 (The solution may involve a higher number of clusters, but the Dendrogram shows a maximum of 30 top-level clusters) 30 (The solution may involve a higher number of clusters, but the Dendrogram shows a maximum of 30 top-level clusters)
Size of Distance Matrix (if specified) for Hierarchical Clustering 200 x 200 100 x 100
# of Clusters for k-Means clustering 20 (or # Training rows whichever is smaller) 20 (or # Training rows whichever is smaller)
# of Iterations for k-Means clustering 50 50
Charts    
# of Rows No limits 65,000
# of Columns Original Data: 200 Original Data: 100
# of Distinct values X-variable can take 5 (for Box plot) 5 (for Box plot)
General    
# of Worksheet in workbook (Excel file) 245, before running any XLMiner™ procedure

(Count includes any hidden/very hidden sheets also which may be present in the workbook)

245, before running any XLMiner™ procedure

(Count includes any hidden/very hidden sheets also which may be present in the workbook)

Model Storage and Scoring Included Included

* These are the maximum limits allowed by XLMiner™, but they may vary depending upon the availability of Random Access Memory (RAM) on your machine.

Download a Free Trial Right Now

To try out XLMiner for yourself, simply download our XLMiner free 30-day trial. You can download immediately after registering, or return later anytime -- just login with your email address.

Download XLMiner Data Mining

Please use your company or university email address.
At least 7 printable characters that you can remember.

Trial version license codes are sent to your email address.

Ready to order, or just want to know more about prices and support?
Click here for more information.