Gauss Jordan (Excel)

Seleccio

e tamaño de la matriz 2x2 3x3 4x4 5x5 6x6 7x7

Datos de entrada p=

6

x0 Resultado x0=

4.000003

x1=

-0.800001

Portada

x1

=

13

40

20

8

30

8

13

40

20

8

30

8

1

3.076923

1.538462

0

5.384616

-4.307696

1

0

4.000003

0

1

-0.800001

comprobación x0

x1

=

52.000039

-32.00004

19.999999

32.000024

-24.00003

7.999994

Datos de entrada p=

6

x0 Resultado

x1

x2

=

10

4

3

10

x0=

1.176596

2

-10

7

13

x1=

-0.76383

5

-5

10

14

x2=

0.429787 10

4

3

10

2

-10

7

13

5

-5

10

14

1

0.4

0.3

1

0

-10.8

6.4

11

0

-7

8.5

9

1

0

0.537037

1.407408

0

1

-0.592593

-1.018519

0

0

4.351849

1.870367

1

0

0

1.176596

0

1

0

-0.76383

0

0

1

0.429787

Portada

comprobación x0

x1

x2

=

x0

11.76596

-3.05532

1.289361

10.000001

0.138297

2.353192

7.6383

3.008509

13.000001

-0.031914

5.88298

3.81915

4.29787

14

-0.085106

1

0

0

0

1

0

0

0

1

0.1

0

0

-0.2

1

0

-0.5

0

1

0.092592

0.037037

0

0.018519

-0.092593

0

-0.370367

-0.648151

1

0.138297

0.117022

-0.123404

-0.031914

-0.180852

0.13617

-0.085106

-0.148937

0.229787

Matriz Inversa x1

x2

0.117022

-0.123404

-0.180852

0.13617

-0.148937

0.229787

Datos de entrada p=

6

x0 Resultado

x1

x2

x3

6

2

6

2

x0=

-3.218753

0

7

3

3

x1=

13.101472

13

1

31

9

x2=

11.312445

1

15

6

7

x3=

-34.882582 6

2

6

2

0

7

3

3

13

1

31

9

1

15

6

7

1

0.333333

1

0.333333

0

7

3

3

0

-3.333329

18

4.666671

0

14.666667

5

6.666667

1

0

0.857143

0.190476

0

1

0.428571

0.428571

0

0

19.428568

6.095239

0

0

-1.285708

0.380959

1

0

0

-0.078432

0

1

0

0.294117

0

0

1

0.313726

0

0

0

0.784319

1

0

0

0

0

1

0

0

0

0

1

0

0

0

0

1

Portada

comprobación =

x0

x1

5

-19.312518

26.202944

21

0

8 17 5 21 8 17 0.833333 21 -2.833329 16.166667 -0.166666 3 7.166658 -27.833334 -0.482842 2.841912 0.368872 -27.359072 -3.218753 13.101472 11.312445 -34.882582

x2 67.87467

x3

=

-69.765164

4.999932

91.710304

33.937335 -104.647746

20.999893

-41.843789

1 3.101472

350.685795 -313.943238

8.00024

-3.218753

196.52208

67.87467 -244.178074

16.999923

Datos de entrada p=

6

x0 Resultado

x1

x2

x3

1

3

3

4

x0=

1.461465

2

5

6

3

x1=

0.250631

6

1

67

3

x2=

-0.381133

8

35

6

7

x3=

-7.774817

6

3

4

6

x4=

7.405863 1

3

3

4

2

5

6

3

6

1

67

3

8

35

6

7

6

3

4

6

1

3

3

4

0

-1

0

-5

0

-17

49

-21

0

11

-18

-25

0

-15

-14

-18

1

0

3

-11

0

1

0

5

0

0

49

64

0

0

-18

-80

0

0

-14

57

1

0

0

-14.918366

0

1

0

5

0

0

1

1.306122

0

0

0

-56.489804

0

0

0

75.285708

1

0

0

0

0

1

0

0

0

0

1

0

0

0

0

1

0

0

0

0

1

0

0

0

0

1

0

0

0

0

1

0

0

0

0

1

0

0

0

0

Portada

comprobación x4

=

x0

x1

x2

x3

5

7

1.461465

0.751893

-1.143399

-31.099268

6

23

2.92293

1.253155

-2.286798

-23.324451

7

12

8.76879

0.250631

-25.535911

-23.324451

8

23

11.69172

8.772085

-2.286798

-54.423719

9

28

8.76879

0.751893

-1.524532

-46.648902

5

7

6

23

7

12

8

23

9

28

5

7

-4

9

-23

-30

-32

-33

-21

-14

-7

34

4

-9

45

-183

-76

66

39

-149

-9.755101

45.204082

4

-9

0.918367

-3.734694

-59.469394

-1.224492

51.857138 -201.285716 5.950149

45.527453

-1.26373

-9.10838

-0.456648

-3.763006

1.052746

0.021676

-27.39959 -202.917609 0

1.461465

0

0.250631

0

-0.381133

0

-7.774817

1

7.405863

x4

=

37.029315

7.000006

44.435178

23.000014

51.841041

12.0001

59.246904

23.000192

66.652767

28.000016

Datos de entrada p=

6

x0 Resultado

x1

x2

x3

2

4

6

8

x0=

4

0

5

6

3

x1=

0.641688

2

4

5

6

x2=

10.028779

0

35

6

7

x3=

-0.704545

3

4

5

6

x4=

-19.243913

10

8

6

5

x5=

11.028012 2

4

6

8

0

5

6

3

2

4

5

6

0

35

6

7

3

4

5

6

10

8

6

5

1

2

3

4

0

5

6

3

0

0

-1

-2

0

35

6

7

0

-2

-4

-6

0

-12

-24

-35

1

0

0.6

2.8

0

1

1.2

0.6

0

0

-1

-2

0

0

-36

-14

0

0

-1.6

-4.8

0

0

-9.6

-27.8

1

0

0

1.6

0

1

0

-1.8

0

0

1

2

0

0

0

58

0

0

0

-1.6

0

0

0

-8.6

1

0

0

0

0

1

0

0

0

0

1

0

0

0

0

1

0

0

0

0

0

0

0

0

1

0

0

0

Portada

0

1

0

0

0

0

1

0

0

0

0

1

0

0

0

0

0

0

0

0

1

0

0

0

0

1

0

0

0

0

1

0

0

0

0

1

0

0

0

0

0

0

0

0

x4

x5

=

x0

x1

x2

10

12

5

8

2.566752

60.172674

6

7

23

0

3.20844

60.172674

7

8

10

8

2.566752

50.143895

8

9

23

0

22.45908

60.172674

7

8

14

12

2.566752

50.143895

8

6

14

40

5.133504

60.172674

10

12

5

6

7

23

7

8

10

8

9

23

7

8

14

8

6

14

5

6

2.5

6

7

23

-3

-4

5

8

9

23

-8

-10

6.5

-42

-54

-11

2.6

3.2

-6.7

1.2

1.4

4.6

-3

-4

5

-34

-40

-138

-5.6

-7.2

15.7

-27.6

-37.2

44.2

0.8

0.8

-3.7

-2.4

-3.4

10.6

3

4

-5

74

104

-318

-0.8

-0.8

7.7

1.2

1.2

-3.8

-1.241379

-2.068965

5.072414

-0.103448

-0.172415

0.731034

0.448276

0.413794

5.965518

1.275862

1.793103

-5.482759

1.241379

2.068965

-1.072414

12.172413

16.620686

-50.951727

0

0

4

0

-0.000002

0.641666

0

-0.333333

6.352779

0

-0.333334

-4.380556

1

1.666667

-0.863889

0

-3.666673

-40.436113

0

0

4

0

0

0.641688

0

0

10.028779

0

0

-0.704545

1

0

-19.243913

0

1

11.028012

comprobación x3 -5.63636

x4

x5

=

-192.43913

132.336144

5.00008

-2.113635 -115.463478

77.196084

23.000085

-4.22727 -134.707391

88.224096

10.000082

-4.931815 -153.951304

99.252108

23.000743

-4.22727 -134.707391

88.224096

14.000082

-3.522725 -153.951304

66.168072

14.000221

Datos de entrada p=

6

x0 Resultado

x1

x2

x3

10

11

12

13

x0=

0.576102

0

5

6

3

x1=

0.729284

15

10

15

10

x2=

0.753492

0

35

6

7

x3=

-9.178788

5

10

15

20

x4=

9.073828

0

6

3

9

x5=

-1.817163

6

12

18

24

x6=

0.107692 10

11

12

13

0

5

6

3

15

10

15

10

0

35

6

7

5

10

15

20

0

6

3

9

6

12

18

24

1

1.1

1.2

1.3

0

5

6

3

0

-6.5

-3

-9.5

0

35

6

7

0

4.5

9

13.5

0

6

3

9

0

5.4

10.8

16.2

1

0

-0.12

0.64

0

1

1.2

0.6

0

0

4.8

-5.6

0

0

-36

-14

0

0

3.6

10.8

0

0

-4.2

5.4

0

0

4.32

12.96

1

0

0

0.5

0

1

0

2

0

0

1

-1.166667

0

0

0

-56.000012

0

0

0

15.000001

0

0

0

0.499999

0

0

0

18.000001

1

0

0

0

0

1

0

0

0

0

1

0

Portada

0

0

0

1

0

0

0

0

0

0

0

0

0

0

0

0

1

0

0

0

0

1

0

0

0

0

1

0

0

0

0

1

0

0

0

0

0

0

0

0

0

0

0

0

1

0

0

0

0

1

0

0

0

0

1

0

0

0

0

1

0

0

0

0

0

0

0

0

0

0

0

0

1

0

0

0

0

1

0

0

0

0

1

0

0

0

0

1

0

0

0

0

0

0

0

0

0

0

0

0

x4

x5

x6

=

x0

x1

14

15

16

5

5.76102

8.022124

6

7

6

23

0

3.64642

15

10

15

55

8.64153

7.29284

8

9

9

23

0

25.52494

25

30

35

14

2.88051

7.29284

12

3

5

28

0

4.375704

30

36

16

14

3.456612

8.751408

14

15

16

5

6

7

6

23

15

10

15

55

8

9

9

23

25

30

35

14

12

3

5

28

30

36

16

14

1.4

1.5

1.6

0.5

6

7

6

23

-6

-12.5

-9

47.5

8

9

9

23

18

22.5

27

11.5

12

3

5

28

21.6

27

6.4

11

0.08

-0.04

0.28

-4.56

1.2

1.4

1.2

4.6

1.8

-3.4

-1.2

77.4

-34

-40

-33

-138

12.6

16.2

21.6

-9.2

4.8

-5.4

-2.2

0.4

15.12

19.44

-0.08

-13.84

0.125

-0.125

0.25

-2.625

0.75

2.25

1.5

-14.75

0.375

-0.708333

-0.25

16.125

-20.5

-65.499988

-42

442.5

11.25

18.749999

22.5

-67.25

6.375

-8.374999

-3.25

68.125

13.5

22.499999

1

-83.5

-0.058036

-0.709821

-0.125

1.325892

0.017858

-0.089284

0

1.053568

0.802083

0.65625

0.625

6.906249

0.366071

1.169642

0.75

-7.901784

5.758935

1.205368

11.249999

51.276768

6.191965

-8.959819

-3.624999

72.075884

6.910722

1.446442

-12.500001

58.73212

0

-0.697674

-0.011627

1.842637

0

-0.093022

-0.034885

0.894563

0

0.488371

-0.941858

-0.235388

0

1.093022

0.034885

-11.16123

1

0.209304

1.953486

8.903863

0

-10.255822

-15.720916

16.943476

0

0

-26

-2.800002

0

0

1.057821

0.690021

0

0

0.107706

0.740883

0

0

-1.690471

0.571442

0

0

-1.640583

-9.355466

1

0

1.632649

9.249651

0

1

1.532877

-1.652084

0

0

-26

-2.800002

0

0

0

0.576102

0

0

0

0.729284

0

0

0

0.753492

0

0

0

-9.178788

1

0

0

9.073828

0

1

0

-1.817163

0

0

1

0.107692

Comprobación x2

x3

9.041904 -119.324244

x4

x5

x6

=

127.033592

-27.257445

1.723072

5.000023

4.520952

-27.536364

54.442968

-12.720141

0.646152

22.999987

11.30238

-91.78788

136.10742

-18.17163

1.61538

55.00004

4.520952

-64.251516

72.590624

-16.354467

0.969228

22.999761

11.30238

-183.57576

226.8457

-54.51489

3.76922

14

2.260476

-82.609092

108.885936

-5.451489

0.53846

27.999995

13.562856 -220.290912

272.21484

-65.417868

1.723072

14.000008