How to prepare data for a Regression Analysis

Question

I have a set of data including a 10 point rating scale (overall satisfaction) and about 20 service rating questions (measured using a 5 point satisfaction scale).

What I would really like to do is to run a regression analysis to measure how well correlated each of the satisfaction statements are with the overall rating question (and ideally to be able to order them by ‘importance’ / key drivers).

Are there any suggestions out there on how I should prepare the data and use stats IQ / Regression to best achieve this.  I have statsIQ and have tried running with the full data (using the 10 pt and 5pt scale data) but not confident in the results.

Any thoughts would be appreciated!

ClairJ · Answer

Hi @Ashards I don't know anything about statsIQ, but I can speak to your point on comparing your statements in terms of importance. To do that, you will want to standardize your regression coefficients (dividing by standard deviation). I'm not sure whether statsIQ can do this for you, but you can also calculate them manually. This will make the coefficients comparable.

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded