288103457-Estocastica-proyecto1111.xlsx

(1)

P

Pa

a

Pilotos (i)

J J e e n n s s o o n n B B u u t t t t o o n n P P a a s s t t o o r r M M a a l l d d o o n n a a d d o o R R o o m m a a i i n n G G r r o o s s j j e e a a

n n C C h h a a r r l l e e s s P P i i c c F F e e r r n n a a n n d d o o A A l l o o n n s s o o S S e e r r g g i i o o P P e e r r e e z z D D a a n n i i e e l l R R i i c c c c i i a a r r d d o o H H e e i i k k k k i i   o o ! ! a a l l a a i i n n e e

n n M M i i c c h h a a e e l l S S c c h h u u m m a a c c h h " " i i c c o o H H u u l l k k e e n n # # e e r r g g

j

Bruno Senna

0

1

0

1

0

0 Charles Pic

Charles Pic

0

1

0

1

0

0 Daniel Ricciardo

Daniel Ricciardo

0

1

0

1

0

0 Felipe Masa

Felipe Masa

1

0

1

0

0 Fernando Alonso

Fernando Alonso

1

0

0 Heikki Kovalainen

Heikki Kovalainen

0

1

0

1

0

1

0

0 Jean Eric - 

Jean Eric - 

er!ne

0

1

0

0 Jenson Bu""on

Jenson Bu""on

0

1

0

1

0

1

0

0 Ka#iu Ko$a%ashi

Ka#iu Ko$a%ashi

1

0

1

0

1

0

0 ki##i Raikkonen

ki##i Raikkonen

0

1

0

1

1 &e'is Ha#il"on

&e'is Ha#il"on

1

0

1

0

0 Mark (e$$er

Mark (e$$er

0

1

0

1

0

0 Michael Schu#acher

Michael Schu#acher

1

0

1

0

1

1 )arain Kar"hike%an

)arain Kar"hike%an

0

0 )ico Hulken$er!

)ico Hulken$er!

0

1

0

1

0

0 )ico Ros$er!

)ico Ros$er!

1

0

1

0

1

1 Pas"or Maldonado

Pas"or Maldonado

0

1

0

1

0

0 Paul Di Es"a

Paul Di Es"a

0

1

0

1

1 Pedro de la Rosa

Pedro de la Rosa

0

0 Ro#ain *ros+ean

Ro#ain *ros+ean

1

0

0 Se$as"ian e""el

Se$as"ian e""el

1

0

1

0

1

1 Ser!io Pere,

Ser!io Pere,

0

0 i#o *lock

i#o *lock

0

1

0

0 i"alv Pe"rov

i"alv Pe"rov

0

1

0

8

3

5

4

6

0

3

4

9

5

8

3

5

4

6

0

3

4

9

5 ./

./

10

10 ./

./

00

00 ./

./

.

./

2

./

13

13 ./

./

..

./

00

00 ./

./

2

./

11

11 ./

./

.

ΣP

₁

₀

₁

Mi

Pij

(2)

o 1

P a u l D i $ s t a % i t a l ! P e t r o ! B r u n o S e n n a J e a n $ r i c & % e r g n e k i m m i R a i k k o n e n ' e ( i s H a m i l t o n " a r a i n  a r t h i k e ) a n S e # a s t i a n % e t t e l M a r k * e # # e r F e l i + e M a s a  a m i u  o # a ) a s h i " i c o R o s # e r g P e d r o d e l a R o s a , i m o G l o c k

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0 1 1 1 1 1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

0

1

8

3

5

4

8

4

9

7

6

7

6

4

8 ./10 ./00 ./. ./2 ./10 ./10 ./2 ./11 ./14 ./13 ./14 ./13 ./2 ./10

1

(3)

Pilotos (i)

1 Michael Schumacher

9 2 Sebastian Vettel

9 3 kimmi Raikkonen

8 4 Jenson Button

8 5 Lewis Hamilton

8 6 Paul

Di

Esta

8 7 imo !lock

8 8 "amiu "oba#ashi

$

9 Mark

%ebber

$

10 &eli'e

Masa

(

11 )ico

Rosber*

(

12 &ernan+o ,lonso

(

13 )ico Hulkenber*

-14 Bruno

Senna

-15 Romain !ros.ean

-16 Heikki "o/alainen



17 1harles

Pic



18 Jean Eric 2 Ver*ne



19 )arain "arthike#an



20 Pe+ro +e la Rosa



21 Daniel Ricciar+o

3 22 Pastor Maldonado

3 23 Vitalv Petrov

3 24 Ser*io

Pere4

0 Estos 2 pilotos tienen en comn los mismos

ami!os pero "o son ami!os entre ellos

(4)

(5)

Paso 2

Listado de los pilotos con sus amigos indirectos.

Se 'ue+e e/i+enciar +os ru'os bien +i5erencia+os los cuales en nin6n momento se unen

'or7ue aun7ue ambos tienen como ami*o com6n a

SP

 a este usuario to+a/a no le +an

un click en nin6n hi'er/nculo o enlace 'or lo cual no se unieron estos +os ru'os:

;: !;< BS

SP

 PM DR JV VP H" 1P ! PR )":

=: !=< &, SV JB &M MS P+R )Hu LH "R "" )R R! M%

SP

:

>

P,S@R M,LD@),D@ APM 2 ,mi*os ASP DR JV VP

>

BRC)@ SE)), ABS 2 ,mi*os AH" PR 1P

>

1H,RLES P1 A1P  2 ,mi*os AJV BS VP SP

>

D,)EL R11,RD@ ADR 2 ,mi*os APR 1P SPPMVP

>

&ER),)D@ ,L@)S@ A&, 2 ,mi*os AM% "R R! ""SV LH)R

>

&ELPE M,SS, A&M 2 ,mi*os AM% JB )R P+R SV R! SP

>

HE"" "@V,L,)E) AH" 2 ,mi*os AJV BS!

>

JE)S@) BC@) AJB 2 ,mi*os AM% "R P+R )Hu SP

>

JE,)2ER1 VER!)E AJV 2 ,mi*os AH" SP PM VP )" !

>

",MC "@B,,SH A"" 2 ,mi*os A&, "R P+R )Hu &M)R

>

"M R,""@)E) A"R 2 ,mi*os A"R JB P+R "" )R

>

LE%S H,ML@) ALH 2 ,mi*os ASV "R R! &, SP

>

M1H,EL S1HCM,1HER AMS 2 ,mi*os A&, R! &M )R "R SP

>

M,R" %EBBER AM% 2 ,mi*os AJB &, P+R )Hu LH JB SP

>

)1@ HCL"E)BER! A)Hu 2 ,mi*os AM% JB &, R! "" LH &M

>

),R,) ",RH"E,) A)" 2 ,mi*os AJV BS VP 1P SP

>

)1@ R@SBER! A)R 2 ,mi*os AJB &, R! P+R "" LH JB

>

P,CL D RES, AP+R 2 ,mi*os AM% R! "" )R

>

PEDR@ DE L, R@S, APR 2 ,mi*os ADR BS 1P PM VP1P

>

R@M,) !R@SJE,) AR! 2 ,mi*os ASV &M MS LH &, )Hu SP

>

SER!@ PEREF ASP 2 ,mi*os A 

>

SEB,S,) VEEL ASV 2 ,mi*os A&M )R LH SP

>

M@ !L@1" A! 2 ,mi*os APR

(6)

Pa

Pilotos (i)

J e n s o n B u t t o n P a s t o r M a l d o n a d o R o m a i n G r o s j e a n C h a r l e s P i c F e r n a n d o A l o n s o S e r g i o P e r e z D a n i e l R i c c i a r d o H e i k k i  o ! a l a i n e n M i c h a e l S c h u m a c h e r

j

Bruno Senna

0 ./00

0

0 ./00

0

0 Charles Pic

0 ./00

0

0 ./2

0 Daniel Ricciardo

0

0 ./2

0

0 ./2

0 Felipe Masa

./12

0

0 ./13

0

0 Fernando Alonso

./12

0

0 Heikki Kovalainen

0 ./00

0 ./2

0

0 ./00

0

0 Jean Eric - er!ne

0

0 ./00

0

0 Jenson Bu""on

0

0 ./.

0 ./13

0

0 ./11

Ka#iu Ko$a%ashi

./12

0 ./.

0

0 ./11

ki##i Raikkonen

0

0 ./.

0

0 ./11

&e'is Ha#il"on

./12

0

0 ./11

Mark (e$$er

0

0 ./.

0

0 ./11

Michael Schu#acher ./12

0

0 ./13

0

0 )arain Kar"hike%an

0

0 )ico Hulken$er!

0

0 ./13

0

0 ./11

)ico Ros$er!

./12

0 ./.

0

0 ./11

Pas"or Maldonado

0

0 ./2

0

0 ./2

0 Paul Di Es"a

0

0 ./13

0

0 ./11

Pedro de la Rosa

0

0 Ro#ain *ros+ean

./12

0

0 Se$as"ian e""el

./12

0

0 ./13

0

0 ./11

Ser!io Pere,

0

0 i#o *lock

0

0 ./2

0

0 i"alv Pe"rov

0

0 ./2

0 ΣP

1

(7)

o 3

" i c o H u l k e n # e r g P a u l D i $ s t a % i t a l ! P e t r o ! B r u n o S e n n a J e a n $ r i c & % e r g n e k i m m i R a i k k o n e n ' e ( i s H a m i l t o n " a r a i n  a r t h i k e ) a n S e # a s t i a n % e t t e l M a r k * e # # e r F e l i + e M a s a  a m i u  o # a ) a s h i " i c o R o s # e r g P e d r o d e l a R o s a , i m o G l o c k

0

0 ./00

0 ./2

0

0 ./10

0

0 ./00

0 ./2

0

0 ./10

0

0 ./. ./2

0

0 ./2

0

0 ./10

0

0 ./10 ./10

0

0 ./14

0

0 ./13

0

0 ./10

0

0 ./10

0

0 ./11

0 ./13

0

0 ./00

0

0 ./2

0

0 ./2 ./10

0

0 ./.

0

0 ./2 ./10

0 ./10

0

0 ./10

0 ./11

0

0 ./14

0

0 ./10

0 ./11 ./14 ./13

0

0 ./. ./10

0

0 ./11 ./14 ./13

0 ./13

0

0 ./10

0

0 ./10

0

0 ./13 ./14

0

0 ./10 ./10

0 ./11

0

0 ./14 ./13

0

0 ./. ./10

0

0 ./10 ./10

0 ./11 ./14 ./13 ./14 ./13

0

0 ./2

0

0 ./10

0

0 ./10 ./10

0 ./11

0 ./13

0

0 ./.

0

0 ./10

0

0 ./14

0

0 ./.

0

0 ./2

0

0 ./10

./.

0

0 ./10 ./2 ./11

0

0 ./2

0

0 ./10

0

0 ./11 ./14

0 ./14

0

0 ./. ./10

0

0 ./10

0

0 ./14

0 ./14 ./13

0

0 ./.

0

0 ./14

0 ./2 ./10

0

0 ./.

0

0 ./10

1

(8)

Pilotos (i)

J e n s o n B u t t o n P a s t o r M a l d o n a d o R o m a i n G r o s j e a n C h a r l e s P i c F e r n a n d o A l o n s o S e r g i o P e r e z

j

Bruno Senna

0 ./00

0

0 0:0

Charles Pic

0 ./00

0

0 0:0

Daniel Ricciardo

0

0 ./2

0 0:0

Felipe Masa

./10

0

0 ./13

0:0

Fernando Alonso

./10

0

0 0:0

Heikki Kovalainen

0 ./00

0 ./2

0 0:0

Jean Eric - er!ne

0

0 0:0

Jenson Bu""on

0

0 ./.

0 ./13

0:0

Ka#iu Ko$a%ashi

./10

0 ./.

0

0 0:0

ki##i Raikkonen

0

0 ./.

0

0 0:0

&e'is Ha#il"on

./10

0

0 0:0

Mark (e$$er

0

0 ./.

0

0 0:0

Michael Schu#acher ./10

0

0 ./13

0:0

)arain Kar"hike%an

0

0 0:0

)ico Hulken$er!

0

0 ./13

0:0

)ico Ros$er!

./10

0 ./.

0

0 0:0

Pas"or Maldonado

0

0 ./2

0 0:0

Paul Di Es"a

0

0 ./13

0:0

Pedro de la Rosa

0

0 0:0

Ro#ain *ros+ean

./10

0

0 0:0

Se$as"ian e""el

./10

0

0 ./13

0:0

Ser!io Pere,

0

0 0:0

i#o *lock

0

0 ./2

0 0:0

i"alv Pe"rov

0

0 0:0

8

3

5

4

6

0 ./10 ./00 ./. ./2 ./13 ./..

ΣP

1 1 1 1 1 1

5

0:;- 0:33 0:=; 0:=( 0:;9 0:0

Mi

Pij

(9)

Paso 4

D a n i e l R i c c i a r d o H e i k k i  o ! a l a i n e n M i c h a e l S c h u m a c h e r " i c o H u l k e n # e r g P a u l D i $ s t a % i t a l ! P e t r o ! B r u n o S e n n a J e a n $ r i c & % e r g n e k i m m i R a i k k o n e n ' e ( i s H a m i l t o n " a r a i n  a r t h i k e ) a n S e # a s t i a n % e t t e l M a r k * e # # e r F e l i + e M a s a  a m i u  o # a ) a s h i

./00

0

0 ./00

0 ./2

0

0 ./2

0

0 ./00

0 ./2

0

0 ./2

0

0 ./. ./2

0

0 ./2

0

0 ./10

0

0 ./10 ./10

0

0 ./14

0

0 ./10

0

0 ./10

0

0 ./11

0 ./13

0 ./00

0

0 ./00

0

0 ./2

0

0 ./00

0

0 ./.

0

0 ./11

0 ./10

0

0 ./10

0 ./11

0

0 ./14

0

0 ./11

0

0 ./10

0 ./11 ./14 ./13

0

0 ./11 ./. ./10

0

0 ./11 ./14 ./13

0

0 ./11

0 ./10

0

0 ./10

0

0 ./13 ./14

0

0 ./11

0

0 ./10 ./10

0 ./11

0

0 ./14

0

0 ./. ./10

0

0 ./10 ./10

0 ./11 ./14 ./13 ./14

0

0 ./11

0 ./10

0

0 ./10 ./10

0 ./11

0 ./13

0

0 ./11 ./.

0

0 ./10

0

0 ./14

0

0 ./2

0

0 ./.

0

0 ./2

0

0 ./11 ./.

0

0 ./10 ./2 ./11

0

0 ./2

0

0 ./10

0

0 ./11 ./14

0 ./14

0

0 ./11 ./. ./10

0

0 ./10

0

0 ./14

0

0 ./.

0

0 ./14

0

0 ./2

0

0 ./.

0

3

4

9

5

8

3

5

4

8

4

9

7

6

7 ./00 ./2 ./11 ./. ./10 ./00 ./. ./2 ./10 ./10 ./2 ./11 ./14 ./13 ./14

1 1 1 1 1 1 1 1 1 1 1 1 1 1 1

0:33 0:=( 0:; 0:=; 0:;- 0:33 0:=; 0:=( 0:;- 0:;- 0:=( 0:; 0:;$ 0:;9 0:;$

(10)

" i c o R o s # e r g P e d r o d e l a R o s a , i m o G l o c k

0

0 ./10

0

0 ./10

0

0 ./10

./13

0

0 ./2 ./10

0

0 ./13

0

0 ./13

0

0 ./13

0

0 ./2

0 ./13

0

0 ./10

0

0 ./13

0

0 ./2 ./10

0

0 ./10

6

4

8 ./13 ./2 ./10

1

1 0:;9 0:=(