Tenemos la siguiente base de datos clínica donde se ha estudiado la influencia de sexo, edad y diferentes comorbilidades en la recidiva de una Endocarditis antes de los tres años en pacientes que tuvieron un primer diagnóstico de Endocarditis.
Las variables son las siguientes:
P: Paciente
S: Sexo (1=Mujer; 2=Hombre)
E: Edad
D: Diabetes
H: Hipertensión
C: Enfermedad coronaria
R1: Al menos una de las tres enfermedades anteriores
CH: Charlson (Medida del grado de comorbilidades del paciente)
RE: Recidiva de una Endocarditis después de tres años de la primera
(En las variables con 0 y 1, 0 es la etiqueta de NO y 1 es la etiqueta de SÍ)
La base de datos es la siguiente:
P | S | E | D | H | C | R1 | CH | RE |
1 | 1 | 78 | 1 | 1 | 0 | 1 | 8 | 1 |
2 | 1 | 50 | 0 | 0 | 0 | 0 | 1 | 0 |
3 | 1 | 69 | 0 | 1 | 0 | 1 | 5 | 0 |
4 | 1 | 55 | 1 | 0 | 1 | 1 | 5 | 0 |
5 | 2 | 77 | 0 | 0 | 1 | 1 | 6 | 1 |
6 | 2 | 59 | 0 | 1 | 0 | 1 | 1 | 1 |
7 | 2 | 52 | 1 | 1 | 0 | 1 | 1 | 1 |
8 | 2 | 70 | 1 | 0 | 0 | 1 | 6 | 0 |
9 | 2 | 77 | 0 | 0 | 1 | 1 | 6 | 0 |
10 | 1 | 67 | 0 | 1 | 0 | 1 | 5 | 0 |
11 | 1 | 66 | 1 | 1 | 0 | 1 | 5 | 0 |
12 | 1 | 69 | 1 | 1 | 0 | 1 | 5 | 0 |
13 | 2 | 45 | 0 | 0 | 0 | 0 | 0 | 0 |
14 | 2 | 60 | 0 | 0 | 0 | 0 | 5 | 0 |
15 | 1 | 70 | 1 | 0 | 0 | 1 | 6 | 0 |
16 | 1 | 77 | 0 | 0 | 1 | 1 | 6 | 0 |
17 | 2 | 67 | 0 | 1 | 0 | 1 | 5 | 0 |
18 | 2 | 66 | 1 | 1 | 0 | 1 | 5 | 0 |
19 | 2 | 69 | 1 | 1 | 0 | 1 | 5 | 0 |
20 | 2 | 45 | 0 | 0 | 0 | 0 | 0 | 0 |
21 | 2 | 58 | 0 | 0 | 0 | 0 | 5 | 0 |
22 | 1 | 58 | 0 | 1 | 1 | 1 | 1 | 1 |
23 | 1 | 71 | 0 | 1 | 1 | 1 | 6 | 1 |
24 | 1 | 61 | 0 | 0 | 0 | 0 | 5 | 0 |
25 | 2 | 72 | 1 | 1 | 1 | 1 | 6 | 0 |
26 | 2 | 71 | 1 | 1 | 0 | 1 | 6 | 0 |
27 | 2 | 61 | 0 | 0 | 0 | 0 | 5 | 0 |
28 | 2 | 51 | 0 | 0 | 0 | 0 | 0 | 0 |
29 | 2 | 76 | 1 | 1 | 1 | 1 | 6 | 0 |
30 | 1 | 62 | 1 | 1 | 0 | 1 | 5 | 0 |
31 | 1 | 53 | 0 | 0 | 0 | 0 | 0 | 0 |
32 | 1 | 57 | 0 | 0 | 0 | 0 | 0 | 0 |
33 | 2 | 59 | 1 | 1 | 0 | 1 | 0 | 0 |
34 | 2 | 50 | 0 | 0 | 0 | 0 | 1 | 1 |
35 | 1 | 54 | 0 | 0 | 1 | 1 | 1 | 1 |
36 | 1 | 56 | 1 | 1 | 1 | 1 | 0 | 1 |
37 | 2 | 66 | 0 | 0 | 0 | 0 | 5 | 0 |
38 | 2 | 61 | 0 | 0 | 0 | 0 | 5 | 0 |
39 | 2 | 53 | 1 | 1 | 0 | 1 | 1 | 0 |
40 | 2 | 78 | 1 | 0 | 0 | 1 | 6 | 0 |
41 | 2 | 59 | 0 | 1 | 0 | 1 | 1 | 0 |
42 | 1 | 66 | 0 | 1 | 1 | 1 | 5 | 1 |
43 | 1 | 65 | 1 | 0 | 1 | 1 | 5 | 1 |
44 | 1 | 66 | 1 | 0 | 0 | 1 | 5 | 1 |
45 | 2 | 52 | 0 | 1 | 0 | 1 | 1 | 0 |
46 | 2 | 56 | 0 | 0 | 0 | 0 | 1 | 0 |
47 | 1 | 67 | 1 | 0 | 1 | 1 | 5 | 0 |
48 | 1 | 52 | 0 | 1 | 0 | 1 | 1 | 0 |
49 | 2 | 78 | 0 | 1 | 0 | 1 | 6 | 0 |
50 | 2 | 62 | 1 | 0 | 0 | 1 | 5 | 0 |
51 | 2 | 68 | 0 | 0 | 1 | 1 | 5 | 0 |
52 | 2 | 76 | 0 | 1 | 0 | 1 | 6 | 1 |
53 | 2 | 62 | 0 | 0 | 0 | 0 | 5 | 0 |
54 | 1 | 58 | 1 | 0 | 0 | 1 | 1 | 1 |
55 | 1 | 71 | 0 | 1 | 1 | 1 | 6 | 1 |
56 | 2 | 61 | 0 | 0 | 0 | 0 | 5 | 0 |
57 | 2 | 70 | 1 | 0 | 0 | 1 | 6 | 1 |
58 | 2 | 53 | 0 | 0 | 0 | 0 | 1 | 1 |
59 | 2 | 67 | 0 | 1 | 0 | 1 | 5 | 1 |
60 | 2 | 53 | 0 | 0 | 0 | 0 | 1 | 1 |
61 | 1 | 69 | 1 | 1 | 0 | 1 | 5 | 1 |
62 | 1 | 45 | 0 | 0 | 0 | 0 | 0 | 0 |
63 | 1 | 62 | 0 | 0 | 1 | 1 | 5 | 0 |
64 | 2 | 72 | 1 | 1 | 1 | 1 | 6 | 0 |
65 | 2 | 71 | 1 | 1 | 0 | 1 | 6 | 0 |
66 | 2 | 61 | 0 | 0 | 0 | 0 | 5 | 0 |
67 | 2 | 51 | 0 | 0 | 0 | 0 | 0 | 0 |
68 | 2 | 76 | 1 | 1 | 1 | 1 | 6 | 0 |
69 | 1 | 62 | 1 | 1 | 0 | 1 | 5 | 0 |
70 | 1 | 53 | 0 | 0 | 0 | 0 | 0 | 0 |
71 | 1 | 57 | 0 | 0 | 0 | 0 | 0 | 0 |
72 | 1 | 59 | 1 | 1 | 0 | 1 | 0 | 0 |
73 | 2 | 50 | 0 | 0 | 0 | 0 | 1 | 1 |
74 | 2 | 54 | 0 | 0 | 1 | 1 | 1 | 1 |
75 | 2 | 56 | 1 | 1 | 1 | 1 | 0 | 1 |
76 | 2 | 66 | 0 | 0 | 0 | 0 | 5 | 0 |
77 | 2 | 61 | 0 | 0 | 0 | 0 | 5 | 0 |
78 | 1 | 53 | 1 | 1 | 0 | 1 | 1 | 0 |
79 | 1 | 68 | 1 | 0 | 1 | 1 | 5 | 0 |
80 | 2 | 66 | 0 | 1 | 1 | 1 | 5 | 0 |
81 | 2 | 70 | 0 | 1 | 0 | 1 | 5 | 1 |
82 | 2 | 80 | 1 | 0 | 0 | 1 | 8 | 1 |
83 | 2 | 71 | 0 | 1 | 1 | 1 | 6 | 1 |
84 | 2 | 61 | 0 | 0 | 0 | 0 | 5 | 0 |
85 | 1 | 70 | 1 | 0 | 0 | 1 | 6 | 1 |
86 | 2 | 53 | 0 | 0 | 0 | 0 | 1 | 1 |
87 | 2 | 67 | 0 | 1 | 0 | 1 | 5 | 1 |
88 | 2 | 80 | 0 | 0 | 0 | 0 | 6 | 1 |
89 | 1 | 69 | 1 | 1 | 0 | 1 | 5 | 1 |
90 | 2 | 45 | 0 | 0 | 0 | 0 | 0 | 0 |
91 | 2 | 62 | 0 | 0 | 1 | 1 | 5 | 0 |
92 | 2 | 72 | 1 | 1 | 1 | 1 | 6 | 0 |
93 | 2 | 71 | 1 | 1 | 0 | 1 | 6 | 0 |
94 | 2 | 61 | 0 | 0 | 0 | 0 | 5 | 0 |
95 | 1 | 51 | 0 | 0 | 0 | 0 | 0 | 0 |
96 | 1 | 76 | 1 | 1 | 1 | 1 | 6 | 0 |
97 | 2 | 62 | 1 | 1 | 0 | 1 | 5 | 0 |
98 | 1 | 53 | 0 | 0 | 0 | 0 | 0 | 0 |
99 | 1 | 57 | 0 | 0 | 0 | 0 | 0 | 0 |
100 | 2 | 59 | 1 | 1 | 0 | 1 | 0 | 0 |
101 | 2 | 50 | 0 | 0 | 0 | 0 | 1 | 1 |
102 | 1 | 54 | 0 | 0 | 1 | 1 | 1 | 1 |
103 | 1 | 56 | 1 | 1 | 1 | 1 | 0 | 1 |
104 | 2 | 66 | 0 | 0 | 0 | 0 | 5 | 0 |
105 | 2 | 61 | 0 | 0 | 0 | 0 | 5 | 0 |
106 | 2 | 53 | 1 | 1 | 0 | 1 | 1 | 0 |
107 | 1 | 89 | 1 | 0 | 0 | 1 | 8 | 0 |
108 | 2 | 77 | 1 | 1 | 0 | 1 | 7 | 0 |
109 | 2 | 69 | 0 | 1 | 0 | 1 | 6 | 0 |
110 | 1 | 54 | 0 | 0 | 0 | 0 | 1 | 0 |
111 | 2 | 68 | 1 | 0 | 1 | 1 | 5 | 0 |
112 | 2 | 66 | 0 | 1 | 1 | 1 | 5 | 0 |
113 | 1 | 61 | 0 | 1 | 0 | 1 | 5 | 1 |
114 | 1 | 69 | 1 | 0 | 0 | 1 | 4 | 1 |
115 | 2 | 77 | 1 | 0 | 0 | 1 | 6 | 1 |
116 | 2 | 59 | 0 | 1 | 0 | 1 | 1 | 0 |
117 | 2 | 53 | 0 | 0 | 0 | 0 | 1 | 0 |
118 | 1 | 85 | 1 | 0 | 1 | 1 | 10 | 0 |
119 | 1 | 59 | 0 | 1 | 1 | 1 | 1 | 0 |
120 | 2 | 62 | 0 | 1 | 0 | 1 | 5 | 0 |
121 | 1 | 88 | 1 | 0 | 1 | 1 | 10 | 0 |
122 | 1 | 59 | 0 | 1 | 1 | 1 | 1 | 0 |
123 | 2 | 62 | 0 | 1 | 0 | 1 | 5 | 0 |
124 | 2 | 68 | 0 | 0 | 1 | 1 | 5 | 0 |
125 | 2 | 58 | 0 | 0 | 0 | 0 | 1 | 0 |
126 | 2 | 61 | 0 | 1 | 0 | 1 | 5 | 0 |
127 | 2 | 83 | 0 | 0 | 0 | 0 | 9 | 0 |
128 | 1 | 57 | 1 | 0 | 0 | 1 | 1 | 0 |
129 | 1 | 59 | 0 | 1 | 0 | 1 | 1 | 0 |
130 | 1 | 59 | 0 | 1 | 1 | 1 | 1 | 0 |
131 | 1 | 77 | 1 | 0 | 1 | 1 | 6 | 0 |
132 | 1 | 57 | 1 | 0 | 0 | 1 | 1 | 0 |
133 | 2 | 59 | 1 | 1 | 0 | 1 | 2 | 0 |
134 | 2 | 50 | 0 | 1 | 0 | 1 | 1 | 0 |
135 | 1 | 54 | 0 | 0 | 0 | 0 | 1 | 0 |
136 | 2 | 68 | 1 | 0 | 1 | 1 | 5 | 0 |
137 | 2 | 66 | 0 | 1 | 1 | 1 | 5 | 0 |
138 | 1 | 61 | 0 | 1 | 0 | 1 | 5 | 1 |
139 | 1 | 82 | 1 | 0 | 0 | 1 | 1 | 1 |
140 | 2 | 77 | 1 | 0 | 0 | 1 | 6 | 1 |
141 | 2 | 59 | 0 | 1 | 0 | 1 | 1 | 0 |
142 | 2 | 53 | 0 | 0 | 0 | 0 | 1 | 0 |
143 | 1 | 85 | 1 | 0 | 1 | 1 | 10 | 0 |
144 | 1 | 59 | 0 | 1 | 1 | 1 | 1 | 0 |
145 | 2 | 62 | 0 | 1 | 0 | 1 | 5 | 0 |
146 | 1 | 85 | 1 | 0 | 1 | 1 | 10 | 0 |
147 | 1 | 78 | 0 | 1 | 1 | 1 | 1 | 0 |
148 | 2 | 62 | 0 | 1 | 0 | 1 | 5 | 0 |
149 | 2 | 88 | 0 | 0 | 1 | 1 | 7 | 0 |
150 | 2 | 58 | 0 | 0 | 0 | 0 | 1 | 0 |
151 | 2 | 61 | 0 | 1 | 0 | 1 | 5 | 0 |
152 | 2 | 83 | 0 | 0 | 0 | 0 | 9 | 0 |
153 | 1 | 57 | 1 | 0 | 0 | 1 | 1 | 0 |
154 | 2 | 59 | 0 | 1 | 0 | 1 | 1 | 0 |
155 | 1 | 59 | 0 | 1 | 1 | 1 | 2 | 0 |
156 | 2 | 77 | 1 | 0 | 1 | 1 | 6 | 0 |
157 | 1 | 59 | 1 | 0 | 0 | 1 | 1 | 0 |
158 | 1 | 80 | 0 | 0 | 0 | 0 | 7 | 0 |
159 | 2 | 60 | 0 | 0 | 0 | 0 | 5 | 0 |
160 | 2 | 77 | 1 | 1 | 0 | 1 | 6 | 0 |
161 | 1 | 71 | 1 | 0 | 1 | 1 | 6 | 0 |
162 | 1 | 61 | 0 | 1 | 0 | 1 | 5 | 1 |
163 | 2 | 51 | 0 | 0 | 0 | 0 | 1 | 0 |
164 | 1 | 66 | 1 | 0 | 0 | 1 | 5 | 1 |
165 | 2 | 62 | 0 | 1 | 1 | 1 | 5 | 0 |
166 | 1 | 53 | 0 | 0 | 0 | 0 | 1 | 0 |
167 | 1 | 57 | 1 | 0 | 0 | 1 | 1 | 0 |
168 | 2 | 78 | 1 | 1 | 0 | 1 | 4 | 0 |
169 | 2 | 69 | 0 | 1 | 0 | 1 | 2 | 0 |
170 | 1 | 54 | 0 | 0 | 0 | 0 | 1 | 0 |
171 | 2 | 58 | 0 | 0 | 0 | 0 | 1 | 0 |
172 | 2 | 61 | 0 | 1 | 0 | 1 | 5 | 0 |
173 | 2 | 83 | 0 | 0 | 0 | 0 | 9 | 0 |
174 | 1 | 57 | 1 | 0 | 0 | 1 | 1 | 0 |
175 | 2 | 58 | 0 | 0 | 0 | 0 | 1 | 0 |
176 | 2 | 61 | 0 | 1 | 0 | 1 | 5 | 0 |
177 | 2 | 83 | 0 | 0 | 0 | 0 | 9 | 0 |
178 | 1 | 57 | 1 | 0 | 0 | 1 | 1 | 0 |
179 | 2 | 58 | 0 | 0 | 0 | 0 | 1 | 0 |
180 | 2 | 61 | 0 | 1 | 0 | 1 | 5 | 0 |
181 | 2 | 90 | 0 | 0 | 0 | 0 | 9 | 0 |
182 | 1 | 57 | 1 | 0 | 0 | 1 | 1 | 0 |
183 | 2 | 77 | 0 | 1 | 0 | 1 | 3 | 0 |
184 | 2 | 76 | 0 | 1 | 1 | 1 | 4 | 0 |
185 | 2 | 77 | 1 | 0 | 1 | 1 | 6 | 0 |
186 | 1 | 59 | 1 | 0 | 0 | 1 | 1 | 0 |
187 | 1 | 80 | 0 | 0 | 0 | 0 | 7 | 0 |
188 | 2 | 60 | 0 | 0 | 0 | 0 | 5 | 0 |
189 | 2 | 77 | 1 | 1 | 0 | 1 | 8 | 0 |
190 | 1 | 71 | 1 | 0 | 1 | 1 | 6 | 0 |
191 | 1 | 61 | 0 | 1 | 0 | 1 | 5 | 1 |
192 | 2 | 51 | 0 | 0 | 0 | 0 | 1 | 0 |
193 | 2 | 66 | 1 | 0 | 0 | 1 | 5 | 1 |
194 | 2 | 82 | 0 | 1 | 1 | 1 | 5 | 0 |
195 | 1 | 53 | 0 | 0 | 0 | 0 | 1 | 0 |
196 | 1 | 57 | 1 | 0 | 0 | 1 | 1 | 0 |
197 | 2 | 77 | 1 | 1 | 0 | 1 | 5 | 0 |
198 | 2 | 78 | 0 | 1 | 0 | 1 | 6 | 0 |
199 | 1 | 54 | 0 | 0 | 0 | 0 | 1 | 0 |
200 | 1 | 87 | 1 | 0 | 0 | 1 | 8 | 0 |
- Preparar una descriptiva básica de cada una de las variables del estudio.
- Calcular la correlación entre la edad y la comorbilidad medida mediante el Charlson.
- Calcular la función lineal que nos permitiría pronosticar el Charlon sabiendo la edad de un paciente. Evalúa la calidad de este pronóstico.
- ¿Existe relación entre tener diabetes, hipertensión o enfermedad coronaria (individualmente) con recidiva de Endocarditis antes de los tres años? Si la hay calcula la Odds ratio.
- ¿Existe relación entre tener tener al menos una de las tres patologías recogidas (diabetes, hipertensión, enfermedad coronaria), que es la variable R1, con recidiva de Endocarditis antes de los tres años? Si la hay calcula la Odds ratio.
- Discutir brevemente, de forma global, los resultados que se han obtenido en los apartados 4 y 5.
- ¿Hay diferencias, estadísticamente significativa, en las medias de Edad entre los que tienen una o más de una de esas tres enfermedades y los que no tienen ninguna (variable R1)?
- Calcula la potencia de este contraste de hipótesis.
- ¿Hay diferencia estadísticamente significativas en la media del Charlson entre sexos?
- Calcula la potencia de este contraste.