Can I create a line graph based on a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

regression 1
Can I generate a mX+c Trendline Formula without a graph 2
Help with Formula 2
Overlap graph multiple axis 1
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula 2
Rolling Formula based on If 2
Breaking down a cell to create a function 5
Best method / software for graphical output from dynamic excel data 0

Back
Top