Well,
I have the following values :

I = 0 ,0.17, 0.25 , 0.42, 0.5 , 0.75 ,0.83, 1 A
V = 0, 20 , 40, 60 ,80 , 100 , 120 V
V=0 ,I=0
V=20,I=0.17
V=40 ,I=0.25
V=50 ,I=0.42
V=60 ,I=0.5
V=80 ,I=0.75
V=100 ,I=0.83
V=120 ,I=1

V=IR R=120 (V= 120i ) y=ax+b
V=x
I=y

What would I do ?!
Please help me.


"Joel" wrote:

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.


"kamy" wrote:

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