How to key in a formula

  • Thread starter Thread starter Syahira
  • Start date Start date
S

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.
 
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
 
=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.
 
Thanks for the help.

Gary''s Student said:
=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.
Click to expand...
 
Back
Top