![]() |
How can I graph quadratic or quartic equations
I want to know how can I graph equations from linear equations to quartic or
higher degree equations using excel charts utility? |
How can I graph quadratic or quartic equations
Decide your expression(s) for Y as a function of X.
Put a range of X values in the first column, & calculate the corresponding Y values in the next column (and in the third & subsequent columns if you've got more than one equation that you want to plot together). Select the two (or more) columns. Insert/ Chart/ XY Scatter. -- David Biddulph "raidven" wrote in message ... I want to know how can I graph equations from linear equations to quartic or higher degree equations using excel charts utility? |
How can I graph quadratic or quartic equations
Thanks Mr. D. Biddulph. Thanks very much. When I posted my question I had
already done what you instructed, but the resulting curve was not acurated. At least not even remotely alike the one resulting in a graphic calculator as the TI-83. Even though the resulting values of f(x) were correct. That was the reason why I did asked my question. Do you know another method to do it more acurately. "David Biddulph" wrote: Decide your expression(s) for Y as a function of X. Put a range of X values in the first column, & calculate the corresponding Y values in the next column (and in the third & subsequent columns if you've got more than one equation that you want to plot together). Select the two (or more) columns. Insert/ Chart/ XY Scatter. -- David Biddulph "raidven" wrote in message ... I want to know how can I graph equations from linear equations to quartic or higher degree equations using excel charts utility? |
How can I graph quadratic or quartic equations
Did you use appropriate significant digits in your coefficients? Probably,
if the calculated Y values are accurate, as you state. Did you make an XY chart? A Line chart will not portray X values accurately, and this is the most common reason for people to get inaccurate charts. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "raidven" wrote in message ... Thanks Mr. D. Biddulph. Thanks very much. When I posted my question I had already done what you instructed, but the resulting curve was not acurated. At least not even remotely alike the one resulting in a graphic calculator as the TI-83. Even though the resulting values of f(x) were correct. That was the reason why I did asked my question. Do you know another method to do it more acurately. "David Biddulph" wrote: Decide your expression(s) for Y as a function of X. Put a range of X values in the first column, & calculate the corresponding Y values in the next column (and in the third & subsequent columns if you've got more than one equation that you want to plot together). Select the two (or more) columns. Insert/ Chart/ XY Scatter. -- David Biddulph "raidven" wrote in message ... I want to know how can I graph equations from linear equations to quartic or higher degree equations using excel charts utility? |
How can I graph quadratic or quartic equations
Thanks Mr. Peltier. Yes I made an XY chart using curve lines... and the
digits in my coefficients were correct. I think I did everything ok. I mean I calculated the values of f(x) for each value of x in a range -10 to +10. The resulting values were exact... Then I did <Insert, Object,Chart, Scatter... and the resulting graph wasn't even remotely alike the one that you get in the graphic calculator. Thanks anyway... "Jon Peltier" wrote: Did you use appropriate significant digits in your coefficients? Probably, if the calculated Y values are accurate, as you state. Did you make an XY chart? A Line chart will not portray X values accurately, and this is the most common reason for people to get inaccurate charts. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "raidven" wrote in message ... Thanks Mr. D. Biddulph. Thanks very much. When I posted my question I had already done what you instructed, but the resulting curve was not acurated. At least not even remotely alike the one resulting in a graphic calculator as the TI-83. Even though the resulting values of f(x) were correct. That was the reason why I did asked my question. Do you know another method to do it more acurately. "David Biddulph" wrote: Decide your expression(s) for Y as a function of X. Put a range of X values in the first column, & calculate the corresponding Y values in the next column (and in the third & subsequent columns if you've got more than one equation that you want to plot together). Select the two (or more) columns. Insert/ Chart/ XY Scatter. -- David Biddulph "raidven" wrote in message ... I want to know how can I graph equations from linear equations to quartic or higher degree equations using excel charts utility? |
How can I graph quadratic or quartic equations
raidven -
I don't understand. If you already have an XY (Scatter) chart with correct results, why are you choosing Insert | Object | Microsoft Graph Chart | ... ? - Mike http://www.mikemiddleton.com "raidven" wrote in message ... Thanks Mr. Peltier. Yes I made an XY chart using curve lines... and the digits in my coefficients were correct. I think I did everything ok. I mean I calculated the values of f(x) for each value of x in a range -10 to +10. The resulting values were exact... Then I did <Insert, Object,Chart, Scatter... and the resulting graph wasn't even remotely alike the one that you get in the graphic calculator. Thanks anyway... "Jon Peltier" wrote: Did you use appropriate significant digits in your coefficients? Probably, if the calculated Y values are accurate, as you state. Did you make an XY chart? A Line chart will not portray X values accurately, and this is the most common reason for people to get inaccurate charts. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "raidven" wrote in message ... Thanks Mr. D. Biddulph. Thanks very much. When I posted my question I had already done what you instructed, but the resulting curve was not acurated. At least not even remotely alike the one resulting in a graphic calculator as the TI-83. Even though the resulting values of f(x) were correct. That was the reason why I did asked my question. Do you know another method to do it more acurately. "David Biddulph" wrote: Decide your expression(s) for Y as a function of X. Put a range of X values in the first column, & calculate the corresponding Y values in the next column (and in the third & subsequent columns if you've got more than one equation that you want to plot together). Select the two (or more) columns. Insert/ Chart/ XY Scatter. -- David Biddulph "raidven" wrote in message ... I want to know how can I graph equations from linear equations to quartic or higher degree equations using excel charts utility? |
How can I graph quadratic or quartic equations
Strange, I don't see the reply.
There might be a difference in the algorithms used to generate the smoothed curve. I avoid smoothed lines in charts whenever possible, because they can give a false sense of where the function goes. Another point, how do you know the graphing calculator is accurate? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Mike Middleton" wrote in message ... raidven - I don't understand. If you already have an XY (Scatter) chart with correct results, why are you choosing Insert | Object | Microsoft Graph Chart | ... ? - Mike http://www.mikemiddleton.com "raidven" wrote in message ... Thanks Mr. Peltier. Yes I made an XY chart using curve lines... and the digits in my coefficients were correct. I think I did everything ok. I mean I calculated the values of f(x) for each value of x in a range -10 to +10. The resulting values were exact... Then I did <Insert, Object,Chart, Scatter... and the resulting graph wasn't even remotely alike the one that you get in the graphic calculator. Thanks anyway... "Jon Peltier" wrote: Did you use appropriate significant digits in your coefficients? Probably, if the calculated Y values are accurate, as you state. Did you make an XY chart? A Line chart will not portray X values accurately, and this is the most common reason for people to get inaccurate charts. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "raidven" wrote in message ... Thanks Mr. D. Biddulph. Thanks very much. When I posted my question I had already done what you instructed, but the resulting curve was not acurated. At least not even remotely alike the one resulting in a graphic calculator as the TI-83. Even though the resulting values of f(x) were correct. That was the reason why I did asked my question. Do you know another method to do it more acurately. "David Biddulph" wrote: Decide your expression(s) for Y as a function of X. Put a range of X values in the first column, & calculate the corresponding Y values in the next column (and in the third & subsequent columns if you've got more than one equation that you want to plot together). Select the two (or more) columns. Insert/ Chart/ XY Scatter. -- David Biddulph "raidven" wrote in message ... I want to know how can I graph equations from linear equations to quartic or higher degree equations using excel charts utility? |
All times are GMT +1. The time now is 08:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com