ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How can I graph quadratic or quartic equations (https://www.excelbanter.com/charts-charting-excel/116928-how-can-i-graph-quadratic-quartic-equations.html)

raidven

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?

David Biddulph

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?




raidven

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?





Jon Peltier

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?







raidven

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?







Mike Middleton

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?









Jon Peltier

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