O'Reilly logo

IBM SPSS Modeler Cookbook by Scott Mutchler, Tom Khabaza, Meta S. Brown, Dean Abbott, Keith McCormick

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Calculating and comparing conversion rates

There are times when you need to transform a variable to be able to better answer a question or to gain additional insight. In this recipe we will calculate the ratio of donors to total prospective donors. The data set already has a donate/not donate variable in the form of TARGET_B. We will calculate something similar for all of the campaigns, allowing us to present results on a line chart and look at trends.

Getting ready

We will start with the Conversion Rates.str stream.

How to do it...

  1. Open the stream and edit the Derive node. Note that it is a multiple derive and it is producing several new variables:
  2. Edit the Statistics node, verify that it is requesting Mean only and run:
  3. Add an Aggregate node with ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required