Scribd
Upload
13 views

Msci 2020 Excel Assignment

Uploaded by

salam81a4
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
13 views

Msci 2020 Excel Assignment

Uploaded by

salam81a4
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 4

Student Midterm Score Final Score

1 51 43
2 94 88
3 52 42
4 66 73
5 37 45
6 54 53
7 53 43
8 75 76
9 76 70
10 84 82
11 38 41
12 74 76
13 86 93
14 65 57
15 55 57
16 87 97
17 36 28
18 60 51
19 44 40
20 72 70
21 93 100
22 92 89
23 57 50
24 76 74
25 33 37
26 67 66
27 78 75
28 48 41
29 60 53
30 92 93
31 71 81
32 85 75
33 87 88
34 61 66
35 53 43
36 44 51
37 42 39
38 58 48
39 46 40
40 73 79
t-Test: Two-Sample Assuming Unequal Variances

Variable 1 Variable 2
Mean 64.375 62.825
Variance 319.88141025641 399.378846153846
Observations 40 40
Hypothesized Mean Dif 0
df 77
t Stat 0.365526326700114
P(T<=t) one-tail 0.357860388870552
t Critical one-tail 1.4187741637918
P(T<=t) two-tail 0.715720777741104
t Critical two-tail 1.77409871608839
Miles per Gallon
Japanese Cars US Cars
23 21
21 19
24 18
23 18
23 19
22 19
23 23
22 19
22 21
24 20
24 19
21 18
23 19
24 18
21 23
23 20
21 18
21 19
24 21
21 20
22 22
22 23
21 20
21 23
21 19
22 20
24 20
24 23
21 23
22 22
22 21
22 22
24 23
22 23
23 20
21 19
21 23
24 21
23 20
22 19
t-Test: Two-Sample Assuming Equal Variances

Variable 1 Variable 2
Mean 22.35 20.45
Variance 1.31025641025641 3.07435897435897
Observations 40 40
Pooled Variance 2.19230769230769
Hypothesized Mean Difference 0
df 78
t Stat 5.73875712444197
P(T<=t) one-tail 8.6978486853E-08
t Critical one-tail 1.57199321397085
P(T<=t) two-tail 1.7395697371E-07
t Critical two-tail 1.90854351170318

You might also like