How to key in a formula

[Syahira]

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.

 

[Bernard Liengme]

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

 

[Gary''s Student]

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

 

[Syahira]

Thanks for the help.

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