Time between DESIRED events?
Thanks for starting the JMP forum! Looks like I'm the first non-SAS submitter, so...
I'm trying to develop factors to add to an existing likelihood-to-buy model. I'm taking known sales and create mean and stddev on time between purchases, plus a variable representing time-since-most-recent-buy. Is there a platform in JMP that could take the purchase info (one record per item purchased) and generate these stats on a per-customer basis?
I've searched JMP help for periodicity, and the closest I've seen so far is Survival and Reliability, Recurrence Analysis, but I can't see how to adapt the required Cost, End of Service field for my purposes. Of course, I can use SAS and SQL to construct the data I want, but if there's a tool that'll bypass that tedium, I'd love to use it.
Thanks for any leads,
Steve