P
pkaraffa
Based on this post (LINEST with r2 = -1.18 ???), Jerry W. Lewis showed
an approach of formulas based on what Linest gives as a result. I got
everything to work except the formula below. Linest shows 1.562910008.
With Jerrys formula below, I cannot get this result that Linest
shows. Although, for se1 = steyx/SQRT(DEVSQ(x)) I used
=STEYX(B2:B21,A2:A21)/SQRT(DEVSQ(A2:A21)) and I get the proper result
0.019697382. Cannot figure it out? Thanks.
Jerry's formula.
seb = steyx/SQRT(1/COUNT(y)+AVERAGE(x)^2/DEVSQ(x))
This is what I am using and cannot get the proper result.
=STEYX(B2:B21,A2:A21)/SQRT(1/COUNT(B2:B21)+AVERAGE(A2:A21)^2/
DEVSQ(A2:A21))
The data set is below:
106 20
95 15
43 9
78 11
93 14
87 15
100 18
76 10
89 13
95 15
99 17
87 12
32 8
106 20
43 9
17 2
64 17
55 15
22 5
97 16
an approach of formulas based on what Linest gives as a result. I got
everything to work except the formula below. Linest shows 1.562910008.
With Jerrys formula below, I cannot get this result that Linest
shows. Although, for se1 = steyx/SQRT(DEVSQ(x)) I used
=STEYX(B2:B21,A2:A21)/SQRT(DEVSQ(A2:A21)) and I get the proper result
0.019697382. Cannot figure it out? Thanks.
Jerry's formula.
seb = steyx/SQRT(1/COUNT(y)+AVERAGE(x)^2/DEVSQ(x))
This is what I am using and cannot get the proper result.
=STEYX(B2:B21,A2:A21)/SQRT(1/COUNT(B2:B21)+AVERAGE(A2:A21)^2/
DEVSQ(A2:A21))
The data set is below:
106 20
95 15
43 9
78 11
93 14
87 15
100 18
76 10
89 13
95 15
99 17
87 12
32 8
106 20
43 9
17 2
64 17
55 15
22 5
97 16