writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 22:
Line 22: + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
no edit summary
2. ar or x is empty.
2. ar or x is empty.
3. ar contains only one value.
3. ar contains only one value.
==Examples==
#'''Example 1'''
{| class="wikitable"
|+Spreadsheet
|-
! !! A !! B !! C !! D !! E !! F !! G
|-
! 1
| 10 || 15 || 7 || 2 || 19 || 20 || 12
|-
! 2
| 3 || 4 || 8 || 1 || 10 || 15
|}
1.ZTEST(A1:G1,4) = 0.00042944272036
2.2*MIN(ZTEST(A1:G1,4),1-ZTEST(A1:G1,4)) = 0.000858885440
3.ZTEST(A2:F2,10) = 0.9323691845
4.2*MIN(ZTEST(A2:F2,10),1-ZTEST(A2:F2,10)) = 0.135261630850
==See Also==
*[[Manuals/calci/NORMDIST | NORMDIST ]]
*[[Manuals/calci/NORMINV | NORMINV ]]
*[[Manuals/calci/NORMSDIST | NORMSDIST ]]
*[[Manuals/calci/NORMSINV | NORMSINV ]]
*[[Manuals/calci/STANDARDIZE | STANDARDIZE ]]
==References==