ADVANCED EXCEL

profileoguzhansaglik
ConfidenceIntervalTtestex.xlsx
Home>Computer Science homework help>ADVANCED EXCEL

Sheet1

0.9750021049 0.0249978951 0.8413447461 0.1586552539 0.9772498681
0.0227501319 0.9750021049

Sheet2

Minutes Minutes
45 50
50 47 t-Test: One Sample Assuming Unequal Variances
46 46
37 62 Minutes Minutes
42 37 Mean 46.75
38 42 Variance 130.2142857143
43 43 Observations 8
73 59 Hypothesized Mean Difference 42
df 7
t Stat 1.1773600265
P(T<=t) one-tail 0.138763597
t Critical one-tail 1.8945786051
P(T<=t) two-tail 0.2775271939
t Critical two-tail 2.3646242516

Sheet3

Minutes Minutes
45 50
50 47 t-Test: Two-Sample Assuming Unequal Variances
46 46
37 62 Minutes Minutes
42 37 Mean 46.75 48.25
38 42 Variance 130.2142857143 72.5
43 43 Observations 8 8
73 59 Hypothesized Mean Difference 42
df 13
t Stat -8.6415584688
P(T<=t) one-tail 0.0000004758
t Critical one-tail 1.770933396
P(T<=t) two-tail 0.0000009516
t Critical two-tail 2.1603686565