Every month, an organization surveys some of its customers (the total number of customers is also known).

The sampled customers answer a survey with a dozen or so questions; sometimes, customers don't answer every question.

A simple average of the *proportion* of answering customers who gave the top category on Question 1 and the *proportion* who gave the highest answer to Question 2 is calculated. (The top category for some questions is "Excellent," for other questions it is "Always.")

This average creates a score that is reported at the end of each month.

What command(s) in SPSS could compute the probability/magnitude of improvement in that score over a given historical window?

Also, is it possible to smooth this score? Predict future scores?

I've already investigated an ARIMA, but couldn't figure out how to incorporate the boundaries of the dependent variable (0,1) into the command.

**Contents**hide

#### Best Answer

To forecast data that is constrained to the interval $]0,1[$, you can first logistically transform the observations: $ z_t = lnbig(frac{y_t}{1-y_t}big) $. The transformed variables $z_t$ are then unconstrained and can be modeled and forecasted using any method you like (exponential smoothing, state spaces, ARIMA etc.). You then just back-transform the forecasts. However, this is only a first approximation, as the transformation may mess up your underlying distributional assumptions, but it may be a good first step. You may want to take a look at Snyder et al. (2017, *IJF*), "Forecasting compositional time series: A state space approach".

Unfortunately, I can't help you with SPSS, sorry…

### Similar Posts:

- Solved – In SPSS, is there any way to define a use groups of data based on combinations of variables
- Solved – K-means classifies 96% of the data in 1 cluster. Any suggestions to improve the results
- Solved – How to select observation window and performance window for churn prediction
- Solved – How to standardise cases within groups to perform ranking across groups and over time
- Solved – Factor vs. Covariate in SPSS MIXED