how to plot a function in excel This is a topic that many people are looking for. khurak.net is a channel providing useful information about learning, life, digital marketing and online courses …. it will help you have an overview and solid multi-faceted knowledge . Today, khurak.net would like to introduce to you MICS Graphing Polynomials in MS Excel . Following along are instructions in the video below:
“So let s say you re asked to graph an equation that looks like this this it s a polynomial equation. Which you learn how to graph by hand when re easily factorable. This however is not easily factorable and you don t have a graphing calculator. If you re going to try and do this by hand what you re going to end up.
Doing is probably sitting and plugging in points into an xy table for 30 minutes. Before you have enough to actually see the shape of the graph let s look at a better option though you can actually graph polynomial equations in microsoft excel. So go ahead and open that up in a spreadsheet like this will pop up. Okay.
The first column is going to be the values of your domain. So the values that you want to use for x. Generally. I have my graph go from negative.
10 to 10 um. So what i m going to do is in the first box. You put in the first value or the minimum value of your domain. Okay you can have it go up in units of 1 so negative 10 negative 9 negative 8 i m gonna have it go up in units of 2 so the next number will be negative.
8. Okay instead of going through and typing in all the numbers you can just highlight those two numbers and click this little box in the corner hold down and drag it down until it s at the maximum value that you want okay so i ve domain values from negative 10 to 10 in the b column cell. B1. You re going to start by putting the equation that you re using the equation.
You re going to be plugging these domain values into this is our equation here in word. When you re typing an equation into excel. You don t need to use the y variable you just start with an equals and that tips off the program. That hey the mentoring.
An equation here okay start with coefficient one important thing that you must remember is that anytime..
You have multiplication in an equation. You have to tell the computer. You can t just say two x to the fourth. Because it s technically two times x.
Okay. So anytime. You multiplication you need to give the sign. Which is an asterisk so shift.
Eight is what you need to hit. We also can t just use x. Because the computer doesn t know what is x. But what we can do is click here on our domain value.
Because well. That is the corresponding x value. So. Now.
The computer knows all right. We re using this domain. Ok and then to the fourth power to do power. You do this little caret symbol shift.
Six and four okay so we just entered this part two times x to the fourth power. So just continue on then plus. Five times. Domain.
To the third power. Minus 2. Times. X.
Domain. Plus. Four. There s our equation.
Okay. This little box in the corner down here. When your cursor makes this little cross you can double click now fill in all the values using that equation for each of these domain values. This is the corresponding range value okay.
Let s make this bigger alright to graph it. Then what you need to do is highlight the complete domain and range up here at the top go to insert scatter and just click on the first scatter plot first thing get rid of this little legend on the side. Delete you don t need that right click on a point and go to add trendline okay. It s going to start off thinking.
It s linear. Obviously. It s not this is a polynomial function so go ahead and tell it still doesn t quite fit it needs to know the order. Which is the same as degree okay our equation here has degree of 4 remember that s the biggest exponent so go ahead and tell it and notice how it curves to fit a fourth degree polynomial function.
Hey go ahead and close out of that all right you should know by now that if something has degree 4. It can have at most 3 turning points. I don t see any turning points at all and frankly it looks very flat right through here. Which polynomial shouldn t it should be constantly curving.
So what we re going to do is we re going to zoom in on this spot..
Here to see if there are any turning points those are important if there there they need to be shown. So what you need to do to zoom in is to right click on a number in the axis. We ll start with the y axis go down to format. Axis alright.
This brings up a menu for minimum and maximum values of the axis right now it s going from negative five thousand to thirty thousand which seems a little bit excessive because really it looks like nothing is going on below zero and above five thousand pretty much and we can see from our graph. Here or our range. Here. There are no negative numbers and there are no turning points beyond five thousand in fact there might not even be any beyond one thousand.
But we ll start off slow. So i m going to have this start just a little bit below zero. So at negative ten and i ll just have it go up to five thousand and we ll see where that gets us okay. It says your major unit and minor unit.
Minor units. You don t need to worry about it all major units are represent each of these lines that go across so if you want to you can change. What the major unit is i ll have it go in units of a hundred just to see what that looks like oh. That s really crowded let s try something bigger.
It s two units at five hundred that s better okay i still don t really see any turning points and once again it looks like there s nothing going on above 490. Nothing important the graph is just going up to infinity. So i ll just have the maximum of the graph be 500 and i ll put major units in units of 50. I m starting to see some turning points down in there so i m going to zoom in just a little bit more.
I ll have my maximum be 100 instead of 500 now. I can see very clearly where the graph is turning okay. So i m going to go ahead and close that we have a lot of open space over here. So what i m going to do is zoom in on the x axis.
As well so right click on the number format axis..
There s really nothing going on outside of negative five and five. So i m going to have those be my minimum and maximum values for my x axis and that looks a whole lot clearer okay. I can see all turning points and all intercepts which are the important parts of okay. Once you re zoomed in far enough to be able to see all intercepts and turning points.
The only thing you need to do is add a title if you want to measure on with the color that s fine. It s up to you but the only other thing i require is go to layout chart title above the chart put a title and that s going to be just whoops um. The problem number that you re working on the so if it s number one just make it title. The number one so.
What you re going to do then when you turn this in is you re going to just copy and paste the graphs into microsoft word you ll have three or four graphs for your homework. So you should be able to get them all on one page. Okay you don t need to have the equation. There you can go back and just delete that but actually you probably won t have it there at all um.
But what you need to turn in is just a page of the graphs okay um. One small hint to avoid this pitfall when you go back to start the next problem so problem. Two don t delete all of this your domain and range in graph. Here.
Because what that will do them is it will also delete the graph that you copied and paste it into word those are still linked so. What you need to do is leave all of this here. But go down here and tab over to a new sheet and then in here start your next problem get your graph copy paste it into word and then for the next problem start a new sheet because if you delete and just go over. What your old work was it will replace it um instead of saving it so yeah.
That is a quick and simple way to graph polynomials using microsoft word. ” ..
Thank you for watching all the articles on the topic MICS Graphing Polynomials in MS Excel . All shares of khurak.net are very good. We hope you are satisfied with the article. For any questions, please leave a comment below. Hopefully you guys support our website even more.
“Even though I accidentally say “Microsoft Word” at the end while I am distracted and trying to end the video, this is actually a how-to for graphing polynomial functions using Microsoft Excel.”,
20120827, 1634, 46