Excel 2007 trendline equation

[kamelkid2]

i have two sets of data:


data set A (y axis)
1.741326284
1.754947994
1.601505882
1.811138187
1.769036304
1.955898021
1.832408567
1.892568598
2.142371601


and

data set B (x axis)
11.70%
11.00%
8.80%
11.00%
9.30%
10.30%
10.30%
11.30%


there is a slight correlation (0.5041 r^2)
and a linear trendline gave the equation:

y = 8.7686x + 0.8923

is there a way i can display this equation without having to graph it? the data changes frequently enough that it becomes inconvenient to have to do this by hand each time. anybody have any insight?

[ChemistB]

y = mx +b where m = slope and b = intercept. Excel has Functions to define both so you could put into a cell
="y = " & SLOPE(y values, x values) &"x + " & INTERCEPT(y values, x values)
You might want to use the ROUND function (or TEXT Function) around SLOPE and INTERCEPT to reduce digiits.
Does that work for you?

[shg]

The formula =LINEST(Y, X) array-entered into a 5x2 range (e.g., A1:B5) will give you the slope, offset, and 8 other parameters of the fit, but the data must have the same number of X and Y values (you have 8 and 9 respectively).