ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Using Linest cannot get seb to work? (https://www.excelbanter.com/excel-worksheet-functions/162217-using-linest-cannot-get-seb-work.html)

[email protected]

Using Linest cannot get seb to work?
 
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



All times are GMT +1. The time now is 01:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com