How to key in a formula

I have this formula, b = n (∑ty) – (∑t) (∑y)/
n (∑t2) - (∑t)2

and for each column I already assign with the function. I just don't know
how to key in in one column in order the calculation will come out
automatically. Please help me!. Thanks in advance.

Let's assume the t-values are in A1:A100, and the y values in B1:B100
The formula you need is
=COUNT(A1:A100)*(SUMPRODUCT(A1:A100,B1:B100)-SUM(A1:A100)*SUM(B1:B100))/(COUNT(A1:A100)*SUMSQ(A1:A100)-SUM(A1:A100)^2))

BUT!!!! I think you are computing the slope of a line so why not use
=SLOPE(B1:B100,A1:A100)

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Syahira" wrote in message
...
I have this formula, b = n (?ty) - (?t) (?y)/
n (?t2) - (?t)2

and for each column I already assign with the function. I just don't know
how to key in in one column in order the calculation will come out
automatically. Please help me!. Thanks in advance.

=100*SUMPRODUCT((T1:T100)*(Y1:Y100))-SUM(T1:T100)*SUM(Y1:Y100)/(100*SUMPRODUCT((T1:T100)*(T1:T100)))-SUM(T1:T100)^2

Just make sure the divisor is only the single term you posted.
--
Gary''s Student - gsnu200903


"Syahira" wrote:

I have this formula, b = n (∑ty) – (∑t) (∑y)/
n (∑t2) - (∑t)2

and for each column I already assign with the function. I just don't know
how to key in in one column in order the calculation will come out
automatically. Please help me!. Thanks in advance.

Thanks for the help.

"Gary''s Student" wrote:

=100*SUMPRODUCT((T1:T100)*(Y1:Y100))-SUM(T1:T100)*SUM(Y1:Y100)/(100*SUMPRODUCT((T1:T100)*(T1:T100)))-SUM(T1:T100)^2

Just make sure the divisor is only the single term you posted.
--
Gary''s Student - gsnu200903


"Syahira" wrote:

I have this formula, b = n (∑ty) – (∑t) (∑y)/
n (∑t2) - (∑t)2

and for each column I already assign with the function. I just don't know
how to key in in one column in order the calculation will come out
automatically. Please help me!. Thanks in advance.