SPSS Advantage for Microsoft Excel

Features
Downloads

Extend the capabilities of Excel to analyze business data sets

IBM® SPSS® Advantage for Microsoft Excel gives you selected IBM SPSS Statistics functionality that is integrated with Excel spreadsheets. The software provides advanced tools to help you manage and analyze large business data sets, even if you don’t have detailed knowledge of statistics.

IBM SPSS Advantage for Microsoft Excel enables business users to employ advanced data preparation and analysis tools within Excel.

Conduct RFM analysis to identify your most valuable customers.
Identify market segments using visual classification trees.
Isolate unusual or problem data so you can remove or correct it prior to analysis.
Prepare and transform data using spreadsheet tools and procedures.

Conduct RFM analysis

Allows you to conduct recency, frequency and monetary value (RFM) analysis to identify customers who are most likely to buy in the future.
Provides wizards to help you create RFM scores for customer or transaction data.
Produces charts for diagnostic tests to help you understand the distribution of your data.

Identify market segments

Enables you to create visual classification trees to identify groups and market segments.
Allows you to explore results and find subgroups and relationships in your data that would be difficult to uncover using statistics in Excel.

Isolate unusual or problem data

Provides a specific procedure to detect invalid values caused by data entry errors and to identify cases that are unsuitable for analysis.
Highlights the data cell and provides a brief explanation of the reasons for the anomaly.

Prepare and transform data

Allows you to reorganize or combine data by joining tables, restructuring or aggregating rows.
Provides a bin values procedure to help you establish data ranges, reduce the number of variables and safeguard the privacy of data sources.
Enables you to save Excel tables in formatted data files for use with IBM SPSS Statistics.

SPSS Advantage for Microsoft Excel resources

White paper: The Risks of Using Spreadsheets for Statistical Analysis
Explore the points you should consider if you use a spreadsheet to perform statistical analysis.

Trial software: IBM SPSS Statistics Developer
Integrate the power R and Python with the core functionality of SPSS Statistics.

White paper: Seven Reasons You Need Predictive Analytics Today
Learn about the seven strategic objectives that can be attained by employing predictive analytics.