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.

How to key in a formula
 

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.

How to key in a formula
 

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

How to key in a formula
 

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.