Business analytics

profileSenice
Homework5.xlsx
Home>Business & Finance homework help>Business analytics

Homework Document

43683

P 7.30

Relationship Status µ1 Married Number of Vacations per Year µ1 Relationship Status µ2 Single/Divorced Number of Vacations per Year µ2 Operator Symbols Use the specific symbols to answer question 1 and 2 Note: Only use an alph=.05 for this problem, ignore a test at alpha=.01.
Married 1 2 Single/Divorced 1 0 <= For H0 what operator is used? =
Married 2 4 Single/Divorced 2 6 => For H1 what operator is used? <
Married 3 2 Single/Divorced 3 7 > What is the P value of the test? 0.050392
Married 4 4 Single/Divorced 4 6 < What is the decision? Type Fail To Reject or Reject fail to reject
Married 5 2 Single/Divorced 5 4 ≠
Married 6 1 Single/Divorced 6 5 =
Married 7 4 Single/Divorced 7 2
Married 8 1 Single/Divorced 8 1
Married 9 5 Single/Divorced 9 2
Married 10 1 Single/Divorced 10 6
Married 11 2
Married 12 1
Married 13 5
Married 14 2
Married 15 2
Married 16 1
Married 17 2
Married 18 2
Married 19 3
Married 20 2
Married 21 2
Married 22 2
Married 23 1
Married 24 5
43683

Hypothesis Test P 7.30

QUESTION 1 .P7.30
Number of vacations
married single/ divorced
2 0
4 6
2 7
4 6
2 4
1 5
4 2
1 1
5 2
1 6
2
1
5
2
2
1
2
2
3
2
2
2
1
5
Navigate data analysis to T test for two samples assuming unequal variance
t-Test: Two-Sample Assuming Unequal Variances
Variable 1 Variable 2
Mean 2.416666667 3.9
Variance 1.81884058 6.1
Observations 24 10
Hypothesized Mean Difference 0
df 11
t Stat -1.791202793
P(T<=t) one-tail 0.050391771
t Critical one-tail 1.795884819
P(T<=t) two-tail 0.100783543
t Critical two-tail 2.20098516
stating the null and alternate hypothesis
H0=u1-u2=0
H1=u1-u2<0
test for stats = -1.79
Critical t =1.795885
p value = 0.050392
Decision we reject the null hypothesis because p value ≤ α,
conclusion we conclude that the vacation taken by married individuals is less than the one taken by single/ divorced individuals
43683

P 7.34

Credit Risk High µ1 Months Employed HR µ1 Credit Risk Low µ2 Months Employed LR µ2 Operator Symbols Use the specific symbols to answer question 1 and 2 Note: Change to the problem, use a significance level of .05, not .01.
Person 1 0 Person 1 12 <= For H0 what operator is used? =
Person 2 119 Person 2 45 => For H1 what operator is used? ≠
Person 3 14 Person 3 13 > What is the P value of the test? 0.05115
Person 4 9 Person 4 16 < What is the decision? Type Fail To Reject or Reject Failed to reject
Person 5 4 Person 5 2 ≠
Person 6 0 Person 6 15 =
Person 7 63 Person 7 14
Person 8 4 Person 8 26
Person 9 2 Person 9 8
Person 10 16 Person 10 33
Person 11 5 Person 11 116
Person 12 23 Person 12 15
Person 13 23 Person 13 33
Person 14 58 Person 14 46
Person 15 7 Person 15 24
Person 16 46 Person 16 12
Person 17 1 Person 17 32
Person 18 42 Person 18 2
Person 19 74 Person 19 34
Person 20 33 Person 20 41
Person 21 3 Person 21 40
Person 22 75 Person 22 0
Person 23 8 Person 23 26
Person 24 5 Person 24 60
Person 25 6 Person 25 1
Person 26 114 Person 26 119
Person 27 5 Person 27 5
Person 28 60 Person 28 36
Person 29 10 Person 29 10
Person 30 8 Person 30 28
Person 31 4 Person 31 16
Person 32 0 Person 32 32
Person 33 5 Person 33 46
Person 34 9 Person 34 17
Person 35 69 Person 35 115
Person 36 2 Person 36 31
Person 37 3 Person 37 0
Person 38 17 Person 38 81
Person 39 3 Person 39 28
Person 40 20 Person 40 85
Person 41 59 Person 41 32
Person 42 3 Person 42 0
Person 43 25 Person 43 9
Person 44 3 Person 44 6
Person 45 11 Person 45 14
Person 46 79 Person 46 65
Person 47 13 Person 47 14
Person 48 21 Person 48 2
Person 49 13 Person 49 1
Person 50 14 Person 50 93
Person 51 41 Person 51 108
Person 52 22 Person 52 16
Person 53 14 Person 53 88
Person 54 45 Person 54 1
Person 55 89 Person 55 9
Person 56 20 Person 56 21
Person 57 14 Person 57 6
Person 58 15 Person 58 24
Person 59 12 Person 59 15
Person 60 53 Person 60 81
Person 61 0 Person 61 14
Person 62 56 Person 62 9
Person 63 42 Person 63 18
Person 64 21 Person 64 79
Person 65 10 Person 65 94
Person 66 20 Person 66 73
Person 67 87 Person 67 94
Person 68 54 Person 68 23
Person 69 2 Person 69 6
Person 70 20 Person 70 99
Person 71 13 Person 71 7
Person 72 89 Person 72 10
Person 73 17 Person 73 0
Person 74 3 Person 74 3
Person 75 5 Person 75 25
Person 76 7 Person 76 63
Person 77 15 Person 77 78
Person 78 9 Person 78 36
Person 79 8 Person 79 6
Person 80 48 Person 80 19
Person 81 55 Person 81 3
Person 82 1 Person 82 2
Person 83 111 Person 83 37
Person 84 2 Person 84 14
Person 85 1 Person 85 54
Person 86 2 Person 86 14
Person 87 11 Person 87 0
Person 88 4 Person 88 2
Person 89 4 Person 89 5
Person 90 3 Person 90 19
Person 91 1 Person 91 24
Person 92 19 Person 92 14
Person 93 0 Person 93 93
Person 94 0 Person 94 96
Person 95 42 Person 95 35
Person 96 4 Person 96 48
Person 97 0 Person 97 85
Person 98 10 Person 98 100
Person 99 20 Person 99 7
Person 100 14 Person 100 36
Person 101 20 Person 101 3
Person 102 4 Person 102 47
Person 103 2 Person 103 12
Person 104 0 Person 104 5
Person 105 13 Person 105 66
Person 106 90 Person 106 4
Person 107 15 Person 107 0
Person 108 6 Person 108 4
Person 109 0 Person 109 108
Person 110 2 Person 110 0
Person 111 35 Person 111 23
Person 112 0 Person 112 19
Person 113 45 Person 113 57
Person 114 24 Person 114 9
Person 115 14 Person 115 21
Person 116 19 Person 116 12
Person 117 58 Person 117 11
Person 118 3 Person 118 41
Person 119 4 Person 119 71
Person 120 2 Person 120 74
Person 121 6 Person 121 29
Person 122 3 Person 122 2
Person 123 4 Person 123 108
Person 124 111 Person 124 8
Person 125 21 Person 125 42
Person 126 17 Person 126 70
Person 127 85 Person 127 35
Person 128 37 Person 128 9
Person 129 1 Person 129 0
Person 130 22 Person 130 83
Person 131 40 Person 131 1
Person 132 6 Person 132 3
Person 133 83 Person 133 89
Person 134 0 Person 134 26
Person 135 7 Person 135 38
Person 136 18 Person 136 46
Person 137 49 Person 137 66
Person 138 52 Person 138 75
Person 139 28 Person 139 27
Person 140 31 Person 140 5
Person 141 36 Person 141 4
Person 142 35 Person 142 53
Person 143 61 Person 143 5
Person 144 15 Person 144 21
Person 145 23 Person 145 65
Person 146 14 Person 146 17
Person 147 103 Person 147 0
Person 148 24 Person 148 71
Person 149 15 Person 149 22
Person 150 7 Person 150 118
Person 151 119 Person 151 22
Person 152 29 Person 152 17
Person 153 54 Person 153 11
Person 154 90 Person 154 65
Person 155 28 Person 155 13
Person 156 4 Person 156 34
Person 157 28 Person 157 20
Person 158 81 Person 158 3
Person 159 57 Person 159 13
Person 160 2 Person 160 22
Person 161 119 Person 161 14
Person 162 13 Person 162 0
Person 163 2 Person 163 0
Person 164 33 Person 164 36
Person 165 83 Person 165 62
Person 166 5 Person 166 0
Person 167 18 Person 167 67
Person 168 101 Person 168 12
Person 169 75 Person 169 9
Person 170 42 Person 170 107
Person 171 19 Person 171 24
Person 172 20 Person 172 114
Person 173 30 Person 173 16
Person 174 59 Person 174 111
Person 175 21 Person 175 102
Person 176 10 Person 176 29
Person 177 90 Person 177 77
Person 178 32 Person 178 21
Person 179 62 Person 179 31
Person 180 46 Person 180 9
Person 181 73 Person 181 27
Person 182 40 Person 182 14
Person 183 5 Person 183 99
Person 184 2 Person 184 89
Person 185 16 Person 185 2
Person 186 0 Person 186 6
Person 187 7 Person 187 1
Person 188 22 Person 188 95
Person 189 27 Person 189 92
Person 190 65 Person 190 23
Person 191 105 Person 191 9
Person 192 40 Person 192 41
Person 193 109 Person 193 5
Person 194 3 Person 194 47
Person 195 24 Person 195 17
Person 196 21 Person 196 26
Person 197 51 Person 197 93
Person 198 17 Person 198 3
Person 199 92 Person 199 4
Person 200 52 Person 200 37
Person 201 40 Person 201 23
Person 202 13 Person 202 40
Person 203 0 Person 203 23
Person 204 11 Person 204 17
Person 205 3 Person 205 30
Person 206 5 Person 206 69
Person 207 25 Person 207 106
Person 208 5 Person 208 4
Person 209 53 Person 209 24
Person 210 103 Person 210 7
Person 211 6 Person 211 91
Person 212 70
Person 213 51
Person 214 39
43683

Hypothesis Test P 7.34

Months employed A Months employed B
0 12
119 45
14 13
9 16 Navigate to data analysis and choose t test for two samples assuming equal variance
4 2
0 15
63 14 t-Test: Two-Sample Assuming Equal Variances
4 26
2 8 Variable 1 Variable 2
16 33 Mean 28.8246445498 34.9252336449
5 116 Variance 953.8310088016 1112.5953227151
23 15 Observations 211 214
23 33 Pooled Variance 1033.7761597793
58 46 Hypothesized Mean Difference 0
7 24 df 423
46 12 t Stat -1.955744723
1 32 P(T<=t) one-tail 0.0255765588
42 2 t Critical one-tail 1.6484638683
74 34 P(T<=t) two-tail 0.0511531177
33 41 t Critical two-tail 1.965587999
3 40
75 0 hypothesis testing
8 26
5 60 H0; u1=u2
6 1
114 119 H1;u1≠u2
5 5 since the p value of the two tail test is not less than 0.05 and is 0.05115 then the Decision Fialed to reject null hypothesis
60 36 Conclusion; it is concluded that the mean values of low and high credit risks are the same
10 10
8 28
4 16
0 32
5 46
9 17
69 115
2 31
3 0
17 81
3 28
20 85
59 32
3 0
25 9
3 6
11 14
79 65
13 14
21 2
13 1
14 93
41 108
22 16
14 88
45 1
89 9
20 21
14 6
15 24
12 15
53 81
0 14
56 9
42 18
21 79
10 94
20 73
87 94
54 23
2 6
20 99
13 7
89 10
17 0
3 3
5 25
7 63
15 78
9 36
8 6
48 19
55 3
1 2
111 37
2 14
1 54
2 14
11 0
4 2
4 5
3 19
1 24
19 14
0 93
0 96
42 35
4 48
0 85
10 100
20 7
14 36
20 3
4 47
2 12
0 5
13 66
90 4
15 0
6 4
0 108
2 0
35 23
0 19
45 57
24 9
14 21
19 12
58 11
3 41
4 71
2 74
6 29
3 2
4 108
111 8
21 42
17 70
85 35
37 9
1 0
22 83
40 1
6 3
83 89
0 26
7 38
18 46
49 66
52 75
28 27
31 5
36 4
35 53
61 5
15 21
23 65
14 17
103 0
24 71
15 22
7 118
119 22
29 17
54 11
90 65
28 13
4 34
28 20
81 3
57 13
2 22
119 14
13 0
2 0
33 36
83 62
5 0
18 67
101 12
75 9
42 107
19 24
20 114
30 16
59 111
21 102
10 29
90 77
32 21
62 31
46 9
73 27
40 14
5 99
2 89
16 2
0 6
7 1
22 95
27 92
65 23
105 9
40 41
109 5
3 47
24 17
21 26
51 93
17 3
92 4
52 37
40 23
13 40
0 23
11 17
3 30
5 69
25 106
5 4
53 24
103 7
6 91
70
51
39
43683

P 7.35

Marital Status Hrs of TV viewing per week µ1 Marital Status Hrs of TV viewing per week µ2 Operator Symbols Use the specific symbols to answer question 1 and 2
Married 6 Single 40 <= For H0 what operator is used? =
Married 16 Single 16 => For H1 what operator is used? ≠
Married 12 Single 15 > What is the P value of the test? 0.294903962
Married 20 Single 10 < What is the decision? Type Fail To Reject or Reject Failed to reject
Married 10 Single 15 ≠
Married 12 Single 12 =
Married 15 Single 35
Married 6 Single 21
Married 20 Single 5
Married 30 Single 5
Single 15
Single 20
Single 10
Single 16
Single 15
43683

Hypothesis Test P 7.35

Hours of viewing Tv
Married Single
6 40
16 16 Test for statistics
12 15 Assuming that the two samples have equal variance then ;
20 10 Navigate to data analysis test for stats for two samples assuming equal variance
10 15
12 12 t-Test: Two-Sample Assuming Equal Variances
15 35
6 21 Variable 1 Variable 2
20 5 Mean 14.7 16.6666666667
30 5 Variance 53.3444444444 93.2380952381
15 Observations 10 15
20 Pooled Variance 77.6275362319
10 Hypothesized Mean Difference 0
16 df 23
15 t Stat -0.5467621981
P(T<=t) one-tail 0.2949039621
t Critical one-tail 1.7138715277
P(T<=t) two-tail 0.5898079241
t Critical two-tail 2.0686576104
Hypothesis Testing
H0; u1= u2
H1; u1= u2
test for stats = -0.546762198
P value =0.294903962
since it is observed that |t| =0.547 ≤ tc2.069 then the Decision fail to reject the null hypothesis
Conclusion the nul hypothesis is not rejected therefore there is no enough evidence to claim population mean u1 is different than u2 at 0.05significant level
43683

P 7.36

Gender F GPA for Female µ1 Gender M GPA for Male µ2 Operator Symbols Use the specific symbols to answer question 1 and 2
F 1 3.6 M 1 2.9 <= For H0 what operator is used? =
F 2 3.3 M 2 3.1 => For H1 what operator is used? ≠
F 3 2.9 M 3 3.5 > What is the P value of the test? 0.90469732
F 4 3.4 M 4 3.2 < What is the decision? Type Fail To Reject or Reject failed to reject
F 5 4 M 5 3.7 ≠
F 6 4 M 6 2.6 =
F 7 4 M 7 3.3
F 8 3.7 M 8 3.5
F 9 3 M 9 2.9
F 10 3.2 M 10 4
F 11 3 M 11 4
F 12 2.5 M 12 3
F 13 2.7 M 13 2.8
F 14 3.2 M 14 3.3
F 15 2.8 M 15 3.2
43683

Hypothesis Test P 7.36

GPA for both genders
male female
2.9 3.6 test for statistics using data analysis feasture unequal variance alpha =0.05
3.1 3.3
3.5 2.9
3.2 3.4 t-Test: Two-Sample Assuming Unequal Variances
3.7 4
2.6 4 Variable 1 Variable 2
3.3 4 Mean 3.2666666667 3.2866666667
3.5 3.7 Variance 0.1723809524 0.2383809524
2.9 3 Observations 15 15
4 3.2 Hypothesized Mean Difference 0
4 3 df 27
3 2.5 t Stat -0.1208594311
2.8 2.7 P(T<=t) one-tail 0.4523486598
3.3 3.2 t Critical one-tail 1.7032884457
3.2 2.8 P(T<=t) two-tail 0.9046973197
t Critical two-tail 2.0518305165
hypothesis testing
H0; u1= u2
H1; u1≠ u2
p value = 0.90469732
Decision fail to reject null hypothesis because p value for two tail is greater than alpha p value (0.90469732)›(0.05)α alppha
Conclusion the male and female have the same average GPA scores
43683

P 7.38

Student Writing Reading Operator Symbols Use the specific symbols to answer question 1 and 2 Note: Change to the problem, test the means, not the variances.
1 76 65 <= For H0 what operator is used? =
2 84 90 => For H1 what operator is used? ≠
3 79 68 > What is the P value of the test? 0.289874558
4 88 84 < What is the decision? Type Fail To Reject or Reject Failed to reject
5 76 61 ≠
6 66 79 =
7 77 73
8 94 93
9 66 60
10 92 86
11 80 53
12 87 83
13 86 55
14 63 72
15 92 87
16 75 89
17 69 81
18 92 94
19 79 78
20 60 71
21 68 84
22 71 74
23 61 74
24 68 54
25 76 94
26 72 79
27 99 89
28 58 53
29 82 78
30 72 82
31 77 69
32 95 98
33 72 93
34 71 80
35 72 82
36 96 96
37 72 61
38 89 84
39 94 97
40 85 89
41 60 72
42 66 93
43 96 84
44 83 87
45 88 99
46 92 97
47 78 92
48 85 93
49 91 78
50 74 82
51 96 99
52 80 72
53 62 79
54 70 75
55 87 90
56 89 95
43683

Hypothesis Test P 7.38

student
Reading Writing
65 76
90 84
68 79
84 88
61 76
79 66
73 77
93 94
60 66
86 92
53 80
83 87
55 86
72 63
87 92
89 75 test the mean using data analysis tool
81 69 T test fot two paired samples
94 92 t-Test: Paired Two Sample for Means
78 79
71 60 Variable 1 Variable 2
84 68 Mean 80.6964285714 79.0714285714
74 71 Variance 159.2334415584 124.8675324675
74 61 Observations 56 56
54 68 Pearson Correlation 0.5482902802
94 76 Hypothesized Mean Difference 0
79 72 df 55
89 99 t Stat 1.0686965785
53 58 P(T<=t) one-tail 0.1449372788
78 82 t Critical one-tail 1.6730339653
82 72 P(T<=t) two-tail 0.2898745576
69 77 t Critical two-tail 2.0040447833
98 95
93 72 Hypothesis testing
80 71 H0; u1= u2
82 72
96 96 H1; u1≠ u2
61 72
84 89 p value two tail = 0.289874558
97 94 the decision fail to reject null hypothesis p value two tail (0.289874558)› (0.05) α
89 85
72 60 we conclude that the marks of student for reading and wrinting is the same score
93 66
84 96
87 83
99 88
97 92
92 78
93 85
78 91
82 74
99 96
72 80
79 62
75 70
90 87
95 89
80.6964285714 79.0714285714 Mean
43683

image1.wmf