Simultaneous Analysis of contingency tables drawn with telephone - - PowerPoint PPT Presentation

simultaneous analysis of contingency tables drawn with
SMART_READER_LITE
LIVE PREVIEW

Simultaneous Analysis of contingency tables drawn with telephone - - PowerPoint PPT Presentation

Simultaneous Analysis of contingency tables drawn with telephone data registration from the National Telephone Service to Support Women Suffering Violence in Uruguay Elena Gann Fundacin Plenario de Mujeres del Uruguay (PLEMUU )


slide-1
SLIDE 1

Simultaneous Analysis of contingency tables drawn with telephone data registration from the National Telephone Service to Support Women Suffering Violence in Uruguay

Elena Ganón

Fundación Plenario de Mujeres del Uruguay (PLEMUU)

ganonelena@gmail.com

International Conference on Correspondence Analysis and Related Methods

CARME 2011 Agrocampus Ouest. Rennes. France. 8 -11 February 2011

slide-2
SLIDE 2

OVERVIEW

 INTRODUCTION  NATIONAL TELEPHONE SERVICE  DATA DESCRIPTION  METHODOLOGY  APPLICATIONS  CONCLUSIONS

slide-3
SLIDE 3

INTRODUCTION

 National Telephone Service to Support Women

Suffering Violence in Uruguay

 Created in October 1992

 Organizations

  • Local Government

INTENDENCIA DE MONTEVIDEO

  • Women NGO

PLEMUU

  • Telephonic Company

ANTEL

 Multidisciplinary staff  Statistical register

slide-4
SLIDE 4

NATIONAL TELEPHONE SERVICE

100 300 500 700 900

National Telephone Service to Support Women Suffering Violence

Total phone calls

  • bserved

trend‐cycle

slide-5
SLIDE 5

DATA

 Data registration: Victim call form

 Hour (start, end), date (day, month, year), operator code,

phone-call origin (Province)

 Goal call (information, advice, emergency)  Women and aggressors characteristics:

 Sex, age, educational level, occupation

 Violence:

 Problem (Domestic Violence / Non-Domestic Violence)

  • Type (psychological, physical, economic, sexual, other)
  • Aggressor

 Modality (Treat / attack)

slide-6
SLIDE 6

DATA- Transactional table

llave_sertelmodelo_fichid_llamado fecha añol triml mesl dial diasemana hora_inicio hora_fin cod_operadora num_llamadonombr cod_demapor_qcod_objv_cod_sexov_edad 2 594 ene-2001 44 481 01/08/2001 2 001 3 8 1 4 10:50 11:00 18 1 1 3 1 62 2 595 ene-2001 44 482 01/08/2001 2 001 3 8 1 4 13:00 13:10 18 1 1 3 1 24 2 596 ene-2001 44 483 01/08/2001 2 001 3 8 1 4 13:30 13:45 35 1 silvia 1 3 1 39 2 597 ene-2001 44 487 01/08/2001 2 001 3 8 1 4 21:22 21:30 15 1 GLADI 1 3 1 43 2 598 ene-2001 44 488 01/08/2001 2 001 3 8 1 4 23:00 23:06 15 3 JAQUE 1 3 1 999 2 599 ene-2001 44 492 01/08/2001 2 001 3 8 1 4 10:08 10:14 19 1 NANCY 1 3 1 37 2 600 ene-2001 44 497 02/08/2001 2 001 3 8 2 5 13:30 13:40 16 1 Maria 1 3 1 43 2 601 ene-2001 44 498 02/08/2001 2 001 3 8 2 5 14:25 14:40 16 2 Maria d 1 3 1 999 2 603 ene-2001 44 501 02/08/2001 2 001 3 8 2 5 18:00 18:10 16 1 Jaquel 1 3 1 33 2 604 ene-2001 44 504 03/08/2001 2 001 3 8 3 6 09:53 10:01 19 1 1 3 1 999 2 605 ene-2001 44 507 03/08/2001 2 001 3 8 3 6 10:44 10:58 19 1 Gabrie 1 3 1 26 2 606 ene-2001 44 508 03/08/2001 2 001 3 8 3 6 11:21 11:27 19 1 Alejand 1 3 1 33 2 607 ene-2001 44 509 03/08/2001 2 001 3 8 3 6 11:29 11:31 19 1 Gabrie 1 2 1 21 2 608 ene-2001 44 511 03/08/2001 2 001 3 8 3 6 12:06 12:12 19 1 Silvia 1 3 1 34 2 609 ene-2001 44 512 03/08/2001 2 001 3 8 3 6 13:38 14:00 16 2 Maria B 1 3 1 28 2 610 ene-2001 44 513 03/08/2001 2 001 3 8 3 6 16:40 16:50 16 1 Maria 1 3 1 45 2 611 ene-2001 44 514 03/08/2001 2 001 3 8 3 6 20:50 21:05 21 1 Olga 1 3 1 68 2 612 ene-2001 44 515 03/08/2001 2 001 3 8 3 6 21:10 21:20 21 1 Ma del 1 3 1 38 2 613 ene-2001 44 516 03/08/2001 2 001 3 8 3 6 22:30 22:40 21 1 Maria 1 3 1 44 2 614 ene-2001 44 517 03/08/2001 2 001 3 8 3 6 22:50 23:05 21 1 Magela 1 3 1 24 2 615 ene-2001 44 518 04/08/2001 2 001 3 8 4 7 09:28 09:43 19 1 Blanca 1 3 1 70

slide-7
SLIDE 7

METHODOLOGY – INTRODUCTION DATA EXAMPLE

A7aAlt30 A7aA3039 A7aA4049 A7aA5059 A7aA6069 A7aAgt69 A8aAlt30 A8aA3039 A8aA4049 A8aA5059 A8aA6069 A8aAgt69 A9aAlt30 A9aA3039 A9aA4049 A9aA5059 A9aA6069 A9aAgt69 Vagelt30 289 178 39 16 8 3 335 193 55 34 3 4 333 209 57 27 11 2 V30age39 61 358 212 46 17 2 86 428 214 64 20 7 67 388 238 46 32 6 V40age49 65 53 265 163 30 11 69 56 309 154 30 11 78 55 291 146 30 15 V50age59 64 19 52 128 80 22 68 37 34 171 67 17 68 48 33 168 57 28 V60age69 24 23 21 21 63 29 18 30 13 23 51 30 31 35 16 20 61 32 Vagegt69 6 8 15 12 6 40 9 8 17 13 7 26 7 13 26 12 12 42

Table total A7 2449 A8 2711 A9 2740 stacked table 7900

CA separate table f i j = a i j /a i=1,6 j=1,6 f12= 178/2449 CA juxtaposed table f i j =a i j /a i=1, j=18 f12=178/7900 SA concatenated table fi j k =a i j k / a. . k f121 = 178/2449

slide-8
SLIDE 8

METHODOLOGY - CA

 Correspondence Analysis (CA)

Absolute frequencies matrix A A = (a i j) i=1,..,I; j=1,…,J

Relative frequencies matrix F F= (f i j) f i j = a i j /a a = i j a i j

Column profile {f i j/ f. j , i =1,.. I }

Distance between column profiles j , j’ d2 (j , j’)

d2 (j, j’) = 1/f i. (f i j / f .j - f i j’ /f .j’) 2

Calculation of eigenvalues and eigenvectors of X’X , X = (xi j)

x i j = √ fi. (f i j / f i. f .j – 1) √ f .j

*Juxtaposed Tables

Absolute frequencies matrix A A = (a i j k ) i=1,..,I; j=1,…,J k, k=1,...K

Relative frequencies matrix F F= (f i j k) f i j k = a i j k / a a = i j k a i j k

 Simultaneous Analysis (SA)

Absolute frequencies matrix A A = (a i j k ) i=1,..,I; j=1,…,J k, k=1,...K

Relative frequencies matrix F F= (f i j k) f i j k = a i j k / a ..k a ..k = i j a i j k

slide-9
SLIDE 9

METHODOLOGY -SA

 Simultaneous Analysis (Zárraga & Goytisolo,2002,2003)

Absolute frequencies matrix A A = (a i j k, i=1,I, j=1,J, k=1,K) a . . k =  i j a i j k

Relative frequencies matrix F F = ( fi j k, i=1,I, j=1,J, k=1,K) f i j k = a i j k / a . . k

Column profiles {f i j k/f .j k i = 1,..,I}

Distance between columns profiles d2 (j , j’)

 d2 (j, j’) = 1/f i . k (f i j k / f . j k - f i j’ k /f . j’ k) 2

Calculation of eigenvalues and eigenvectors of X’X , X = (x i j)

 x i j = √ k √ f i . k (f i j k / f i . k f . J k – 1) √ f . j k

  • Where k could be 1 , or 1/k being k the first eigenvalue of table k, or 1/ k reciprocal of total inertia

table k

 Projections on axes:

  • verall rows and columns, overall and partial rows, tables

relation between factors of separate CA and SA

slide-10
SLIDE 10

IMPLEMENTATION

 Original data: transactional table (spreadsheet,

relational data base, OLAP cube)

 individual calls * variables

 Generation of table for analysis

 contingency table or juxtaposed tables

 Use SimultAnR R-program by Zárraga&Goytisolo (2010)

 Load the R base executable module  Load the R application executable module  Read the data table with read.data command  Use SimultAnR commands to perform the analysis

slide-11
SLIDE 11

IMPLEMENTATION - commands

copy to the working directory the .txt file run the R-program load working directory load SimultAnR comands datoleido_2 <- read.table("TAVpfnd_2a5.txt",header=TRUE)

read data

datoleido_2

print on the scrren the data

dataSA<-datoleido_2

assign the data table SimAn.out <- SimAn(data=dataSA,G=4,acg=list(1:3,4:6,7:9,10:12),weight=2,nameg=c("2","3","4","5")) made the analysis

SimAnSummary(SimAn.out)

shows the results at the screen

SimAnGraph(SimAn.out)

shows the graphics at tha scrren

SimAnGraph(SimAn.out)

generate a .pdf file with graphics

pdf('SAGr.pdf',paper="a4r",width=12,height=9) SimAnGraph(SimAn.out,s1=1,s2=2,screen=FALSE) dev.off()

slide-12
SLIDE 12

APPLICATIONS

 CA of tables

 violence problem * years_2002_2009  violence problem * (age) 

* (education)

* (occupation)

 women victim age * years 2002_2009  women victim age* occupation

 Juxtaposed tables

 age * occupation * violence problem  age * education

* violence problem

 age* occupation * years

slide-13
SLIDE 13

APPLICATIONS2a

age * education * violence problem

 Simultaneous Analysis

age*education * violence problem

 separate CA

DP_prim DP_sec DP_higher DR_prim DR_sec DR_higher ND_prim ND_sec ND_higher agVvlt 30

2068 2618 302 178 353 79 24 46 9

agV30a39

2227 2945 728 208 237 55 47 43 12

agV40a49

1759 2115 599 280 363 95 47 49 15

AgVv50a59

852 853 251 305 279 96 30 28 9

agV60a69

418 217 65 274 129 43 40 14 6

agVgt69

184 57 11 211 61 12 24 7 4 inertia percentage table axis eigenvalpercentage cumulated DP 1 0.0135 58.8 58.8 2 0.0094 41.2 100.0 DR 1 0.0698 96.4 96.4 2 0.0026 3.6 100.0 ND 1 0.0618 98.2 98.2 2 0.0012 1.8 100.0

CA rows and columns projections

slide-14
SLIDE 14

APPLICATION2b

age * education * violence problem

 Simultaneous Analysis

 SA juxtaposed table  SA tables projections

table Axis 1 Axis 2 Axis 1 Axis 2 DP 0.82 0.79 0.3 0.96 DR 0.96 0.01 0.35 0.01 ND 0.96 0.03 0.35 0.04 Projections of tables Contributions of tables to SA

SA

  • verall rows and

columns

  • verall and partial rows

SA tables projections factors relation ca & sa

slide-15
SLIDE 15

SA - age * education * violence problem

slide-16
SLIDE 16
slide-17
SLIDE 17

age * education * violence problem

slide-18
SLIDE 18

APPLICATIONS3a victim age * aggressor age * years

 Simultaneous Analysis

victim age *aggressor age * years

 separate CA CA3

rows and columns projections

Year 2007 Year 2008 Year 2009 Eigenvalues and percentages of inertia Eigenvalues and percentages of inertia Eigenvalues and percentages of inertia axis values percentage cumulated axis values percentage cumulated axis values percentage cumulated 1 0.663166 55.54 55.54 1 0.6429569 54.66 54.66 1 0.6163098 54.27 54.27 2 0.3550702 29.74 85.28 2 0.3423982 29.11 83.77 2 0.3169787 27.91 82.17 3 0.1380996 11.57 96.85 3 0.1401283 11.91 95.69 3 0.1452347 12.79 94.96 4 0.0255397 2.14 98.99 4 0.0430712 3.66 99.35 4 0.0505142 4.45 99.41 5 0.0120679 1.01 100.00 5 0.0076671 0.65 100.00 5 0.0067013 0.59 100.00

A7aAlt30 A7aA3039 A7aA4049 A7aA5059 A7aA6069 A7aAgt69 A8aAlt30 A8aA3039 A8aA4049 A8aA5059 A8aA6069 A8aAgt69 A9aAlt30 A9aA3039 A9aA4049 A9aA5059 A9aA6069 A9aAgt69 Vagelt30

279 167 27 9 1 1 316 173 38 14 1 1 310 195 44 13

V30age39

31 342 200 39 6 7 58 407 202 47 6 6 40 372 231 40 14 14

V40age49

6 50 253 154 24 24 6 51 287 143 17 17 9 47 268 139 23 23

V50age59

3 3 39 122 72 72 2 6 27 142 63 66 1 10 27 158 54 55

V60age69

7 17 62 65 1 5 16 47 50 3 4 16 56 61

Vagegt69

4 16 1 5 13 2 2 6 15

slide-19
SLIDE 19

APPLICATION3b victim age * aggressor age * years

 Simultaneous Analysis

 SA juxtaposed table  SA tables projections

SA overall rows and columns

  • verall and partial rows

SA tables projections factors relation ca & sa

SA Eigenvalues and percentages of inertia axis values percentage cumulated 1 2.9949517 54.73 54.73 2 1.5802402 28.88 83.60 3 0.6543047 11.96 95.56 4 0.19576 3.58 99.14 5 0.0461208 0.84 99.98 6 0.0011909 0.02 100.00 SA Projections of Tables Tables Axis 1 Axis 2 Table Axis 1 Axis 2 2007 0.99 0.54 2007 0.33 0.34 2008 0.99 0.54 2008 0.33 0.34 2009 0.99 0.51 2009 0.33 0.32 Contribution of Years to SA

slide-20
SLIDE 20

victim age * aggressor age * years

slide-21
SLIDE 21
slide-22
SLIDE 22
slide-23
SLIDE 23

CONCLUSIONS

 Application of SA and CA to a case study

 National Telephone Service to support women victim of violence

in Uruguay

 Simultaneous Analysis (Zárraga & Goytisolo,2002,2003)

 data source: count data thorough time

  • record as August 2001 until July 2010

 principal results

  • awareness campaigns impact in
  • violence problem ( increase of DR)
  • women characteristics of women victim of violence
  • age occupation educational level
  • example housewife
slide-24
SLIDE 24

THANKS