Creating a graph based on a quadratic equation.

Hello, I just got my first Mac and iWork 09.

I'm trying to create a graph in Numbers 09 based on a quadratic equation however I cannot find any way of doing this.

I just need to some simple graphs based on equations such as y = x^2 + 3x + 5

How do I make this into a graph in Numbers 09?

Oh and another question... If I have a graph with points based on X and Y data, can I turn the trend line into an equation?

Thanks

Message was edited by: conielo

Macbook, Mac OS X (10.5.6)

Posted on Mar 25, 2009 4:06 PM

Reply
3 replies

Mar 25, 2009 5:03 PM in response to conielo

To create a scatter chart, you need two columns (or rows) of data, one being X and the other being Y. So, in Column B put the X values you would like plotted. In Column C put your equation to calculate Y for each of those points.

B2 =1
B3 =2
etc

C2 =B2^2 3*B25
then fill down to fill in the rest of the rows in the column.

I'd recommend a look at the Numbers user's manual if the above doesn't make sense.

If you have plotted some X-Y data and want the trendline equation, you can turn on a trendline and have it display the equation. You can't use the coefficients from the equation unless you read them off the chart and type them into your table manually. However, you can calculate the trendline yourself in your table. That was covered in some depth in a thread from a little while back. Here's the link to that thread:

http://discussions.apple.com/thread.jspa?messageID=9015541&#9015541

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Creating a graph based on a quadratic equation.

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.