ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Excel sheet for Echelon/Reduced Echelon Form
2
3
Assignment by Kamil Rasheed Siddiqui ME201024
4
5
Row swapping for pivot element in Row 1:How to use:
6
00000000
7
0000Original Matrix0000
8
00000000
9
00000000
10
11
00000000
12
0000After interchanging rows0000If you want to calculate a 3x3 echelon form, use the highlighted
13
0000for pivot element in Row 10000region to input the numbers and fill the rest with zeros.
14
00000000
15
16
00000000
17
0000Multiplying Row 1 by 1/00000
18
00000000
19
00000000
20
If you want to calculate a 2x2 echelon form, use the highlighted
21
0000region to input the numbers and fill the rest with zeros.
22
0000R2 + (-B17) * R1Row swapping for pivot element in Row 2:
23
0000R3 + (-B18) * R10000Using 4x4 and 1x1 should be self explanatory.
24
0000R4 + (-B19) * R10000
25
0000Answers should also be read in exactly the same format of
26
00000000corresponding types of matrix. Ignore the excess zeros placed
27
0000After interchanging rowsand note rest of the numbers
28
0000for pivot element in Row 20000
29
00000000
30
0000
31
00000000
32
0000Multiplying Row 2 by 1/0
33
0000
34
0000Row swapping for pivot element in Row 3:
35
0000
36
00000000
37
00000000
38
0000R3 + (-C33) * R20000
39
0000R4 + (-C34) * R2
40
41
0000
42
0000After interchanging rows
43
0000for pivot element in Row 3
44
0000
45
46
0000
47
0000Multiplying Row 3 by 1/0
48
0000
49
0000
50
51
0000
52
0000
53
0000
54
0000R4 + (-D49) * R3
55
56
0000
57
0000Multiplying Row 3 by 1/0
58
0000
59
0000
60
61
0000
62
0000Echelon Form
63
0000
64
0000
65
66
0000
R1+(-E61)*R4
67
0000
R2+(-E62)*R4
68
0000
R3+(-E63)*R4
69
0000
70
71
0000
R1+(-D66)*R3
72
0000
R2+(-D67)*R3
73
0000
74
0000
75
76
0000
R1+(-C71)*R2
77
0000
78
0000
79
0000
80
81
0000
82
0000Reduced Echelon Form
83
0000
84
0000
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100