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.
Using the IEA IDB Analyzer
Correlations & Regression
Table of content
Table of content
Calculating Correlations
Select Variable of Interest
Student Questionnaire, Q14AF, p. 13
Variables of Interest: PARTCOM PVCIV0105
The Analysis File
Correlations  Preparation
Correlations  Details
Select Analysis FileC:\ICCS2009\Work\ICG_ISG_INTC2.sav
Correlations  Details
1) Select Correlations 2) Check Exclude Missing from Analysis 3) Check With Achievement Scores
Correlations  Details
IDCNTRY
TOTWGTS
JKZONES
Correlations  Details
Search for PARTCOM
Correlations  Details
Search results will be displayed
Correlations  Details
Highlight variable
Use arrow key to add variable to analysis
Correlations  Details
Correlations  Details
Highlight variable
Use arrow key to add variable to analysis
Correlations  Details
Define path and filename for output:“C:\ICCS2009\Work\Table_5_09.*”
Change number of decimals to “1”
Correlations – SPSS Output
Correlations – Excel Output
Correlations – Excel Output
Achievement Scores
Mean Achievement
List of Countries
Sum of Weights
S.E. of Mean Achievement
Correlations – Excel Output
Correlation of PV with itself
S.E. of Correlation
Standard Deviation of Mean Achievement
S.E. of Standard Deviation of Mean Achievement
Correlations – Excel Output
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
Correlations – Excel Output
Correlation of variable 1 with variable 2(here: Achievement with Participation in Community)
S.E. of Correlation
Correlations – Excel Output
Table of content
Table of content
Linear Regression Model
x
=
+
×
y
β
β
0
1
Computing Regression
IMMIG Reg01IMMIG
0
1
1
System Missing
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
Thank you for your attention!
Any Questions?
Table of content
Table of content
HandsOn Training
and/or
and/or