Changes

352 bytes added ,  10:55, 30 January 2014
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==
writer
5,435

edits