Using the IEA IDB Analyzer Correlations & Regression. Table of content. Correlations Settings for the Analysis Running the Analysis Compare SPSS Output and International Report Output in MS Excel Regression Linear Regression Model Settings for the Analysis Running the Analysis
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Correlations & Regression
Student Questionnaire, Q14AF, p. 13
Variables of Interest: PARTCOM PVCIV0105
The Analysis File
Select Analysis FileC:\ICCS2009\Work\ICG_ISG_INTC2.sav
1) Select Correlations 2) Check Exclude Missing from Analysis 3) Check With Achievement Scores
Search for PARTCOM
Search results will be displayed
Define path and filename for output:“C:\ICCS2009\Work\Table_5_09.*”
Change number of decimals to “1”
Achievement Scores
Mean Achievement
List of Countries
Sum of Weights
S.E. of Mean Achievement
Correlation of PV with itself
S.E. of Correlation
Standard Deviation of Mean Achievement
S.E. of Standard Deviation of Mean Achievement
S.E. of Mean of Variable
S.E. of Standard Deviation of Mean of Variable
Variable Name of Second Variable
Mean of Variable (here: Country Mean)
Standard Deviation of Mean of Variable
Correlation of variable 1 with variable 2(here: Achievement with Participation in Community)
S.E. of Correlation
x
=
+
×
y
β
β
0
1
IMMIG Reg01IMMIG
SPSS: Dummy Coding for Regression
Menu: TRANSFORM Recode into Different Variables...
SPSS: Dummy Coding for Regression
Menu: TRANSFORM Recode into Different Variables...
1 0
2 1
3 1
ELSE SYSMISS
Predictor variable: Reg01IMMIG
x
=
+
×
y
β
β
0
1
Mean achievement for native students
Difference between mean achievement of native and mean achievement of nonnative students
The Analysis File
C:\ICCS2009\Work\ICG_ISG_INTC2.sav
1) Select Regression2) Check Exclude Missing from Analysis3) Check With Achievement Scores
IDCNTRY
Reg01IMMIG
PVICIV0105
Change the number of decimals to 2
TOTWGTS
JKZONES
C:\ICCS2009\Work\Table_7_1.*
Number of Cases
S.E. of Intercept
Multiple RSquared
Intercept: Mean Achievement of Native Students
Estimate of Regression Coefficient
S.E. of Regression Coefficient
TStatistics of Regression Coefficient
ABS (1.3) < 1.96
In Bulgaria the difference in civic knowledge between native students and nonnative students is NOT significant.
ABS (8.9) > 1.96
In Austria the difference in civic knowledge between native students and nonnative students IS significant.
Differences in Draft Table 7.1 of Int. Report are incorrect
x
=

516,2
×
y
56,6
Predictor variable: Reg01IMMIG
Mean achievement for native students
Difference between mean achievement of native and mean achievement of nonnative students
Any Questions?
and/or
and/or