Dr. lawless in this lesson that is lesson number five, we learn about using usefulness and functions who will cheat. We're also taking no this example so that something Do sound available there again to work using No, this is the place where farmers are their farm loss of function whatever you call what your next will be supplementary functions here it is everything is here know has to do some average count maximum minimum, these four things we already learned in the last class. Now, let us learn about ABS I will deal with a few of them which are more useful for engineers and in case of others you can find yourself this is ABS What is this absolute value? It returns absolute value of in numbers. So, what is absolute value? It is just a value without any sign.

Okay? You are if you have integrity To save a number maybe if you use this function it will return positive suppose you have minus 2.5 when you use this function it returns 3.5. So, I will see how it can support you who testify and did you to pause it yourself and it wasn't too good 35.5 suppose you have here minus you and then it returned 35.5 So, pausing this, you can view and I this other column of Excel, let us see, who was called Ay, ay three, let us see. I see, okay 70 this is some indie. Suppose I assign assign to this say thanks Even then, even though it is minus absolute value. Now go to the next one The next important function will take up distinct review, I will take up costs, cost is the inverse function of cosine that is causing much cost in must some ratio, find five.

So that gives you 30 6060 degrees, but it isn't working radiant. So this is a technocratic function. So I will pick up this first cause We'll see you just 1.0 radians. And if you want to convert this into degrees, you have to multiply meetings from 181 put a bracket even if you don't put a bracket the bracket 9990 that is cost, Judo these maintenance costs 30 in approximate value because 3.14 is a fraction no 3.1 to even make it maybe you get you still closer 89 compared somewhere it is proximate, so 90 similarly, we'll take another case They're using various museums I suppose I'd say see costs cannot be more than 1.1 point five is a 00 t number this is not known it is a function parameter it should be within one. So, because cos cos of 90 degrees of zeros one class of quantities minus one, so, that is the maximum that you can ask the class can go.

So, we have to give a value which is between zero and 100 do I know So, suppose this is what, you know monkeys suppose I multiply this by one ad When you're 60 you also can view a value minus value here we have minus one not 40 that is more than 90 degree cause the negative coordinate x coordinates will use minus one not for suppose it is much more to play with so cost function now we'll go next, this is hyperbolic cosine of a number you know hyperbolic sine hyperbolic, you pull it up D plus e to the power of minus theta By to or something like that become too hyper hyper remember that is called as classful hyperbolic cost, I'm not going too deep in detail, I will take just a function and the value here you can have any value this is this doesn't have degree or anything like that we can live as it is.

So you can take which is to point to that is the value will be, I will show you I permitted What is my purpose, I will show you the internet you can also represent reporting Are you question translate to zcash A you could he he sang he took this is actually humans functions sine x hyperbolic sine is usually part of x minus two okay cautious youtuber of x plus equals minus x by two and tan is sine x divided by caution that x minus x plus you know too easy exponentiated do something like two point and that is one plus one or factorial one plus two whereby one divided by two factorial was one by T plateaued like that upper infinity, which is an infinite series underlined which is represented by E and it's valued with two times seven and large something like that it is it is actually an irrational number you get so upset To the bottom left all you want here okay?

No close did this just for the commission. See movie she will leave we can also have same function instead of gosh, you can outside you can have same function is a universe just radians to degrees one Zero you do videos if you want to see similarly, and also we can go console we can find some more multiply my degrees Moon to see degree can Caught I put him in court he's a function you can add any two numbers you can hear three if you mention you should no claim you know to put commas. So, suppose you want to add say g, d g, then you can say somewhere h 11 these two DAX and useless chicken before you get there See wrongly intended use for the government. So, let us see Usually, addition will be wanting to do numbers can be added numbers to be not more than that that's what you indicate because it doesn't take too because some you know that we can always to add number of more numbers we can use the function sum which you know already don't just call back once again and from what is used to only do one or two amaku number you call an operator only to number them more on clickety will you example too long but I didn't use only two numbers and also addition we can do it the other way out.

See simply use the same equal to bracket. Suppose I want to add say 70 i t i t plus I want to add or you similarly, we can add more numbers can have numbers numbers you can add here by using the same data, you have to put an equal equal sign always want that equal. And you can also add numbers. This bracket, bracket also can add, subtract, subtract, there is no function. You can just put equals and have a number. You want to subtract.

I fight h five minus i gap. Similarly, if you want to subtract one more number from that, minus six minus 10 becomes like the Roman numerals may come across. So I'm unlike Roman numerals, you know that I will explain New Roman numerals specifically No, no, this is one I just do CS three Then you should be knowing Roman numerals x capital And this is one to put denuded commerce looking Of course then you I don't think Good to see ya. Time is later on numbers this three by four can do great time to the instead of radians you have to give two numbers and the direction that this 400 by 10 00 point zero is when it becomes a unicorn because I put 146 you want to convert into no 45 give you a second by faster means we have to CMS user same can function can function.

We talked adding to that, then calling it as to put an equal sign here. See, we expressed in terms of your record a stroke in terms of flow UTC radians per sign it is not their function gaytan to push us to number two you have to give that slow. Suppose you can higher value than suppose you you just higher when you use more than one point in life because 1090 is infinity, you can go to any number, you can do very high value even then use only so much 0.1 1.5 I dress you think I said reference as well you want to address cell reference. Of course I want to have v.v.on one that is one two plus two representing Whereas we get the value as be $1 $2 B is an actress wouldn't be dollar B dollar one is an actress. Be one she's gorgeous.

Okay that I will read from when we do some examples. knees up what I want to have you see one that this one needs to remain the same that you would use know again Express Next to the constraint, this is constraint. Na last use are a nonlinear function. You see these characters in the AC, this will not record things is not required when we come across because there are so many functions and we'll just brand new which are useful for average to dig this function Okay, average returns the average value. Suppose you want to have an average of this h h 264 64 to you right You can get one new one. Everybody will do what it's doing.

Then pause What do you want me to do? Do sign that means Add this column I will explain if h two to h two 121 to 2829 to that and 64 Okay. Then you also add these things at age 72 etc etc Then you do it by number of columns one to two how many columns on the value do I admit that is average you find out the average. Similarly, for the numbers also you can use average average number seven you get six comma you should not forget to use simplex whatever is given there is Carmarthen user data will not equal human error function, then you can check up with the help command and you can find out where the lies and you can correct it and contract to use a note also as an example just see suppose I forgot to do a comma Yeah.

Possible you see what the other says paragraph Raziel? Here what I have done is not inserted a comma here. You make it without any whitespace dixiecrats, Jessica's 90 and gipsy. Suppose we are also if I To play forget this comma Dixon 78. But if I do a gap there, then it gives an error function. This is a Frasier that indicates and then you can check it.

What is the error? So initially human come together but get wrong. Once you're used to it, then there won't be any problem. We have cleared weighted average every year and if it's meant to be, what I do is I will do it in the next session.