1
00:00:00,710 --> 00:00:01,670
Hi, everyone.

2
00:00:03,680 --> 00:00:11,210
We have already learned determinants in birds and solution of linear systems by various methods from

3
00:00:11,210 --> 00:00:12,290
the previous sessions.

4
00:00:13,190 --> 00:00:18,020
A system of linear equations also can be solved by three months rule and matrix method.

5
00:00:18,920 --> 00:00:25,370
But sometimes what happens is this Kramers matrix method and other methods, which we have learned in

6
00:00:25,370 --> 00:00:31,660
madrases may be tedious when in large system of equations are there.

7
00:00:32,360 --> 00:00:32,750
OK.

8
00:00:33,260 --> 00:00:40,070
So therefore, we have numerical methods of solutions which are machine compatible for computations.

9
00:00:42,640 --> 00:00:44,920
There are two ways to solve.

10
00:00:46,230 --> 00:00:51,240
These equations in a system of equations, one is static method.

11
00:00:51,940 --> 00:00:53,730
The other one is iterative method.

12
00:00:54,750 --> 00:01:02,280
In that method, we have two methods which we are going to understand in this forthcoming sessions.

13
00:01:03,320 --> 00:01:05,190
Course, Jordan and Gaza nation.

14
00:01:06,450 --> 00:01:12,630
And in a treaty methods, we will have Goss, Jacobean Goss, little methods.

15
00:01:14,100 --> 00:01:14,370
OK.

16
00:01:16,270 --> 00:01:18,130
The approximations are.

17
00:01:20,070 --> 00:01:21,930
Understood by repeated steps.

18
00:01:23,100 --> 00:01:23,420
Yes.

19
00:01:24,800 --> 00:01:27,290
Which lead to a true solution.

20
00:01:28,560 --> 00:01:34,290
By a computational cycle, various methods and processes are designed to achieve the desired accuracy

21
00:01:36,780 --> 00:01:37,470
in this score.

22
00:01:37,500 --> 00:01:44,280
The objective is to merge learning of two different branches of mathematics that is from matrices to

23
00:01:44,280 --> 00:01:47,070
numerical methods using Excel.

24
00:01:48,980 --> 00:01:52,400
As you can see, when I was taking the course.

25
00:01:53,670 --> 00:01:55,440
The mathematical representations.

26
00:01:56,660 --> 00:02:00,350
Well, represented with some examples using Excel.

27
00:02:00,950 --> 00:02:02,240
So while using Excel.

28
00:02:04,010 --> 00:02:10,010
The the methods were clear and we could solve.

29
00:02:11,960 --> 00:02:21,740
Many examples which will be giving us an idea about the solutions and how the iterations would be happening.

30
00:02:22,100 --> 00:02:25,070
And in Excel, it is easy for us to observe.

31
00:02:27,350 --> 00:02:33,290
And in this session, we are going to incorporate those the methods which we learned exploded with traces

32
00:02:34,310 --> 00:02:37,340
to solve numerical methods using Excel.

33
00:02:41,090 --> 00:02:48,290
The examples which we have designed in which I have designed in this forthcoming sessions are such a

34
00:02:48,290 --> 00:02:50,720
way that just by.

35
00:02:51,760 --> 00:02:59,380
Values, you put the values in those cells of the Excel sheet, you can generate as many examples as

36
00:02:59,380 --> 00:02:59,950
you want.

37
00:03:02,190 --> 00:03:10,710
Then then what happens is if you if you want to really expertise in that method, you can do it using

38
00:03:10,710 --> 00:03:11,220
Excel.

39
00:03:11,700 --> 00:03:14,070
So that's how the examples are designed.

40
00:03:14,220 --> 00:03:24,120
So even one example is enough to design the particular kind of iteration table, or maybe the method

41
00:03:24,120 --> 00:03:27,720
which we are using to solve using Excel.

42
00:03:28,560 --> 00:03:30,450
So this is the way the.

43
00:03:32,850 --> 00:03:35,850
Designing of numerical methods has been done.

44
00:03:37,480 --> 00:03:41,110
OK, see you then let us start with the numerical methods.

45
00:03:41,140 --> 00:03:41,980
Using Excel.