Estocastica proyecto1111
9
Paso 1 Pilotos (i) Jenson Button Pastor Maldonad Romain Grosjean Charles Pic Fernando Alonso Sergio Perez Daniel Ricciard Heikki Kovalain Michael Schumac Nico Hulkenberg Paul Di Esta j Bruno Senna 0 1 0 0 0 0 1 0 0 0 0 Charles Pic 0 1 0 0 0 0 0 1 0 0 0 Daniel Ricciardo 0 0 0 1 0 0 0 1 0 0 0 Felipe Masa 1 0 0 0 1 0 0 0 0 0 1 Fernando Alonso 1 0 0 0 0 0 0 0 0 0 1 Heikki Kovalainen 0 1 0 1 0 0 1 0 0 0 0 Jean Eric - Vergne 0 0 0 0 0 0 1 0 0 0 0 Jenson Button 0 0 1 0 1 0 0 0 1 0 1 Kamiu Kobayashi 1 0 1 0 0 0 0 0 1 0 0 kimmi Raikkonen 0 0 1 0 0 0 0 0 1 1 1 Lewis Hamilton 1 0 0 0 0 0 0 0 1 0 1 Mark Webber 0 0 1 0 0 0 0 0 1 0 0 Michael Schumacher 1 0 0 0 1 0 0 0 0 1 1 Narain Karthikeyan 0 0 0 0 0 0 0 0 0 0 0 Nico Hulkenberg 0 0 0 0 1 0 0 0 1 0 1 Nico Rosberg 1 0 1 0 0 0 0 0 1 1 0 Pastor Maldonado 0 0 0 1 0 0 0 1 0 0 0 Paul Di Esta 0 0 0 0 1 0 0 0 1 1 0 Pedro de la Rosa 0 0 0 0 0 0 0 0 0 0 0 Romain Grosjean 1 0 0 0 0 0 0 0 0 0 0 Sebastian Vettel 1 0 0 0 1 0 0 0 1 1 1 Sergio Perez 0 0 0 0 0 0 0 0 0 0 0 Timo Glock 0 0 0 1 0 0 0 0 0 0 0 Vitalv Petrov 0 0 0 0 0 0 0 1 0 0 0 8 3 5 4 6 0 3 4 9 5 8 ### ### ### ### ### ### ### ### ### ### ### ΣP 1 1 1 1 1 0 1 1 1 1 1 Mi Pij
-
Upload
sandra-milena-gomez-leon -
Category
Documents
-
view
213 -
download
0
description
excel de estocastica
Transcript of Estocastica proyecto1111
Paso 1
Pilotos (i)
Jens
on B
utto
n
Pas
tor
Mal
dona
do
Rom
ain
Gro
sjea
n
Cha
rles
Pic
Fer
nand
o A
lons
o
Ser
gio
Per
ez
Dan
iel R
icci
ardo
Hei
kki K
oval
aine
n
Mic
hael
Sch
umac
her
Nic
o H
ulke
nber
g
Pau
l Di E
sta
Vita
lv P
etro
v
Bru
no S
enna
Jean
Eric
- V
ergn
e
jBruno Senna 0 1 0 0 0 0 1 0 0 0 0 1 0 1Charles Pic 0 1 0 0 0 0 0 1 0 0 0 1 0 1Daniel Ricciardo 0 0 0 1 0 0 0 1 0 0 0 0 1 1Felipe Masa 1 0 0 0 1 0 0 0 0 0 1 0 0 0Fernando Alonso 1 0 0 0 0 0 0 0 0 0 1 0 0 0Heikki Kovalainen 0 1 0 1 0 0 1 0 0 0 0 1 0 0Jean Eric - Vergne 0 0 0 0 0 0 1 0 0 0 0 0 1 0Jenson Button 0 0 1 0 1 0 0 0 1 0 1 0 0 0Kamiu Kobayashi 1 0 1 0 0 0 0 0 1 0 0 0 0 0kimmi Raikkonen 0 0 1 0 0 0 0 0 1 1 1 0 0 0Lewis Hamilton 1 0 0 0 0 0 0 0 1 0 1 0 0 0Mark Webber 0 0 1 0 0 0 0 0 1 0 0 0 0 0Michael Schumacher 1 0 0 0 1 0 0 0 0 1 1 0 0 0Narain Karthikeyan 0 0 0 0 0 0 0 0 0 0 0 0 0 0Nico Hulkenberg 0 0 0 0 1 0 0 0 1 0 1 0 0 0Nico Rosberg 1 0 1 0 0 0 0 0 1 1 0 0 0 0Pastor Maldonado 0 0 0 1 0 0 0 1 0 0 0 0 1 0Paul Di Esta 0 0 0 0 1 0 0 0 1 1 0 0 0 0Pedro de la Rosa 0 0 0 0 0 0 0 0 0 0 0 0 0 1Romain Grosjean 1 0 0 0 0 0 0 0 0 0 0 0 0 0Sebastian Vettel 1 0 0 0 1 0 0 0 1 1 1 0 0 0Sergio Perez 0 0 0 0 0 0 0 0 0 0 0 0 1 0Timo Glock 0 0 0 1 0 0 0 0 0 0 0 0 0 0Vitalv Petrov 0 0 0 0 0 0 0 1 0 0 0 0 1 0
8 3 5 4 6 0 3 4 9 5 8 3 5 4
0.13 0.33 0.20 0.25 0.17 0.00 0.33 0.25 0.11 0.20 0.13 0.33 0.20 0.25
ΣP 1 1 1 1 1 0 1 1 1 1 1 1 1 1
MiPij
Paso 1ki
mm
i Rai
kkon
en
Lew
is H
amilt
on
Nar
ain
Kar
thik
eyan
Seb
astia
n V
ette
l
Mar
k W
ebbe
r
Fel
ipe
Mas
a
Kam
iu K
obay
ashi
Nic
o R
osbe
rg
Ped
ro d
e la
Ros
a
Tim
o G
lock
Pilotos (i)0 0 0 0 0 0 0 0 0 1 1 Michael Schumacher 90 0 0 0 0 0 0 0 0 1 2 Sebastian Vettel 90 0 1 0 0 0 0 0 0 1 3 kimmi Raikkonen 81 1 0 0 1 0 0 1 0 0 4 Jenson Button 81 0 0 1 0 1 0 0 0 0 5 Lewis Hamilton 80 0 1 0 0 0 0 0 1 1 6 Paul Di Esta 80 0 0 0 0 0 0 0 1 1 7 Timo Glock 80 1 0 1 0 0 1 0 0 0 8 Kamiu Kobayashi 70 1 0 1 1 1 0 0 0 0 9 Mark Webber 70 0 0 1 1 1 0 1 0 0 10 Felipe Masa 61 0 0 0 0 1 1 0 0 0 11 Nico Rosberg 61 1 0 1 0 0 1 1 0 0 12 Fernando Alonso 61 1 0 1 1 1 1 1 0 0 13 Nico Hulkenberg 50 0 0 0 0 0 0 0 1 0 14 Bruno Senna 51 1 0 1 0 1 0 1 0 0 15 Romain Grosjean 50 1 0 0 1 0 0 0 0 0 16 Heikki Kovalainen 40 0 1 0 0 0 0 0 0 1 17 Charles Pic 40 1 1 1 0 0 0 0 0 0 18 Jean Eric - Vergne 40 0 0 0 0 0 0 0 0 0 19 Narain Karthikeyan 41 0 0 1 1 0 1 0 0 0 20 Pedro de la Rosa 41 0 0 0 1 0 1 1 0 0 21 Daniel Ricciardo 30 0 0 0 0 0 1 0 1 1 22 Pastor Maldonado 30 0 0 0 0 0 0 0 0 0 23 Vitalv Petrov 30 0 0 0 0 0 0 0 0 1 24 Sergio Perez 0
8 8 4 9 7 6 7 6 4 8
0.13 0.13 0.25 0.11 0.14 0.17 0.14 0.17 0.25 0.13
1 1 1 1 1 1 1 1 1 1
Estos 2 pilotos tienen en común los mismos amigos pero No son amigos entre ellos
Paso 2
Listado de los pilotos con sus amigos indirectos.
Se puede evidenciar dos grupos bien diferenciados los cuales en ningún momento se unen porque aunque ambos tienen como amigo común a SP, a este usuario, todavía no le dan un click en ningún hipervínculo o
enlace, por lo cual no se unieron estos dos grupos.1. G1: BS, SP, PM, DR, JV, VP, HK, CP, TG, PR, NK.
2. G2: FA, SV, JB, FM, MS, PdR, NHu, LH, KR, KK, NR, RG, MW, SP.
· PASTOR MALDONADO (PM) - Amigos (SP, DR, JV, VP)· BRUNO SENNA (BS) - Amigos (HK, PR, CP) · CHARLES PIC (CP) ) - Amigos (JV, BS, VP, SP)· DANIEL RICCIARDO (DR) - Amigos (PR, CP, SP,PM,VP)· FERNANDO ALONSO (FA) - Amigos (MW, KR, RG, KK,SV, LH,NR)· FELIPE MASSA (FM) - Amigos (MW, JB, NR, PdR, SV, RG, SP)· HEIKKI KOVALAINEN (HK) - Amigos (JV, BS,TG)· JENSON BUTTON (JB) - Amigos (MW, KR, PdR, NHu, SP)· JEAN-ERIC VERGNE (JV) - Amigos (HK, SP, PM, VP, NK, TG)· KAMUI KOBAYASHI (KK) - Amigos (FA, KR, PdR, NHu, FM,NR)· KIMI RAIKKONEN (KR) - Amigos (KR, JB, PdR, KK, NR)· LEWIS HAMILTON (LH) - Amigos (SV, KR, RG, FA, SP)· MICHAEL SCHUMACHER (MS) - Amigos (FA, RG, FM, NR, KR, SP)· MARK WEBBER (MW) - Amigos (JB, FA, PdR, NHu, LH, JB, SP)· NICO HULKENBERG (NHu) - Amigos (MW, JB, FA, RG, KK, LH, FM)· NARAIN KARTHIKEYAN (NK) - Amigos (JV, BS, VP, CP, SP)· NICO ROSBERG (NR) - Amigos (JB, FA, RG, PdR, KK, LH, JB)· PAUL DI RESTA (PdR) - Amigos (MW, RG, KK, NR)· PEDRO DE LA ROSA (PR) - Amigos (DR, BS, CP, PM, VP,CP)· ROMAIN GROSJEAN (RG) - Amigos (SV, FM, MS, LH, FA, NHu, SP)· SERGIO PEREZ (SP) - Amigos ( )· SEBASTIAN VETTEL (SV) - Amigos (FM, NR, LH, SP)· TIMO GLOCK (TG) - Amigos (PR)· VITALY PETROV (VP) - Amigos (SP, DR, JV, PM, TG)
Paso 3
Pilotos (i)
Jens
on B
utto
n
Pas
tor
Mal
dona
do
Rom
ain
Gro
sjea
n
Cha
rles
Pic
Fer
nand
o A
lons
o
Ser
gio
Per
ez
Dan
iel R
icci
ardo
Hei
kki K
oval
aine
n
Mic
hael
Sch
umac
her
Nic
o H
ulke
nber
g
Pau
l Di E
sta
Vita
lv P
etro
v
Bru
no S
enna
jBruno Senna 0 0.33 0 0 0 0 0.33 0 0 0 0 0.33 0Charles Pic 0 0.33 0 0 0 0 0 0.25 0 0 0 0.33 0Daniel Ricciardo 0 0 0 0.25 0 0 0 0.25 0 0 0 0 0.20Felipe Masa 0.125 0 0 0 0.17 0 0 0 0 0 0.13 0 0Fernando Alonso 0.125 0 0 0 0 0 0 0 0 0 0.13 0 0Heikki Kovalainen 0 0.33 0 0.25 0 0 0.33 0 0 0 0 0.33 0Jean Eric - Vergne 0 0 0 0 0 0 0.33 0 0 0 0 0 0.20Jenson Button 0 0 0.20 0 0.17 0 0 0 0.11 0 0.13 0 0Kamiu Kobayashi 0.125 0 0.20 0 0 0 0 0 0.11 0 0 0 0kimmi Raikkonen 0 0 0.20 0 0 0 0 0 0.11 0.20 0.13 0 0Lewis Hamilton 0.125 0 0 0 0 0 0 0 0.11 0 0.13 0 0Mark Webber 0 0 0.20 0 0 0 0 0 0.11 0 0 0 0Michael Schumacher 0.125 0 0 0 0.17 0 0 0 0 0.20 0.13 0 0Narain Karthikeyan 0 0 0 0 0 0 0 0 0 0 0 0 0Nico Hulkenberg 0 0 0 0 0.17 0 0 0 0.11 0 0.13 0 0Nico Rosberg 0.125 0 0.20 0 0 0 0 0 0.11 0.20 0 0 0Pastor Maldonado 0 0 0 0.25 0 0 0 0.25 0 0 0 0 0.20Paul Di Esta 0 0 0 0 0.17 0 0 0 0.11 0.20 0 0 0Pedro de la Rosa 0 0 0 0 0 0 0 0 0 0 0 0 0Romain Grosjean 0.125 0 0 0 0 0 0 0 0 0 0 0 0Sebastian Vettel 0.125 0 0 0 0.17 0 0 0 0.11 0.20 0.13 0 0Sergio Perez 0 0 0 0 0 0 0 0 0 0 0 0 0.20Timo Glock 0 0 0 0.25 0 0 0 0 0 0 0 0 0Vitalv Petrov 0 0 0 0 0 0 0 0.25 0 0 0 0 0.20
ΣP 1 1 1 1 1 1 1 1 1 1 1 1 1
Paso 3Je
an E
ric -
Ver
gne
kim
mi R
aikk
onen
Lew
is H
amilt
on
Nar
ain
Kar
thik
eyan
Seb
astia
n V
ette
l
Mar
k W
ebbe
r
Fel
ipe
Mas
a
Kam
iu K
obay
ashi
Nic
o R
osbe
rg
Ped
ro d
e la
Ros
a
Tim
o G
lock
0.25 0 0 0 0 0 0 0 0 0 0.130.25 0 0 0 0 0 0 0 0 0 0.130.25 0 0 0.25 0 0 0 0 0 0 0.130 0.13 0.13 0 0 0.14 0 0 0.17 0 00 0.13 0 0 0.11 0 0.17 0 0 0 00 0 0 0.25 0 0 0 0 0 0.25 0.130 0 0 0 0 0 0 0 0 0.25 0.130 0 0.13 0 0.11 0 0 0.14 0 0 00 0 0.13 0 0.11 0.14 0.17 0 0 0 00 0 0 0 0.11 0.14 0.17 0 0.17 0 00 0.13 0 0 0 0 0.17 0.14 0 0 00 0.13 0.13 0 0.11 0 0 0.14 0.17 0 00 0.13 0.13 0 0.11 0.14 0.17 0.14 0.17 0 00 0 0 0 0 0 0 0 0 0.25 00 0.13 0.13 0 0.11 0 0.17 0 0.17 0 00 0 0.13 0 0 0.14 0 0 0 0 00 0 0 0.25 0 0 0 0 0 0 0.130 0 0.13 0.25 0.11 0 0 0 0 0 00.25 0 0 0 0 0 0 0 0 0 00 0.13 0 0 0.11 0.14 0 0.14 0 0 00 0.13 0 0 0 0.14 0 0.14 0.17 0 00 0 0 0 0 0 0 0.14 0 0.25 0.130 0 0 0 0 0 0 0 0 0 00 0 0 0 0 0 0 0 0 0 0.13
1 1 1 1 1 1 1 1 1 1 1
Paso 4
Pilotos (i)
Jens
on B
utto
n
Pas
tor
Mal
dona
do
Rom
ain
Gro
sjea
n
Cha
rles
Pic
Fer
nand
o A
lons
o
Ser
gio
Per
ez
Dan
iel R
icci
ardo
Hei
kki K
oval
aine
n
Mic
hael
Sch
umac
her
Nic
o H
ulke
nber
g
Pau
l Di E
sta
Vita
lv P
etro
v
Bru
no S
enna
Jean
Eric
- V
ergn
e
kim
mi R
aikk
onen
jBruno Senna 0 0.33 0 0 0 0.04 0.33 0 0 0 0 0.33 0 0.25 0Charles Pic 0 0.33 0 0 0 0.04 0 0.25 0 0 0 0.33 0 0.25 0Daniel Ricciardo 0 0 0 0.25 0 0.04 0 0.25 0 0 0 0 0.20 0.25 0Felipe Masa 0.13 0 0 0 0.17 0.04 0 0 0 0 0.13 0 0 0 0.13Fernando Alonso 0.13 0 0 0 0 0.04 0 0 0 0 0.13 0 0 0 0.13Heikki Kovalainen 0 0.33 0 0.25 0 0.04 0.33 0 0 0 0 0.33 0 0 0Jean Eric - Vergne 0 0 0 0 0 0.04 0.33 0 0 0 0 0 0.20 0 0Jenson Button 0 0 0.20 0 0.17 0.04 0 0 0.11 0 0.13 0 0 0 0Kamiu Kobayashi 0.13 0 0.20 0 0 0.04 0 0 0.11 0 0 0 0 0 0kimmi Raikkonen 0 0 0.20 0 0 0.04 0 0 0.11 0.20 0.13 0 0 0 0Lewis Hamilton 0.13 0 0 0 0 0.04 0 0 0.11 0 0.13 0 0 0 0.13Mark Webber 0 0 0.20 0 0 0.04 0 0 0.11 0 0 0 0 0 0.13Michael Schumacher 0.13 0 0 0 0.17 0.04 0 0 0 0.20 0.13 0 0 0 0.13Narain Karthikeyan 0 0 0 0 0 0.04 0 0 0 0 0 0 0 0 0Nico Hulkenberg 0 0 0 0 0.17 0.04 0 0 0.11 0 0.13 0 0 0 0.13Nico Rosberg 0.13 0 0.20 0 0 0.04 0 0 0.11 0.20 0 0 0 0 0Pastor Maldonado 0 0 0 0.25 0 0.04 0 0.25 0 0 0 0 0.20 0 0Paul Di Esta 0 0 0 0 0.17 0.04 0 0 0.11 0.20 0 0 0 0 0Pedro de la Rosa 0 0 0 0 0 0.04 0 0 0 0 0 0 0 0.25 0Romain Grosjean 0.13 0 0 0 0 0.04 0 0 0 0 0 0 0 0 0.13Sebastian Vettel 0.13 0 0 0 0.17 0.04 0 0 0.11 0.20 0.13 0 0 0 0.13Sergio Perez 0 0 0 0 0 0.04 0 0 0 0 0 0 0.20 0 0Timo Glock 0 0 0 0.25 0 0.04 0 0 0 0 0 0 0 0 0Vitalv Petrov 0 0 0 0 0 0.04 0 0.25 0 0 0 0 0.20 0 0
8 3 5 4 6 0 3 4 9 5 8 3 5 4 8
0.13 0.33 0.20 0.25 0.17 0.00 0.33 0.25 0.11 0.20 0.13 0.33 0.20 0.25 0.13
ΣP 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Ṕ 0.15 0.33 0.21 0.26 0.19 0.04 0.33 0.26 0.14 0.21 0.15 0.33 0.21 0.26 0.15
MiPij
Paso 4Le
wis
Ham
ilton
Nar
ain
Kar
thik
eyan
Seb
astia
n V
ette
l
Mar
k W
ebbe
r
Fel
ipe
Mas
a
Kam
iu K
obay
ashi
Nic
o R
osbe
rg
Ped
ro d
e la
Ros
a
Tim
o G
lock
0 0 0 0 0 0 0 0 0.130 0 0 0 0 0 0 0 0.130 0.25 0 0 0 0 0 0 0.130.13 0 0 0.14 0 0 0.17 0 00 0 0.11 0 0.17 0 0 0 00 0.25 0 0 0 0 0 0.25 0.130 0 0 0 0 0 0 0.25 0.130.13 0 0.11 0 0 0.14 0 0 00.13 0 0.11 0.14 0.17 0 0 0 00 0 0.11 0.14 0.17 0 0.17 0 00 0 0 0 0.17 0.14 0 0 00.13 0 0.11 0 0 0.14 0.17 0 00.13 0 0.11 0.14 0.17 0.14 0.17 0 00 0 0 0 0 0 0 0.25 00.13 0 0.11 0 0.17 0 0.17 0 00.13 0 0 0.14 0 0 0 0 00 0.25 0 0 0 0 0 0 0.130.13 0.25 0.11 0 0 0 0 0 00 0 0 0 0 0 0 0 00 0 0.11 0.14 0 0.14 0 0 00 0 0 0.14 0 0.14 0.17 0 00 0 0 0 0 0.14 0 0.25 0.130 0 0 0 0 0 0 0 00 0 0 0 0 0 0 0 0.13
8 4 9 7 6 7 6 4 8
0.13 0.25 0.11 0.14 0.17 0.14 0.17 0.25 0.13
1 1 1 1 1 1 1 1 1
0.15 0.26 0.14 0.17 0.19 0.17 0.19 0.26 0.15
