Unit 5 Prob 1 Two Sample Hypothesis Test for the Mean (Independent Samples) Level of Significance Sample Mean Sample Size Sample Standard Deviation 0 #DIV/0! 0 #DIV/0! Standard Error (Computed) Test Statistic (Computed) #DIV/0! #DIV/0! Two-Tailed Test H1: (m1 <> m1) 0 #DIV/0! 0 #DIV/0! Lower Crit Value Upper Crit Value p-Value Decision Err:502 Err:502 #DIV/0! #DIV/0! Upper-Tail Test (m1 > m1 OR m1 < m1) n/a Err:502 #DIV/0! #DIV/0! H1: Lower-Tail Test (m1 < m1 OR m1 > m1) Err:502 n/a #DIV/0! #DIV/0! H1: If you REJECT the null hypothesis, conclude that H1 is true. If you DO NOT REJECT the null hypothesis, there is insufficient evidence to conclude that H1 is true. NEVER conclude that the null hypothesis is true (i.e., we CANNOT ACCEPT the null). 2007 DrJimMirabella.com Unit 5 Prob 2 Two Sample Hypothesis Test for the Mean (Paired Samples) Item 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Level of Significance Standard Error (Computed) Test Statistic (Computed) H 1: #DIV/0! #DIV/0! Two-Tailed Test (m d <> 1), (m1 <> m1) H1: Upper-Tail Test (md > 1), (m1 > m1 OR m1 < m1) H1: Lower-Tail Test (md < 1), (m1 < m1 OR m1 > m1) Lower Crit Value Upper Crit Value p-Value Decision Err:502 Err:502 #DIV/0! #DIV/0! n/a Err:502 #DIV/0! #DIV/0! Err:502 n/a #DIV/0! #DIV/0! If you REJECT the null hypothesis, conclude that H1 is true. If you DO NOT REJECT the null hypothesis, there is insufficient evidence to conclude that H1 is true. NEVER conclude that the null hypothesis is true (i.e., we CANNOT ACCEPT the null). 2007 DrJimMirabella.com Unit 5 Prob 3 Two Sample Hypothesis Test for the Proportion Level of Significance 0.05 Number of Successes Sample Size Proportion (Computed) #DIV/0! Z Test Statistic (Computed) #DIV/0! #DIV/0! Lower Crit Value Upper Crit Value p-Value Decision Two-Tailed Test H1: (P1 <> P2) -1.9600 1.9600 #DIV/0! #DIV/0! Upper-Tail Test H1: (P1 > P2 or P2 < P1) n/a 1.6449 #DIV/0! #DIV/0! Lower-Tail Test H1: (P1 < P2 or P2 > P1) -1.6449 n/a #DIV/0! #DIV/0! If you REJECT the null hypothesis, conclude that H1 is true. If you DO NOT REJECT the null hypothesis, there is insufficient evidence to conclude that H1 is true. NEVER conclude that the null hypothesis is true (i.e., we CANNOT ACCEPT the null). 2007 DrJimMirabella.com ANOVA SUMMARY Groups Count 0 0 0 0 0 Sum 0.000 0.000 0.000 0.000 0.000 Average Variance ANOVA Source of Variation Treatment Error SS 0.000 0.000 df -1 0 MS 0.000 #DIV/0! F #DIV/0! Total 0.000 -1 Upper Conf. Limit Difference in Treatment Means??? Null hypothesis: Alternate hypothesis: Significance level: p-Value Decision: m1 = m1 = m1 Not all the means are equal 0.05 #DIV/0! #DIV/0! Mean Differences Post-Hoc Tests Difference Comparison of Means Lower Conf. Limit F crit Err:502 Confidence Intervals of Groups 12.000 10.000 8.000 6.000 4.000 2.000 0.000 ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 Gender 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major Finance Finance Finance Finance Finance Finance Finance Finance Finance Employ Unemployed Full Time Part Time Full Time Full Time Unemployed Full Time Full Time Part Time Full Time Part Time Full Time Full Time Full Time Part Time Full Time Full Time Part Time Full Time Unemployed Full Time Part Time Full Time Full Time Part Time Full Time Part Time Unemployed Part Time Full Time Full Time Unemployed Full Time Full Time Part Time Part Time Full Time Unemployed Full Time Part Time Full Time Full Time Full Time Unemployed Age 39 55 43 56 38 54 30 37 38 42 52 35 37 53 51 40 33 53 43 35 57 32 59 48 34 53 35 38 37 46 44 31 51 47 56 42 44 54 51 42 45 55 47 43 MBA_GPA 2.82 3.49 3.28 3.25 3.26 2.87 3.16 3.40 2.84 3.72 3.22 3.44 3.65 3.02 3.03 3.80 3.23 3.26 3.53 3.75 3.15 3.66 3.36 3.79 2.85 3.74 3.23 3.52 3.32 2.89 2.83 2.93 3.71 3.47 3.52 2.83 3.64 2.96 3.59 3.33 3.38 3.44 3.31 3.03 BS GPA 3.05 3.45 3.50 3.55 3.30 3.05 3.35 3.35 3.05 3.70 3.50 3.55 3.90 3.30 3.25 3.80 3.50 3.50 3.75 3.90 3.20 3.75 3.45 3.85 3.05 3.90 3.25 3.70 3.45 3.10 3.05 3.10 3.80 3.75 3.65 3.05 3.55 3.10 3.80 3.55 3.60 3.35 3.45 3.25 Hrs_Studying Works FT 3 1 7 1 7 0 7 1 6 0 4 1 6 1 6 0 3 0 7 1 7 1 7 1 8 0 6 0 6 1 8 1 7 1 7 1 8 0 8 1 6 0 8 1 7 0 8 0 3 0 8 1 6 0 7 1 7 1 4 0 3 1 5 1 8 1 8 1 7 1 3 0 7 1 4 0 8 1 7 1 7 0 6 1 7 0 6 0 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Full Time Full Time Part Time Full Time Full Time Full Time Full Time Full Time Full Time Unemployed Full Time Part Time Full Time Full Time Part Time Full Time Full Time Full Time Full Time Full Time Full Time Unemployed Full Time Part Time Full Time Part Time Full Time Part Time Full Time Full Time Full Time Full Time Full Time Full Time Full Time Unemployed Full Time Full Time Full Time Full Time Full Time Full Time Full Time Part Time Full Time 57 36 58 46 53 59 49 34 46 46 33 56 39 51 55 38 33 34 31 37 46 31 47 54 52 43 44 34 59 45 30 32 32 40 48 51 30 31 35 33 35 31 38 46 45 3.26 3.04 2.98 2.80 3.75 3.64 3.65 3.18 3.44 3.06 3.51 3.33 2.81 3.64 3.05 2.85 3.56 2.92 3.35 3.46 3.59 3.11 3.65 3.17 2.97 3.77 3.21 3.17 3.65 2.94 3.53 3.65 3.61 3.70 2.91 3.09 3.77 3.79 3.59 3.38 3.57 2.97 3.44 3.64 3.48 3.40 3.25 3.10 3.05 3.75 3.65 3.80 3.30 3.40 3.15 3.75 3.40 3.05 3.80 3.40 3.05 3.60 3.10 3.50 3.35 3.75 3.20 3.70 3.50 3.10 3.90 3.20 3.15 3.65 3.10 3.70 3.60 3.70 3.90 3.10 3.25 3.95 3.80 3.60 3.50 3.50 3.10 3.65 3.55 3.40 7 6 5 2 8 7 8 6 7 6 8 7 2 8 7 3 7 5 7 6 8 6 8 7 5 8 6 6 7 5 8 7 8 8 5 6 9 8 7 7 7 5 7 7 7 1 0 0 0 1 1 1 0 1 1 0 1 0 1 0 1 1 0 1 1 1 0 1 0 1 1 1 0 0 0 1 1 1 1 1 0 1 1 1 1 1 0 1 1 1 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership No Major Leadership No Major Leadership Leadership No Major Leadership No Major No Major Leadership No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Full Time Full Time Full Time Full Time Part Time Full Time Full Time Full Time Full Time Full Time Full Time Unemployed Full Time Part Time Full Time Full Time Full Time Full Time Part Time Full Time Full Time Part Time Full Time Full Time Unemployed Full Time Full Time Part Time Unemployed Full Time Part Time Full Time Full Time Part Time Full Time Unemployed Part Time Full Time Part Time Full Time Unemployed Part Time Full Time Full Time Full Time 59 58 46 35 53 31 50 38 50 48 53 53 30 32 42 56 46 49 32 36 42 37 31 31 42 39 47 28 28 52 35 38 44 38 52 53 53 31 47 51 37 46 48 54 48 2.99 3.73 2.91 3.78 3.40 3.13 3.14 3.24 3.56 3.16 3.53 3.01 3.30 3.62 3.21 3.39 3.65 3.47 3.44 3.88 3.83 3.53 3.22 3.56 3.20 3.17 3.41 3.56 3.34 3.44 3.76 3.55 3.88 3.31 3.09 3.82 3.01 3.66 3.64 3.59 3.49 3.13 3.83 3.04 3.91 3.10 3.80 3.05 3.95 3.40 3.15 3.25 3.30 3.50 3.25 3.55 3.15 3.35 3.60 3.40 3.40 3.80 3.70 3.60 3.95 3.95 3.60 3.30 3.80 3.25 3.30 3.60 3.70 3.60 3.60 3.80 3.45 3.90 3.45 3.15 4.00 3.20 3.85 3.70 3.65 3.55 3.20 3.90 3.15 4.00 5 8 4 9 7 6 6 6 7 6 7 6 6 7 7 7 8 8 7 9 9 7 6 8 6 6 7 8 7 7 8 7 8 7 6 9 6 8 8 7 7 6 8 6 10 1 0 0 1 0 0 1 0 1 0 1 0 1 0 0 1 1 1 0 1 1 1 0 1 1 1 1 1 0 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Full Time Unemployed Full Time Part Time Full Time Full Time Part Time Full Time Part Time Unemployed Full Time Part Time Full Time Full Time Part Time Full Time Part Time Full Time Unemployed Full Time Part Time Full Time Full Time Part Time Unemployed Part Time Full Time Full Time Full Time Part Time Full Time Full Time Part Time Full Time Full Time Unemployed Part Time Full Time Full Time Part Time Full Time Full Time Part Time Full Time Unemployed 36 39 28 45 31 47 35 52 52 55 52 46 31 33 45 50 33 37 33 46 55 30 51 35 40 29 52 27 51 56 35 46 39 31 52 32 32 44 43 38 54 27 38 45 48 3.56 3.96 3.46 3.22 3.27 3.43 3.85 3.89 3.37 3.32 3.54 3.80 3.74 3.17 3.27 3.32 3.56 3.95 3.56 3.79 3.93 3.79 3.71 3.05 3.22 3.85 3.82 3.23 3.56 3.53 3.62 3.80 3.47 3.64 3.03 3.17 3.22 3.92 3.82 3.26 3.80 3.20 3.46 3.67 3.06 3.70 4.00 3.40 3.15 3.20 3.45 3.95 3.90 3.45 3.30 3.55 3.90 3.85 3.45 3.55 3.30 3.45 4.00 3.75 3.75 4.00 3.85 3.85 3.35 3.20 3.95 3.95 3.95 3.65 3.65 4.00 3.95 3.35 3.65 3.15 3.25 3.20 4.00 3.95 3.55 3.85 3.20 3.35 3.75 3.40 8 9 7 6 6 7 9 8 7 6 7 8 8 7 7 6 7 9 8 8 9 8 8 6 6 9 9 9 7 7 9 9 6 7 5 6 6 10 9 7 8 6 6 8 7 1 1 1 0 0 1 1 1 1 0 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 0 1 1 0 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Full Time Full Time Full Time Full Time Full Time Unemployed Full Time Full Time Full Time Unemployed Full Time Full Time Full Time Unemployed Full Time Unemployed Part Time Full Time Full Time Part Time Full Time 43 34 54 36 45 28 37 27 31 45 48 50 32 33 49 27 28 36 35 47 33 3.66 3.96 3.75 3.83 3.22 3.36 3.21 3.02 3.99 3.07 3.65 3.67 3.06 3.98 3.93 3.41 3.43 3.70 3.76 3.90 3.23 3.85 4.00 3.85 3.85 3.20 3.35 3.25 3.15 4.00 3.15 3.65 3.85 3.35 3.70 4.00 3.30 3.50 3.65 3.75 3.90 3.30 8 10 8 8 6 6 6 5 10 6 7 8 6 8 10 6 7 7 8 8 6 0 1 1 1 1 1 1 1 1 1 1 1 0 1 1 0 1 0 1 0 1 Variable descriptions Gender = 0 (female), 1 (male) Major = student's major Age = age of student in years MBA_GPA = overall GPA in the MBA program BS_GPA = overall GPA in the BS program Hrs_Studying = average hours studied per week Works FT = 0 (No), 1 (Yes)