Changes

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==
writer
5,435

edits