| Line 19: |
Line 19: |
| | | | |
| | ==Examples== | | ==Examples== |
| − | 1.y={6,8,10,13,15,5} | + | 1. |
| − | x={1,4,9,11,20,3}
| + | {| class="wikitable" |
| − | STEYX(G1:G6,H1:H6)=1.4350701130 | + | |+Spreadsheet |
| − | 2.y={2,9,1,8,17} | + | |- |
| − | x={10,4,11,2,6}
| + | ! !! A !! B !! C !! D!! E !!F |
| − | STEYX(A1:A5,B1:B5)=5.944184833375 | + | |- |
| − | 3.y={1,2,4,5,8} | + | ! 1 |
| | + | | 6 || 8 || 10 ||13 || 15 ||5 |
| | + | |- |
| | + | ! 2 |
| | + | | 1 || 4 || 8 || 11 || 20 ||3 |
| | + | |} |
| | + | |
| | + | =STEYX(A1:F1,A2:F2)=1.4350701130 |
| | + | 2. |
| | + | {| class="wikitable" |
| | + | |+Spreadsheet |
| | + | |- |
| | + | ! !! A !! B !! C !! D!! E |
| | + | |- |
| | + | ! 1 |
| | + | | 2 || 9 || 1 ||8 || 17 |
| | + | |- |
| | + | ! 2 |
| | + | | 10 || 4 || 11 || 2 || 6 |
| | + | |} |
| | + | |
| | + | =STEYX(A1:E1,A2:E2))=5.944184833375 |
| | + | 3. |
| | + | {| class="wikitable" |
| | + | |+Spreadsheet |
| | + | |- |
| | + | ! !! A !! B !! C !! D!! E |
| | + | |- |
| | + | ! 1 |
| | + | | 1 || 2 || 4 ||5 || 8 |
| | + | |- |
| | + | ! 2 |
| | + | | 10 || 4 || 7 || 5 || |
| | + | |} |
| | + | y={1,2,4,5,8} |
| | x={10,4,7,5} | | x={10,4,7,5} |
| − | STEYX(A1:A5,B1:B4)=NAN | + | =STEYX(A1:A5,B1:B4)=NAN |
| | | | |
| | ==See Also== | | ==See Also== |