Can you display mathematical equations in Excel?

[Angus]

If so how would you do that. I tried making some data items, x and y,
in two columns and linking chart to the two columns - but it simply
joins the co-ordinates, eg is not smooth - and the placing of the x
and y axes is wrong. Is this they way to do it? Is there another
way?

Angus

 

[CWatters]

If so how would you do that. I tried making some data items, x and y,
in two columns and linking chart to the two columns - but it simply
joins the co-ordinates, eg is not smooth - and the placing of the x
and y axes is wrong. Is this they way to do it? Is there another
way?

Angus

One simple way might be to increase the number of data points to a few
hundred or more. They will still be joined by straight lines but they
will be very short.

You can change the axis.

Sounds like you really want curve fitting. I'm not sure Excel can do
that on it's own but there are free add on functions on the web to do that..

http://www.xlxtrfun.com/XlXtrFun/XlXtrFun.htm

I've not tried them.

Perhaps wait for a better answer from someone else.

 

[JRosenfeld]

Have you tried changing the graph type? there are several that do draw
curves through the points. Right click on the chart, click chart type..try
XYscatter

 

[Xt]

Have you tried changing the graph type? there are several that do draw
curves through the points. Right click on the chart, click chart type..try
XYscatter







- Show quoted text -

It isn't exactly clear what you want to do when you say "display
mathematical equations". If your aim is simply to illustrate graphs
of various types to students in a classroom then there are all sorts
of ways to make interactive graphs which will show the effect of, say,
changing the coefficients in y = Ax^2 + Bx + C. See
http://pt3.wikispaces.com/file/view/Interactive_Graphs.pdf for a
simple example.

Email me if you are interested. I have many examples. xt

 

[Salmon Egg]

If so how would you do that. I tried making some data items, x and y,
in two columns and linking chart to the two columns - but it simply
joins the co-ordinates, eg is not smooth - and the placing of the x
and y axes is wrong. Is this they way to do it? Is there another
way?

Angus

For the hell of it, I played about a bit with a worksheet. I selected a
cell. Then I used the Insert menu to insert an object. The first option
is entitled Microsoft Equation. Selecting this opens up a window that
allows you to construct an equation in the window.

I played around with this just long enough to put the start of an
equation including an integral that I could past a mathematical
expression in it. I leave it to you to work out the details,

I also went to Wikipedia to find a nice equation. I took a snapshot of
it using the application Grab. There are many similar applications
around. With Grab's Edit menu I copied the snapshot. I then used Excel's
Edit menu to Paste Special the picture into the Excel workbook.

It was easier to do all that than it is to describe it here. I had not
done that before.

It is past my bedtime so please tolerate my errors.

--

Sam

Conservatives are against Darwinism but for natural selection.
Liberals are for Darwinism but totally against any selection.