Excel - graph of y=ax+b in excel

Asked By kam on 03-Oct-07 07:59 PM

Please tell me how I can draw graph of y-ax+b in Excel ?!

Joe replied on 03-Oct-07 08:20 PM

Excel doesn't take inputs in the form of a line which is y=ax + b. It simply
requires a list of the x points and y points. Excel automatically calculates
the a value and the b value.
you enter points in two rows or two columns
Col A Col B
(x values) (Y values)
1 4
2 7
The a value is the slope = (delta y)/(delta x) = (7 -4)/(2 -1) = 3
Y = ax + b
7 = (2*3) + b
b = 1
Excel does the calculation above automatically.