How can I graph quadratic or quartic equations

MS EXCEL

    Next

  • 1. how to add overlay line chart to stacked bar
    I'm using Microsoft Excel for Mac OS X. I'm trying to create an overlay chart with a stacked bar with a line over it. I can only get it to do a regular bar chart with a line over it. What am I doing wrong? Thanks!

How can I graph quadratic or quartic equations

Postby cmFpZHZlbg » Thu, 02 Nov 2006 06:45:01 GMT

I want to know how can I graph equations from linear equations to quartic or 
higher degree equations using excel charts utility?

Re: How can I graph quadratic or quartic equations

Postby David Biddulph » Thu, 02 Nov 2006 06:54:29 GMT

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








Re: How can I graph quadratic or quartic equations

Postby cmFpZHZlbg » Thu, 02 Nov 2006 08:18:01 GMT

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.








Re: How can I graph quadratic or quartic equations

Postby Jon Peltier » Thu, 02 Nov 2006 08:44:02 GMT

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/ 
_______













Re: How can I graph quadratic or quartic equations

Postby cmFpZHZlbg » Thu, 02 Nov 2006 09:16:01 GMT

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...












Re: How can I graph quadratic or quartic equations

Postby Mike Middleton » Thu, 02 Nov 2006 15:58:06 GMT

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/ 
















Re: How can I graph quadratic or quartic equations

Postby Jon Peltier » Fri, 03 Nov 2006 00:32:12 GMT

trange, 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" < XXXX@XXXXX.COM > wrote in message
news:%23xpYfMY$ XXXX@XXXXX.COM ...



Similar Threads:

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

7. solve quadratic equation system

8. Quadratic Equation



Return to MS EXCEL

 

Who is online

Users browsing this forum: No registered users and 16 guest