Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LINEST bug | Excel Worksheet Functions | |||
How does LINEST work? | Excel Worksheet Functions | |||
LINEST() | Excel Worksheet Functions | |||
LINEST | Excel Discussion (Misc queries) | |||
Linest - Why did they do that? | Excel Discussion (Misc queries) |