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	Trial Edition
Partitioning
# of Rows	Original Data: 500K (Excel 2003: 65K) Output: 500K (Excel 2003: 65K) Training partition: 10K	Original Data: 500K (Excel 2003: 65K) Output: 500K (Excel 2003: 65K) Training partition: 10K	Original Data: 600 Output: 600 Training partition: 200
# of Columns	Original Data: 16,384 Output: 200	Original Data: 16,384 Output: 200	Original Data: 16,384 Output: 200
Sample from worksheet
# of Rows	Original Data: Max Excel limit Sample output: 500K (Excel 2003: 65K)	Original Data: Max Excel limit Sample output: 500K (Excel 2003: 65K)	Original Data: Max Excel limit Sample output: 200
# of Columns	Original Data: No Limit Output: 200	Original Data: No Limit Output: 200	Original Data: No Limit Output: 200
# of Categories for Stratum Variable (in Stratified Sampling)	30 (Stratum values are not case sensitive)	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	Not Supported	In the table: No limit Sample output: 200
# of Records	In the table: No limit Sample output: 500K (Excel 2003: 65K)	Not supported	In the table: 200 Sample output: 200
# of Categories for Stratum Variable (in Stratified Sampling)	30 (Stratum values are not case sensitive)	Not supported	30 (Stratum values are not case sensitive)
Handling Missing Values
# of Rows	500K (Excel 2003: 65K)	500K (Excel 2003: 65K)	200
# of Columns	200	200	200
# of Missing Values that can be treated at a time	500K (Excel 2003: 65K)	500K (Excel 2003: 65K)	200
Bin Continuous Data
Sum of # of columns in the data range and # of columns selected for binning	200	200	200
# of rows	500K (Excel 2003: 65K)	500K (Excel 2003: 65K)	200
# of columns in the output	200 (Inclusive of all columns in the data range and binned columns)	200 (Inclusive of all columns in the data range and binned columns)	200 (Inclusive of all columns in the data range and binned columns)
Transform Categorical Data
# of rows	500K (Excel 2003: 65K)	500K (Excel 2003: 65K)	200
# of Columns	200 (Inclusive of all columns in the data range and the ones in the output)	200 (Inclusive of all columns in the data range and the ones in the output)	200 (Inclusive of all columns in the data range and the ones in the output)
# of Distinct Classes	30	30	30
# of Output Variables	30	30	30
Time Series
# of Rows	10K	10K	200
Classification and Prediction
# of Rows	10K for Training 500K (Excel 2003: 65K) for training+validation+test (If partition used): 500K (Excel 2003: 65K) in new data used as Scoring target	10K for Training 500K (Excel 2003: 65K) for training+validation+test (If partition used): 500K (Excel 2003: 65K) in new data used as Scoring target	200 for each partition (Training, Validation, and Test) if partitioning is used 200 if partitioning is not used 200 in new data used as scoring target
# of Columns (input variables)	100 (the data set can contain up to 200 columns of which up to 30 can be selected for th emodel as input variables)	100 (the data set can contain up to 200 columns of which up to 30 can be selected for th emodel as input variables)	30 (the data set can contain up to 200 columns of which up to 30 can be selected for th emodel as input variables)
# of Distinct Classes for a cateogrical variables	30 (Class values are not case sensitive)	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	1K (Values are not case sensitive)	1K (Values are not case sensitive)	30 (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)	20 (or # Training rows, whichever is smaller)
# of Splits for Regression Tree	5K (or [# of Training rows -1], whichever is smaller	5K (or [# of Training rows -1], whichever is smaller	5K (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)	7 (Actual tree may contain more levels)
# Epochs for Neural Networks	500K (Excel 2003: 65K)	500K (Excel 2003: 65K)	200
# of Iterations for Logistic Regression	100	100	100
Affinity - Association Rules
# of Transactions	500K (Excel 2003: 65K)	500K (Excel 2003: 65K)	200
# of Distinct items in data set	5K	5K	1K
# of Items in a Transaction	30	30	30
# of Rules	500K (Excel 2003: 65K) Additional rules may exist but they are not displayed	500K (Excel 2003: 65K) Additional rules may exist but they are not displayed	500K (Excel 2003: 65K) Additional rules may exist but they are not displayed
Data Exploration & Reduction
# of Rows	20K Exception: when using Heirarchical Clustering the # of rows is limited to 4K	20K Exception: when using Heirarchical Clustering the # of rows is limited to 4K	200
# of Columns (variables)	200	200	30 The data set can contain up to 200, out of which up to 30 can be selected as variables
# of Clusters displayed in a Dendrogram	30 The solution may involve a higher number, but the dendrogram shows a max of 30 top-level clusters	30 The solution may involve a higher number, but the dendrogram shows a max of 30 top-level clusters	30 The solution may involve a higher number, but the dendrogram shows a max of 30 top-level clusters
Size of Distance Matrix (if specified) for Hierarchical Clustering	200 x 200	200 x 200	30 x 30
# of Clusters for k-Means clustering	20 Or the # of Training rows if smaller	20 Or the # of Training rows if smaller	20 Or the # of Training rows if smaller
# of Iterations for k-Means clustering	50	50	50
Charts
# of Rows	10K	10K	200
# of Columns	Original Data: 200 For charts drawing: 5 (For Box & Matrix Plots)	Original Data: 200 For charts drawing: 5 (For Box & Matrix Plots)	Original Data: 200 For charts drawing: 5 (For Box & Matrix Plots)
# of Distinct values X-variable can take	5 (for Box plot)	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	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	Included

Download a Free Trial Right Now

To try out XLMiner for yourself, simply download our XLMiner free 30-day trial.

Just enter your name and email address, and optionally your company and phone, pick the closest "User Type," and click the Register for Download button.  You can download immediately after registering, or return later anytime -- just login with your email address.

User Type     Please Select Commercial User Consultant Corporate Developer Government/Military Professor Student VAR/ISV Developer Email Address First & Last Name Company or University Telephone We respect your privacy!  See our Privacy Policy Statement. Trial version passwords are sent to the above email address.

Ready to order, or just want to know more about prices, upgrades from previous versions, competitive upgrades, and annual support?  Click here for more information.