Split File -> Lower Bound -> Regression

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Split File -> Lower Bound -> Regression

jimjohn
One of my variables is incentive and another is redemption rate, both nunbers.
i have split cases by Jumbo(3 categories: nonjumbo, jumbo, superjumbo) and by MonthlyAge(From 1 to 11).
I also have a regression equation that relates redemption rate (IV) to MonthlyAge, Incentive, and Incentive^2.

So, after splitting the files, I ran descriptions for incentives. This gives me incentives for each monthly age and for each value fo jumbo. for each of these values, I want to take the me an incentive, reduce it by 3 standard deviations, and then plug this value of incentive into the regression equation with the corresponding age value too and come up with an estimated redemption rate.

can anyone tell me how to do this in spss. Up to now, i would just write down the mean and stdev incentives on a paper and then type each one into Excel and then use excel to find the lower boud incentive and plug in regression equation. This is too time consuming and I was wondering if theres an efficient way to just do this straight in SPSS? Maybe through the syntax. Any ideas? Thanks so much.