Using the IEA IDB Analyzer
This presentation is the property of its rightful owner.
Sponsored Links
1 / 52

Using the IEA IDB Analyzer Correlations & Regression PowerPoint PPT Presentation


  • 64 Views
  • Uploaded on
  • Presentation posted in: General

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 Presentation

Using the IEA IDB Analyzer Correlations & Regression

An Image/Link below is provided (as is) to download presentation

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.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Using the iea idb analyzer correlations regression

Using the IEA IDB Analyzer

Correlations & Regression


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

    • Compare SPSS Output and International Report

    • Output in MS Excel

  • Hands-On Training


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

    • Compare SPSS Output and International Report

    • Output in MS Excel

  • Hands-On Training


Using the iea idb analyzer correlations regression

Calculating Correlations

  • Choose variable(s) to be analyzed

  • Load the SPSS Analysis File

  • Choose Correlations as analysis type (some settings will be done automatically with respect to the datafile and the analysis method chosen)

  • Select Variables from the datafile to be analyzed as Analysis Variables

  • Define location and name of the Output Files

  • Start SPSS and run analysis


Using the iea idb analyzer correlations regression

Select Variable of Interest

Student Questionnaire, Q14A-F, p. 13

Variables of Interest: PARTCOM PVCIV01-05


Using the iea idb analyzer correlations regression

The Analysis File

  • The analysis file needs to be loaded from the respective directory

  • Countries in the example analysis file:

    • Austria

    • Belgium (Flemish)

    • Bulgaria

    • Denmark

    • England

    • Estonia

    • Finland


Using the iea idb analyzer correlations regression

Correlations - Preparation

  • Select Analysis File:C:\ICCS2009\Work\ICG_ISG_INTC2.sav

  • Select Analysis Type: Correlations

  • Select Analysis Variables:PARTCOM(Students’ civic participation in the wider community)

  • Select Achievement Variables:PVICIV01-05 (Table 5.09 from ICCS2009 International report, first column)


Using the iea idb analyzer correlations regression

Correlations - Details

Select Analysis FileC:\ICCS2009\Work\ICG_ISG_INTC2.sav


Using the iea idb analyzer correlations regression

Correlations - Details

1) Select Correlations 2) Check Exclude Missing from Analysis 3) Check With Achievement Scores


Using the iea idb analyzer correlations regression

Correlations - Details

IDCNTRY

TOTWGTS

JKZONES


Using the iea idb analyzer correlations regression

Correlations - Details

Search for PARTCOM


Using the iea idb analyzer correlations regression

Correlations - Details

Search results will be displayed


Using the iea idb analyzer correlations regression

Correlations - Details

Highlight variable

Use arrow key to add variable to analysis


Using the iea idb analyzer correlations regression

Correlations - Details


Using the iea idb analyzer correlations regression

Correlations - Details

Highlight variable

Use arrow key to add variable to analysis


Using the iea idb analyzer correlations regression

Correlations - Details

Define path and filename for output:“C:\ICCS2009\Work\Table_5_09.*”

Change number of decimals to “1”


Correlations details

Correlations - Details

  • The IDB Analyzer creates SPSS Syntax and starts SPSS

  • In SPSS Syntax Editor Choose: Run > All


Correlations outcome

Correlations - Outcome

  • As a result the IDB Analyzer creates the following in the working directory (C:\ICCS2009\Work\):

    • SPSS Syntax file – contains the syntax with the commands (*.sps)

    • SPSS Data file – contains statistics from the analysis (*.sav)

    • MS Excel Output file – contains statistics from the analysis (*.xls)


Using the iea idb analyzer correlations regression

Correlations – SPSS Output


Using the iea idb analyzer correlations regression

Correlations – Excel Output


Using the iea idb analyzer correlations regression

Correlations – Excel Output

Achievement Scores

Mean Achievement

List of Countries

Sum of Weights

S.E. of Mean Achievement


Using the iea idb analyzer correlations regression

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


Using the iea idb analyzer correlations regression

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


Using the iea idb analyzer correlations regression

Correlations – Excel Output

Correlation of variable 1 with variable 2(here: Achievement with Participation in Community)

S.E. of Correlation


Using the iea idb analyzer correlations regression

Correlations – Excel Output


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

    • Compare SPSS Output and International Report

    • Output in MS Excel

  • Hands-On Training


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

    • Compare SPSS Output and International Report

    • Output in MS Excel

  • Hands-On Training


Using the iea idb analyzer correlations regression

Linear Regression Model


Linear regression model

Linear Regression Model

  • yis the dependent variable – here: estimated mean of all 5 plausible values

  • x is the independent variable

  • ß0is the intercept (value of ywhen x is zero)

  • ß1 is the slope (change in yfor each unit increase in x)

x

=

+

×

y

β

β

0

1


Computing regression

Computing Regression

  • Can be used to calculate regression coefficients and their (jackknifed) standard errors for the ICCS background variables

  • Uses the jackknifing procedure and therefore considers the sampling method used in ICCS

  • Makes use of the variables JKZONE and JKREP


Using the iea idb analyzer correlations regression

Computing Regression

  • Choose variable to be analyzed

  • Load the SPSS Analysis File

  • Choose Regression as analysis type (some settings will be done automatically)

  • Select Variables from the datafile to be analyzed as Analysis Variable AND/OR Select the plausible values as Achievement Scores

  • Define location and name of the Output Files

  • Start SPSS and run analysis


Recoding variables

Recoding variables

  • Some tables might display data differently than in the data files

  • E.g., table 7.1 has been calculated using dummy recoded information of the students‘ immigration background (variable name in the datafile is IMMIG)

  • For replication of the table, the information from the variable IMMIG needs to be recoded in SPSS and added as a new variable to the datafile before running the analysis


Dummy coding for regression

Dummy Coding for Regression

IMMIG  Reg01IMMIG


Dummy coding for regression1

Dummy Coding for Regression

  • IMMIG values:

0

1

1

System Missing


Using the iea idb analyzer correlations regression

SPSS: Dummy Coding for Regression

Menu: TRANSFORM  Recode into Different Variables...


Using the iea idb analyzer correlations regression

SPSS: Dummy Coding for Regression

Menu: TRANSFORM  Recode into Different Variables...

1  0

2  1

3  1

ELSE  SYSMISS


Linear regression model1

Linear Regression Model

Predictor variable: Reg01IMMIG

x

=

+

×

y

β

β

0

1

Mean achievement for native students

Difference between mean achieve-ment of native and mean achieve-ment of non-native students


Using the iea idb analyzer correlations regression

The Analysis File

  • The analysis file needs to be loaded from the respective directory

  • Countries in the example analysis file:

    • Austria

    • Belgium (Flemish)

    • Bulgaria

    • Denmark

    • England

    • Estonia

    • Finland


Computing regression1

Computing Regression

  • Select data file:C:\ICCS2009\Work\ICG_ISG_INTC2_Reg.sav

  • Analysis Type:Regression

  • Grouping Variable:IDCNTRY

  • Analysis Variable:Reg01IMMIG

  • Achievement Scores:PVICIV01-05 (Table 7.1, first column from ICCS2009 International report)


Regression details

Regression - Details

C:\ICCS2009\Work\ICG_ISG_INTC2.sav

1) Select Regression2) Check Exclude Missing from Analysis3) Check With Achievement Scores

IDCNTRY

Reg01IMMIG

PVICIV01-05

Change the number of decimals to 2

TOTWGTS

JKZONES

C:\ICCS2009\Work\Table_7_1.*


Regression details1

Regression - Details

  • The IDB Analyzer creates SPSS Syntax and starts SPSS

  • In SPSS Syntax Editor Choose: Run > All


Regression outcome

Regression - Outcome

  • As a result IDB Analyzer creates the following in the working directory (C:\ICCS2009\Work):

    • SPSS Syntax file – contains the syntax with the commands

    • SPSS Data file – contains statistics from the analysis

    • MS Excel Output file – contains statistics from the analysis


Regression spss output

Regression – SPSS Output

Number of Cases

S.E. of Intercept

Multiple R-Squared

Intercept: Mean Achievement of Native Students


Regression spss output1

Regression – SPSS Output

Estimate of Regression Coefficient

S.E. of Regression Coefficient

T-Statistics of Regression Coefficient


Regression spss output2

Regression – SPSS Output

ABS (-1.3) < 1.96

In Bulgaria the difference in civic knowledge between native students and non-native students is NOT significant.


Regression spss output3

Regression – SPSS Output

ABS (-8.9) > 1.96

In Austria the difference in civic knowledge between native students and non-native students IS significant.


Regression spss output4

Regression – SPSS Output

Differences in Draft Table 7.1 of Int. Report are incorrect


Regression spss output5

Regression – SPSS Output

x

=

-

516,2

×

y

56,6

Predictor variable: Reg01IMMIG

Mean achievement for native students

Difference between mean achieve-ment of native and mean achieve-ment of non-native students


Using the iea idb analyzer correlations regression

Thank you for your attention!

Any Questions?


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

    • Compare SPSS Output and International Report

    • Output in MS Excel

  • Hands-On Training


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

    • Compare SPSS Output and International Report

    • Output in MS Excel

  • Hands-On Training


Using the iea idb analyzer correlations regression

Hands-On Training

  • Re-produce the example using your country data- Correlation of students’ participation in the wider community with civic and citizenship achievement (PVCIV01-05 with PARTCOM)

    and/or

  • Re-produce the example using your country data- Regression of students’ immigration status on civic and citizenship achievement of (IMMIG [recoded] on PVCIV01-05)

    and/or

  • Practice with own selected variables following these analysis steps


  • Login