Can I create a line graph based on a formula
 

I have been doing some regression analysis manually and have worked out a
y=mx+a formula. Is it possible to create a graph based on the fomula rather
than creating a graph cost figures?

My answer is y=4.5x+16.714

Can I create a line graph based on a formula
 

Put some text in A1 and B1 (example : X and Y )
Put some x-values in A2:A20 or more
In B2 use =4.5*A2+16.714
Copy down to B20 (or more)
Select A1:B20 and use Chart Wizard to make XY chart
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Damo447" wrote in message
...
I have been doing some regression analysis manually and have worked out a
y=mx+a formula. Is it possible to create a graph based on the fomula
rather
than creating a graph cost figures?

My answer is y=4.5x+16.714

Can I create a line graph based on a formula
 

The answer is, yes you can, but in general it's far easier (and easier to
understand and debug) to use the approach which Bernard has suggested.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Damo447" wrote in message
...
I have been doing some regression analysis manually and have worked out a
y=mx+a formula. Is it possible to create a graph based on the fomula
rather
than creating a graph cost figures?

My answer is y=4.5x+16.714