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
A 10-year study conducted by the American Heart Association provided data on how age, blood pressure, and smoking related to the risk of strokes. The data file “Stroke.xslx” includes a portion of the data from the study. The variable “Risk of Stroke” is measured as the percentage of risk (proportion times 100) that a person will have a stroke over the next 10-year period.
Regression Analysis As Image:
1) Based on the simple regression analysis output, write the estimated regression equation.
2) What is the correlation coefficient between Risk of Stroke and Age? How do you find i
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
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
Please help
arrow_forward
What is Instrumental Variables Regression?
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
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
Can you help me answer this question please
arrow_forward
Please help
arrow_forward
Which of the variables is the indepenent variable and dependent variable for the following question.
fit a simple linear regression model to predict latitudes using average monthly range
lat= latitudes
range= the average monthly range between mean montly maximum and minimum temperatures for a selected set of US cities.
arrow_forward
(BIOSTATISTICS)
In this question , What characteristics are associated with BMI?
Use simple and multivariable linear regression analysis to complete the following table relating the characteristics listed to BMI as a continuous variable. Before conducting the analysis, be sure that all participants have complete data on all analysis variables. If participants are excluded due to missing data, the numbers excluded should be reported. Then, describe how each characteristic is related to BMI. Are crude and multivariable effects similar? What might explain or account for any differences?
Outcome Variable: BMI, kg/m2
Characteristic
Regression Coefficient Crude Models
p-value Regression Coefficient Multivariable Model
P-value
Age, years
0.0627
<0.001-0.02155
0.004
Male sex
-0.580
<0.001-09884
<0.001
Systolic blood pressure, mmHg
0.0603
<0.0010.05716
<0.001
Total serum cholesterol, mg/dL
0.0113
<0.0010.00638…
arrow_forward
Let the Explanatory Variable represent the age of a sample of seven randomly selected men. Let the Response Variable represent the corresponding cholesterol measurements of these men.
Explanatory Variable:
Response Variable:
39,
189,
52,
238,
47,
43,
63,
244,
58,
236, 248
69
220,
215,
(a) What is the equation of the regression line for this sample data? The y-intercept of your equation must be to three decimal places and the slope of your equation must be to four decimal places.
O A. y = 1.7283x + 135.543
В.
y = 1.8653x + 105.698
OC. y= 2.1664x + 142.336
(b) Using the equation of your regression line from (a) above what is the predicted cholesterol measurement when a man is 60 years old? Your answer must be to four places.
O A. 217.6160
B. 272.3200
О с. 239.2410
arrow_forward
Decide if gender of the students has a significant influence on the relationship between exam 2 and final results. Assume that the intercepts of the models for males and females are the same. Do not test for equality of intercepts. Are the slopes of the relationships between final and exam2 scores difference for males and females? Test on 10% significance. Include complex and simple model, hypotheses, test statistic, pvalue, and final regression equations for men and women
arrow_forward
Can youm please assist with a,b and c.
Please do it clear enough so i can understand.
Thanks
arrow_forward
Let price denote a price index for the goods sold by a restaurant, advert the amount spent on advertising, sales the sales for the restaurant, and consider the following
two regressions
First regression: sales = B1 + B2price + B3price? + B4advert + ßsadvert? + e,
Second regression: sales = B1 + B2price + B3price? + e
We estimate both regressions using a sample of 105 observations. The sum of square residuals (E ê) from the first regression equals 50, while the sum of square
Li=1
residuals from the second regression equals 70. Suppose we are interested in testing the null hypothesis that expected sales do not depend on advertising. What is the F-
statistic for this null hypothesis? Recall the F-statistic is given by ((SSER - SSEU)/J)/(SSEy/(n – K)).
O a. -15
O b. 42
Oc.
21
O d. 20
O e. All other options are incorrect.
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_forwardA 10-year study conducted by the American Heart Association provided data on how age, blood pressure, and smoking related to the risk of strokes. The data file “Stroke.xslx” includes a portion of the data from the study. The variable “Risk of Stroke” is measured as the percentage of risk (proportion times 100) that a person will have a stroke over the next 10-year period. Regression Analysis As Image: 1) Based on the simple regression analysis output, write the estimated regression equation. 2) What is the correlation coefficient between Risk of Stroke and Age? How do you find iarrow_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
- 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_forwardExcel file: https://drive.google.com/file/d/1TQG5r2wzLGk--75whZXyb0SDTHZTWS0S/view?usp=sharingarrow_forwardPlease helparrow_forward
- What is Instrumental Variables Regression?arrow_forwardCOmpare 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_forwardDescribe about how to place a regression line?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