IBM SPSS Modeler Cookbook

Using aggregate to write cluster centers to Excel for conditional formatting

In nearly all organizations, the Modeler practitioners and model builders are reporting to a management team that either does not have day to day access to Modeler or is unfamiliar with the tool. Therefore, during the evaluation phase, if the analyst is to break away from the constraints of a purely technical judging of models, then he or she needs to give management the ability to join into the evaluation of models. One rarely exports raw data to Excel. The size limitation would almost always be a factor, and there is rarely any good reason to do it. However, Excel is a great way to send, discuss, and report on summary information.

In this recipe, we will take the summary ...