SPSS "Crash Course Question"

Posted on 2013-06-22
Last Modified: 2013-06-22
Need some assistance with SPSS.   At this time, I'm a novice on the SPSS software package.

Obviously, there's tons of information on Google and YouTube.   At the same time, having a specific question, I'd like to reach out to the EE network and see if I can get some general pointers:

Quick Background:
- As part of some research, I have several independent variables (across different categories) and several dependent variables.
- To determine correlation (in SPSS), I believe one of the viable options is to use "One-Way ANOVA"...
- Thus, for testing purposes, I've selected one of the independent variables and a dependent variable.  
- When executing the One-Way ANOVA, I don't see any "Multiple R", "R Square", "Adjusted R Square", or "P values", etc. (as seen when computing in Excel).

My question:
Whether a one-to-one (1 independent variable vs. 1 dependent variable) OR many-to-one (several IVs vs. 1 DV), what are some viable statistics/test that I should run in SPSS?

Again, just looking for some general guidelines... SPSS is extremely powerful and I probably won't use more than 10% of its capabilities.   Right now, it's just a bit overwhelming when learning this tool.


Question by:ExpExchHelp
  • 4
  • 2
  • 2
LVL 53

Assisted Solution

by:Joe Winograd, EE MVE
Joe Winograd, EE MVE earned 250 total points
ID: 39268039
I'm a huge fan of EE, but in this particular case, I suggest going to some experts that specialize in statistics. I previously worked for a company called Straight Line Performance Solutions (there's no conflict of interest, since I no longer work for them and have no financial interest/involvement whatsoever with the company). They are heavy-duty experts in statistics and offer a free service called Ask a Statistician. I have first-hand experience seeing their responses to questions asked at the Ask a Statistician page and I can say that they are excellent...and in most cases, very fast. Regards, Joe

Accepted Solution

richdiesal earned 250 total points
ID: 39268049
First of all, there is an SPSS section of Experts Exchange - if you want SPSS-specific help, you should post there.

Second, the problem you are having is not with SPSS, but rather with your understanding of statistics.  One-Way ANOVA (SPSS or otherwise) is a test that partials total variance in a DV into between-group (IV) and within-group (error) variance.  The only effect size estimate it can really produce is eta-squared, which is related to R^2 (multiple R^2), but only in certain cases.

You have mixed up a lot of different analyses with different purposes, all of which are run in different places in SPSS.  I will go through what I am interpreting as the issues you are having one by one:

1) "To determine correlation (in SPSS), I believe one of the viable options is to use "One-Way ANOVA"

This is incorrect.  A 1-Way ANOVA and correlation are not the same.  If you want simple bivariate correlations, you should open Analyze > Correlate > Bivariate and select the pair of variables you are interested in correlating.  That prompt is capable of reporting most  types of correlation you probably want, whether it is Pearson's, Spearman's, etc.

2) "When executing the One-Way ANOVA, I don't see any "Multiple R", "R Square", "Adjusted R Square", or "P values",

The assumptions of One-way ANOVA do not include linearity, so R and related statistics are not reported.  Excel just assumes you know what you're doing and will only interpret the statistics that you should interpret (which is why it's dangerous to use Excel for statistical analyses if you're not well-versed in statistical theory).  r-squared is literally that - r multiplied by r.  To get an r, you want to calculate a Pearson's correlation, which you can do using the technique described above.  You can then multiply it by itself with a calculator to get r-squared.

You also mentioned Multiple R, which is based on a different family of analyses, called linear regression (little r and big R are identical if you have only one IV and one DV, but little r can't be calculated with multiple IVs).  Multiple R requires multiple independent variables.  If you actually do want multiple IVs predicting a single DV, you can do so in SPSS within Analyze > Regression > Linear.  It will report R, R-squared, and p-values associated with tests of the intercept and the slopes of each predictor against zero, depending on which you want, along with a multiple-R indicating total variance shared between outcome and the full predictor set.

3) "Whether a one-to-one (1 independent variable vs. 1 dependent variable) OR many-to-one (several IVs vs. 1 DV), what are some viable statistics/test that I should run in SPSS?"

It depends on what you want to know, and the analyses I will mention below assume you have interval or ratio level scale of measurement on both of your variables.  If you don't, you'll need different tests.  Given that... if you just want to correlate two variables, a simple Pearson's correlation is probably what you want (use the technique described above).  If you want to predict one DV from several IVs (again, all must be interval+), multiple linear regression would be a reasonable analysis (also follow approach above), and you might want to interpret slopes or overall model fit, depending upon your research question.  

Also note that if you have group membership data in your IVs, you probably want n-way ANOVA, but it's not going to report R-family statistics, because they are not appropriate for ANOVA.

Author Comment

ID: 39268057
Joe -- thank you the pointer to "Straight Line Performance Solutions"... I definitely check it out.


richdiesal -- although I've taken stats classes, I certainly don't consider myself a SME on it.   So, I do thank you for providing some general background as to what other/better methods should be explored.   Btw, when searching on groups I entered "SPSS"... but it didn't show up.  Is it list under its full name (vs. acronym)?  

Again, thank you both for your feedback... it's very much appreciated.
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.


Author Closing Comment

ID: 39268058
Great feedback... exactly what I was trying to find out.
LVL 53

Expert Comment

by:Joe Winograd, EE MVE
ID: 39268060
I didn't know that there's an SPSS section of EE...thanks for that piece of info! I also didn't know that there are experts on statistics like you...I had the sense that the experts are all computer scientists. :)   Thanks for correcting my misimpression. Regards, Joe

Expert Comment

ID: 39268102
Here is my link to it (although it is not very active):

Author Comment

ID: 39268105
Thanks, Rich... 'bookmarked it.  :)


Author Comment

ID: 39268225

May I ask you a follow-up question?

Per your recommendation, I've used the bi-variate (Pearson's method) to compare one of the IV in respect to one of the DVs.

My sample data is rather small (i.e., 9) at this time.   Eventually, I anticipate to have several hundred data point.   So, current data is only used to familiarize myself with the various methods/processes in SPSS.

Per attached JPG, would you mind helping me out to interpret some of the listed information?

Thank you in advance,

P.S. I didn't expect the bi-variate method has one a single dialog box for the variables.   How does SPSS know which is the IV vs. the DV?

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If your app took Google’s lash recently, here are the 5 most likely reasons.
This article provides a brief introduction to tissue engineering, the process by which organs can be grown artificially. It covers the problems with organ transplants, the tissue engineering process, and the current successes and problems of the tec…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question