Descriptive Data Mining by David L. Olson & Georg Lauhoff

Author:David L. Olson & Georg Lauhoff
Language: eng
Format: epub
ISBN: 9789811371813
Publisher: Springer Singapore

We carry out this analysis and obtain the data as shown in Table 4.10.Table 4.10Counts from excel

Recency

Frequency

Monetary

1

756

918

930

2

98

71

60

3

52

10

7

4

93

0

2

5

1

1

1

Count

1000

1000

1000

We see that equally spaced ranges give large values for a few cells and very low (even empty) counts for others. After we assigned for example a customer to R = 1, F = 1 and M = 1, we would assign the RF score = 11 for this customer. If the values desired are in cells H25 and I25 the function would be:

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.