Solved

SPSS Regression Analysis

Posted on 2013-06-29
2
453 Views
Last Modified: 2013-06-30
Hello Experts:

I have fundamental statistical background... currently learning my ways in SPSS.

Please see attached PDF.   Contains some statistics (i.e., running multiple regression) and graphs.

I'd like to get some assistance in interpreting the data.    From my perspective, the regression line indicates a "positive correlation" between the independent variables (I included 4 of them) and the single dependent variable.   In fact, the R^2 = 0.908... which I think is considered high/strong.

However, looking at the ANOVA and Coefficients summary table, the p-value (I think that's "Sig.") is NOT significant... that is, it is shown as 0.524.   From what I know, a significant p-value should be less than 0.05 or 0.01.

So, if I interpret the graph with regression line correctly, I would have expected the p-value to approach 0.   Again, that's not the case.

Am I mixing things up?    Given the limited amount of info included in the PDF, could someone please help better understand the data/information?

Thank you in advance,
EEH
Correlation----Obtain-Better-Und.pdf
0
Comment
Question by:ExpExchHelp
2 Comments
 
LVL 37

Accepted Solution

by:
TommySzalapski earned 500 total points
ID: 39288035
R^2 is a measure of how well the line fits the data (or how little error there is).
p is a measure of how likely it is that random data would produce what you see.

The reason your R^2 is high is because (as you can see) the line does really seem to fit well.
The reason your p isn't very low is because you only have 9 data points. The odds that random chance will look correlated is very high with such a small sample size. If you had a lot more data and the regression line still fit that well, you would see p be much smaller.
0
 

Author Comment

by:ExpExchHelp
ID: 39288046
TommySzalapski:

Great... that explanation is exactly what I was looking for.   The information is based on a survey pilot.   The actual survey will probably result in several hundred data points.

At this time, I'm merely investigating what analysis options are out there... basically preparing the upcoming data analysis phase.

Again, thanks for the valuable feedback.

EEH
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

832 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