Can you suggest me the regression/correlation model for the following case:
I have computed walkability index (e.g. Y) for various buildings of few neighborhoods. This index is composite variable computed based on other variables. Now I would like to see the association/correlation between this variable with the frequency (e.g. daily, bi-weekly, monthly) (Xi) of various subjects and the time (e.g. 5-10 min, 10-15 min etc) (Xii) those subjects take to go nearest facilities like shopping, hospital etc. But in the SPSS dataset I got, the responses are in category (e.g. 1=5-10 min, 2=10-15min). On the other hand, I have walkability data both in numerical value and categorical (low, medium, high).
Now, can anyone kindly suggest me how I should proceed? Would be very helpful if you kindly tell me stepwise work in SPSS.
I have computed walkability index (e.g. Y) for various buildings of few neighborhoods. This index is composite variable computed based on other variables. Now I would like to see the association/correlation between this variable with the frequency (e.g. daily, bi-weekly, monthly) (Xi) of various subjects and the time (e.g. 5-10 min, 10-15 min etc) (Xii) those subjects take to go nearest facilities like shopping, hospital etc. But in the SPSS dataset I got, the responses are in category (e.g. 1=5-10 min, 2=10-15min). On the other hand, I have walkability data both in numerical value and categorical (low, medium, high).
Now, can anyone kindly suggest me how I should proceed? Would be very helpful if you kindly tell me stepwise work in SPSS.