RMS 618 Module 1 - SPSS Commands
docx
keyboard_arrow_up
School
Trident University International *
*We aren’t endorsed by this school
Course
608
Subject
Statistics
Date
Feb 20, 2024
Type
docx
Pages
4
Uploaded by DoctorBraveryWalrus7988
Module 1 - SPSS Commands
Correlation and Simple Linear Regression
SPSS Commands
Preparation for Analysis
SPSS Commands
Check assumption of normality/homoscedasticity (for regression)
Select Analyze -> Regression -> Linear. Enter DV
and IVs.
-Select “Plots.” 1) Select ZRESID (or SDRESID) as the y variable and ZPRED (standardized predicted values) as the x variable. Select histogram and/or normal probability plot.
Check assumption of collinearity (for regression)
Select Analyze -> Regression -> Linear. Enter DV
and IVs.
-Select “Statistics.” Select collinearity diagnostics. Select continue. The following suggest a multicollinearity problem: condition index >15, VIF>4, Tolerance < .2
Create dummy codes for variables (for transforming categorical variables to dichotomous variables in regression)
Select Transform -> Recode into different variables. Select variables to be transformed. Enter name and label. Press change and then "old and new values." Enter old value (the value to be changed) and new value (the value of the transformed variable). Press "Add" to add the recoding to the list. When all the recodings have been added, click on the "Continue" button and then the "OK" button.
Type of Analysis
SPSS Commands
Descriptive Analysis #1
Select Analyze -> Descriptive Statistics -> Frequencies.
-Display frequency tables - mark this if you are examining categorical variables
-Select “Statistics” and check mean, median, standard deviation, skewness, and kurtosis (to check for normal distribution)
-Charts: select this option to examine frequencies of continuous variables
Descriptive Analysis #2
(more detailed - more focus on outliers and assumption checking)
Select Analyze -> Descriptive Statistics -> Explore. Enter DV and factors.
-Select “Statistics” and check descriptives
-Boxplots: mark this to examine if there are outliers
Correlations
Select Analyze -> Correlate. For bivariate correlations, select Pearson (for interval or ratio data) or Spearman (for ordinal data).
Simple Linear Regression
Select Analyze -> Regression -> Linear. Enter the dependent and independent variables. Then click ok.
Multiple Regression
Select Analyze -> Regression -> Linear. Enter DV.
-Select one of the following options:
1)Forced entry: Select enter for method. Add all independent variables. Then click ok.
2) Stepwise: Select stepwise for method. Add all independent variables. Select statistics and check R squared change. Then click continue and ok.
3) Hierarchical: Select enter for method. Enter first group of independent variables; then select next. Repeat for subsequent groups of variables until all variables have been entered. Select statistics and check R squared change. Then click continue and ok.
Logistic Regression
Select Analyze -> Regression -> Binary logistic. Enter dependent and independent variables.
-Select the categorical button. Enter the categorical variables (or ordinal variables with a few categories). Click continue.
-Select the options button and check classification
plots and Homer-Lemeshow goodness-of-fit test. Click continue.
-Select the logistic regression method.
Then click continue and ok.
MANOVA/MANCOVA
Select Analyze -> General Linear Model -> Multivariate. Enter dependent variables, categorical predictor variables in fixed factors, and scale predictors in covariates.
-Select options. Mark descriptive statistics, estimates of effect size, and homogeneity test.
-Select Post Hoc. Move factors to the Post Hoc test box. Select Bonferroni
Factor Analysis
Select Analyze-->Data Reduction-->Factor.
-Select Descriptives. Check univariate descriptives, initial solution and KMO and Bartlett's test.
-Select Extraction. Select principal components method and check correlation matrix, unrotated factor solution, scree plot, eigenvalues over 1.
-Select Rotation. Check Varimax.
* Tip: Click on the help button for the statistical test you are running within SPSS. Then select show me (which will open a tutorial on how to run the test and interpret the output).
SPSS Output: Interpretation of Coefficients in Linear Regression
The following output was obtained for Subject A as the independent variable and Subject B as the dependent variable. The following output may be interpreted as follows: For each increase of 1 unit of score on Subject A, there is a .641 increase in the score of Subject B.
Coefficients
Unstandardized Coefficients
Standardized
Coefficients
t
Sig.
Model
B
Std. Error
Beta
1
(Constant)
16.237
4.078
3.982 .001
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Subject A
.641
.408
.317
1.570 .131
a Dependent Variable: Subject B
Privacy Policy
|
Contact
Related Documents
Related Questions
Construct a scatter plot in Excel with FloorArea as the independent variable and AssessmentValue as the dependent variable. Insert the bivariate linear regression equation and r^2 in your graph. Do you observe a linear relationship between the 2 variables?
FloorArea (Sq.Ft.)
Offices
Entrances
Age
AssessedValue ($'000)
4790
4
2
8
1796
4720
3
2
12
1544
5940
4
2
2
2094
5720
4
2
34
1968
3660
3
2
38
1567
5000
4
2
31
1878
2990
2
1
19
949
2610
2
1
48
910
5650
4
2
42
1774
3570
2
1
4
1187
2930
3
2
15
1113
1280
2
1
31
671
4880
3
2
42
1678
1620
1
2
35
710
1820
2
1
17
678
4530
2
2
5
1585
2570
2
1
13
842
4690
2
2
45
1539
1280
1
1
45
433
4100
3
1
27
1268
3530
2
2
41
1251
3660
2
2
33
1094
1110
1
2
50
638
2670
2
2
39
999
1100
1
1
20
653
5810
4
3
17
1914
2560
2
2
24
772
2340
3
1
5
890
3690
2
2
15
1282
3580
3
2
27
1264
3610
2
1
8
1162
3960
3
2
17
1447
arrow_forward
The data show The chest size and weight of several bears find regression equation, letting chest size be the independent variable then find the best predicted weight of a bear with a chest size of 51 inches is the result close to the actual weight of 422 pounds use a significance level of 0.05
Chest size : 45, 50, 43, 43, 52, 52.
Weight : 352, 374, 275, 314, 440, 367.
arrow_forward
when a regression is used as a method of predicting dependent variables from one or more independent variables. How are the independent variables different from each other yet related to the dependent variable?
arrow_forward
Please help me with question d, e, f, g, h, and I. Thank you.
arrow_forward
Tire pressure (psi) and mileage (mpg) were recorded for a random sample of seven cars of thesame make and model. The extended data table (left) and fit model report (right) are based on aquadratic model
What is the predicted average mileage at tire pressure x = 31?
arrow_forward
Two variables have a positive linear correlation. Is the slope of the regression line for the variables positive or negative?
arrow_forward
Please explain step by step
arrow_forward
A microcomputer manufacturer has developed a regression model relating his sales (y=$10,000s) with three independent variables. The three independent variables are price per unit(Price in $100s), advertising( ADV in $1000s) and the number of product lines (Lines). Part of the regression results is shown below.
Coefficient Standard Error
Intercept 1.0211 22.8752
Price(X1) -0.1524 0.1411
ADV (X2) 0.8849 0.2886
Lines(X3) -0.1463 1.5340
Source d.f. S.S.
Regression 3 2708.61
Error 14 2840.51
Total 17 5549.12
What has been the sample size (n) for this analysis?
Use the above results to find the estimated multiple…
arrow_forward
Excel file:
https://drive.google.com/file/d/1TQG5r2wzLGk--75whZXyb0SDTHZTWS0S/view?usp=sharing
arrow_forward
The linear regression results below are based on commercial properties that real estate
agencies use to guide clients with quantitative information helpful to make rental decisions. A
random sample of 27 properties are considered with data for the variables, age of the property
(X1), operating expenses and taxes (X2), vacancy rates (X3), total square footage (X4), and
rental rates (Y).
Parameter Estimates
Coefficients Standard Error
Intercept
AGE(X1)
EXPENSE(X2)
VACRATE(X3)
SOFOOT(X4)
14.33223914
1.457614894
-0.115608327
0.031632885
0.100364547
0.14274746
0.631648649
2.043860082
0.063765767
0.024929829
What is the upper limit of the 95% confidence interval estimate for the effect of a square
footage increase on the mean rental rates of properties?
arrow_forward
What is Instrumental Variables Regression?
arrow_forward
Study 3: Age & Pain.
Using the same data set PillShapeColor - use Pearson Correlation and simple linear Regression to create results and then summarize these in APA-style.
Run a Pearson Correlation on age and pain rating. Create a scatterplot with pain rating on Y and age on X axis.
Run a simple linear regression model with pain rating as DV and age as IV.
Regression → Linear Regression, choose your DV, IV(s) –use defaults settings.
1-What is the equation for the regression line? How much variance in pain is accounted for by age (R2)? Interpret this in context of the study (is this a lot of variance explained or not much).2-Describe the regression results simply and clearly- include the slope and constant and describe what the slope means. Is age a significant predictor of perceived pain? Finally, describe what the model predicts about the pain rating of a person who is 40 years old and someone 70 years old.
arrow_forward
Part 2: Regression
Based on the correlation you ran to assess the relationship between # of exposures and perceived connection
strength recalled, please carry out the steps to determine the equation for the regression line (or best-fitting line)
а.
Step 1: find the slope and y-intercept
b. Step 2: Using these values, write the equation for the best fitting line, but make sure to write it in terms of the
specific predictor (X) and predicted (Y) variables of interest. In other words, your equation should use variable
names “# of exposures" and "perceived strength of connection rating", rather than X and Y.
Using the regression equation, please predict the perceived connection strength score for a student exposed
subliminally to the stranger's face seven times. Make sure to show your work
с.
d. Using the regression equation, draw the line of best fit on your scatterplot. Please use at least 3 points to
anchor your line and show your work.
arrow_forward
COmpare and constrast the use of prediction intervals for a Single Linear Regression model having one X and Multiple Linear Regression Model having two predictors X1 and X2. WHat are the similarities/differences in process and interpretation?
arrow_forward
Calculate two lines of regression and calculate a linear regression equation to model the data given below:
years (1980,1985,1990,1995,2000)
Enrolment ( 21,25,29,39,47)
arrow_forward
SUMMARY OUTPUT
Y
54
3
Regression Statistics
52
11
4 Multiple R
5 R Square
6 Adjusted R Squa
7 Standard Error
8 Observations
0.926932947
64
11
0.859204688
72
19
0.812272917
81
21
2.341288283
ANOVA
10
11
12 Regression
13 Residual
14 Total
df
SS
MS
Significance F
100.3551075 100.355108
16.44489247 5,48163082
1
18.30752758
0.023447591
116.8
15
16
Upper 95%
-32.33489968 7.68301796
0.105207392 0.71602917
P-value
Lower 95%
Lower 95.0%
Upper 95.0%
Coefficients
-12.32594086
Standard Error t Stat
-32.33489968
0.105207392
0.144788044
7.683017962
17 Intercept
18 X
6.28728874
-1.9604541
0.716029167
0.41061828
0.095967334 4.27872967
0.023447591
19
PEARSON COEFFICIENT r=0.93
20
arrow_forward
Describe about how to place a regression line?
arrow_forward
make a regression analysis about any healthcare issue
arrow_forward
Use the scatterplot of Vehicle Registrations below to answer the questions
Vehicle Registrations in the United States, 1925-
2011 Vehicles millions
300
y = 3.0161x - 5819.5
R² = 0.9695
250
200
150
100
50
1920
-50
1940
1960
1980
2000
2020
Year
State the trend line (regression line).
y= 3.0161 x -5819.5
year
number of vehicle registrations
R^2 = 0.9695
not enough information to determine
Registrations (in millions)
arrow_forward
The applet displays a scatterplot with the following points: (7,10),(27,35),(24,25),(8,12),(10,19),(15,22). Identify the slope of the regression line, intercept of the regression line, and correlation coefficient. Report your answers accurate to within two decimal places.
arrow_forward
Can you help me answer this question please
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill

Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Related Questions
- Construct a scatter plot in Excel with FloorArea as the independent variable and AssessmentValue as the dependent variable. Insert the bivariate linear regression equation and r^2 in your graph. Do you observe a linear relationship between the 2 variables? FloorArea (Sq.Ft.) Offices Entrances Age AssessedValue ($'000) 4790 4 2 8 1796 4720 3 2 12 1544 5940 4 2 2 2094 5720 4 2 34 1968 3660 3 2 38 1567 5000 4 2 31 1878 2990 2 1 19 949 2610 2 1 48 910 5650 4 2 42 1774 3570 2 1 4 1187 2930 3 2 15 1113 1280 2 1 31 671 4880 3 2 42 1678 1620 1 2 35 710 1820 2 1 17 678 4530 2 2 5 1585 2570 2 1 13 842 4690 2 2 45 1539 1280 1 1 45 433 4100 3 1 27 1268 3530 2 2 41 1251 3660 2 2 33 1094 1110 1 2 50 638 2670 2 2 39 999 1100 1 1 20 653 5810 4 3 17 1914 2560 2 2 24 772 2340 3 1 5 890 3690 2 2 15 1282 3580 3 2 27 1264 3610 2 1 8 1162 3960 3 2 17 1447arrow_forwardThe data show The chest size and weight of several bears find regression equation, letting chest size be the independent variable then find the best predicted weight of a bear with a chest size of 51 inches is the result close to the actual weight of 422 pounds use a significance level of 0.05 Chest size : 45, 50, 43, 43, 52, 52. Weight : 352, 374, 275, 314, 440, 367.arrow_forwardwhen a regression is used as a method of predicting dependent variables from one or more independent variables. How are the independent variables different from each other yet related to the dependent variable?arrow_forward
- Please help me with question d, e, f, g, h, and I. Thank you.arrow_forwardTire pressure (psi) and mileage (mpg) were recorded for a random sample of seven cars of thesame make and model. The extended data table (left) and fit model report (right) are based on aquadratic model What is the predicted average mileage at tire pressure x = 31?arrow_forwardTwo variables have a positive linear correlation. Is the slope of the regression line for the variables positive or negative?arrow_forward
- Please explain step by steparrow_forwardA microcomputer manufacturer has developed a regression model relating his sales (y=$10,000s) with three independent variables. The three independent variables are price per unit(Price in $100s), advertising( ADV in $1000s) and the number of product lines (Lines). Part of the regression results is shown below. Coefficient Standard Error Intercept 1.0211 22.8752 Price(X1) -0.1524 0.1411 ADV (X2) 0.8849 0.2886 Lines(X3) -0.1463 1.5340 Source d.f. S.S. Regression 3 2708.61 Error 14 2840.51 Total 17 5549.12 What has been the sample size (n) for this analysis? Use the above results to find the estimated multiple…arrow_forwardExcel file: https://drive.google.com/file/d/1TQG5r2wzLGk--75whZXyb0SDTHZTWS0S/view?usp=sharingarrow_forward
- The linear regression results below are based on commercial properties that real estate agencies use to guide clients with quantitative information helpful to make rental decisions. A random sample of 27 properties are considered with data for the variables, age of the property (X1), operating expenses and taxes (X2), vacancy rates (X3), total square footage (X4), and rental rates (Y). Parameter Estimates Coefficients Standard Error Intercept AGE(X1) EXPENSE(X2) VACRATE(X3) SOFOOT(X4) 14.33223914 1.457614894 -0.115608327 0.031632885 0.100364547 0.14274746 0.631648649 2.043860082 0.063765767 0.024929829 What is the upper limit of the 95% confidence interval estimate for the effect of a square footage increase on the mean rental rates of properties?arrow_forwardWhat is Instrumental Variables Regression?arrow_forwardStudy 3: Age & Pain. Using the same data set PillShapeColor - use Pearson Correlation and simple linear Regression to create results and then summarize these in APA-style. Run a Pearson Correlation on age and pain rating. Create a scatterplot with pain rating on Y and age on X axis. Run a simple linear regression model with pain rating as DV and age as IV. Regression → Linear Regression, choose your DV, IV(s) –use defaults settings. 1-What is the equation for the regression line? How much variance in pain is accounted for by age (R2)? Interpret this in context of the study (is this a lot of variance explained or not much).2-Describe the regression results simply and clearly- include the slope and constant and describe what the slope means. Is age a significant predictor of perceived pain? Finally, describe what the model predicts about the pain rating of a person who is 40 years old and someone 70 years old.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillBig Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt

Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill

Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt