I want to know how can I graph equations from linear equations to quartic or higher degree equations using excel charts utility?
I want to know how can I graph equations from linear equations to quartic or higher degree equations using excel charts utility?
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
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.
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://www.**--****.com/ _______
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...
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.**--****.com/
1.Graph Simple/Quadratic equations
Is there a way to graph simple and quadratic equations in Excel? Alberto.
2.Solving quartic equations in Excel
Hi, Can someone tell me how to go about solving a quartic equation i Excel? I know there are add-ins available but I don't want to us them. Any help is greatly appreciated. Thanks. Ra
3.Solving quartic equations in Excel.
Hi. Does anyone written a method which solves quartic equations in an Excel sheet ? Th.
4.2 variables in 2 quadratic equations in excel
Dear ms excel user/programmers: I hope this question is not repeated before. But anyway highly appreciate anyone can tell me how (or hint) to use ms excell and/or visual c/c++, basic, or octave(emulate matlab) to solve: (12-x)^2 + y^2 =15^2, (16+y)^2+x^2=25^2 (by programming or using its built in function)? that ^2 mean square. looking to any excel user, mathmatician, and/or programmer's help, eric, XXXX@XXXXX.COM
5.can quadratic equations be solved in excel
6. quadratic equation and linest
Users browsing this forum: No registered users and 16 guest