Open main menu
Home
Random
Log in
Settings
About ZCubes Wiki
Disclaimers
ZCubes Wiki
Search
Changes
← Older edit
Newer edit →
Manuals/calci/TTESTUNEQUALVARIANCES
(view source)
Revision as of 06:35, 10 February 2014
484 bytes added
,
06:35, 10 February 2014
→Examples
Line 40:
Line 40:
#=TTESTTWOSAMPLESUNEQUALVARIANCES(A1:F1,A2:F2,3,0.5)
#=TTESTTWOSAMPLESUNEQUALVARIANCES(A1:F1,A2:F2,3,0.5)
+
{| class="wikitable"
+
|+Spreadsheet
+
|-
+
! !! Variable 1 !! Variable 2
+
|-
+
! Mean
+
| 20.666666666666668 || 20.833333333333332
+
|-
+
! Variance
+
| 105.06666666666665 || 196.56666666666666
+
|-
+
! Observations
+
| 6 || 6
+
|-
+
! Hypothesized Mean Difference
+
| 3
+
|-
+
! Degree Of Freedom
+
| 9
+
|-
+
! T- Statistics
+
| -0.4466201458140038
+
|-
+
! P(T<=t) One-tail
+
| 0.3328511748583461
+
|-
+
! T Critical One-Tail
+
| 0
+
|-
+
! P(T<=t) Two-tail
+
| 0.6657023497166922
+
|-
+
! T Critical Two-Tail
+
| 0.7027221467691982
+
|}
==See Also==
==See Also==
Abin
writer
5,435
edits