Hypothesis statement
Mean time per call is 14.7 minutes.
Null and alternate hypotheses
= 14.7
Ha: ? 14.7
Type of test
The two-tailed test is yes because the hypothesis states the mean time per call is 14.7 minutes.
Use z or t?
z-test is used because the sample is greater than 30, n = 100.
Rejection region
Assume alpha = .05.The rejection region falls outside of -1.96 and 1.96.
Test statistic
Z = 1.066
p-value
P = .2864
Hypothesis test result using p-value
Fail to reject p=value because .2864 > .05b alpha
Hypothesis test result using test statistic
Fail to reject null hypothesis because test statistic z = 1.066 does not fall in the rejection region.
Do the results support the claim being made?
There is not sufficient evidence to warrant rejection of the claim that mean time per call is 14.7 minutes
99% Confidence Interval for the mean
(14.35, 15.54)
Are my answers and work correct? If not, where did I go wrong? Just need to verify if I'm on the right track. I have attached the spreadsheet - Well I thought I added it but didn't. How do I add the attachment?
Sales (Y) 41 34 38 39 37 39 34 40 41 44 40 44 41 43 41 38 40 38 48 44 38 44 40 39 41 39 40 41 42 45 46 35 43 45 45 45 49 42 43 45 42 41 45 36 40 41 34 42 44 Calls (X1) 125 125 127 127 127 127 127 127 130 133 135 136 137 137 138 139 139 142 142 144 145 145 146 147 147 148 148 148 148 148 148 149 150 151 152 152 152 153 153 153 154 155 155 158 158 158 160 160 160 Time (X2) 12 19.3 12.2 15.5 15.6 20.6 18.5 15.2 19.8 16.1 13.3 18.1 17.7 18.9 15.2 12.2 15.7 17.9 14.8 15.3 15.6 15.8 18.2 13.6 16.8 14.4 15.2 14.8 13.7 16.3 15.5 19.3 15.3 13.6 17.1 21.8 19.9 14.9 17.3 13.4 13.6 14.8 11.6 17.5 15.6 13.8 13.1 16.5 14.1 Years (X3) 0 3 3 1 1 1 4 3 1 1 3 2 1 1 1 1 2 3 0 0 3 1 2 3 2 4 3 1 2 0 1 2 2 1 3 0 2 3 1 1 3 2 3 1 2 4 1 3 4 Type NONE GROUP NONE NONE GROUP GROUP NONE GROUP NONE NONE ONLINE ONLINE GROUP NONE NONE GROUP NONE NONE NONE GROUP NONE NONE GROUP GROUP GROUP GROUP GROUP GROUP NONE ONLINE GROUP NONE GROUP GROUP GROUP ONLINE ONLINE GROUP NONE GROUP ONLINE GROUP GROUP GROUP ONLINE GROUP ONLINE GROUP NONE 46 46 36 50 37 38 48 33 43 43 48 44 45 47 47 47 49 46 37 55 36 41 43 47 49 44 46 47 67 30 66 39 49 66 46 49 42 62 67 34 50 64 35 37 42 48 37 40 63 40 160 161 162 162 163 163 163 164 164 164 164 165 165 166 167 167 169 170 171 172 173 173 173 173 173 174 174 174 174 175 175 181 181 181 182 182 183 183 183 184 187 187 188 189 191 191 192 192 193 201 12.9 16.6 18.4 15.6 14.4 10.8 15.5 15.9 13.1 15.2 14.7 14.2 16.4 13.8 12.9 16.1 14.8 14.2 11.7 11.1 14.3 15.4 12.8 14.6 17.4 18.5 16.6 13.8 15.1 14.3 12.3 14.7 11.6 11.8 13.2 14.1 14.4 11.4 11.4 12.5 14.3 12.5 18.2 12.7 14.2 13.6 13.7 12.7 12.1 13.1 1 3 2 2 2 4 3 3 3 0 3 5 1 3 5 5 0 2 2 1 4 1 0 2 0 2 2 2 1 3 1 3 2 2 3 4 2 2 4 4 2 2 2 1 0 1 3 1 2 2 GROUP ONLINE ONLINE ONLINE ONLINE GROUP GROUP ONLINE ONLINE ONLINE NONE GROUP GROUP ONLINE ONLINE ONLINE ONLINE ONLINE GROUP ONLINE GROUP ONLINE ONLINE ONLINE ONLINE GROUP GROUP GROUP ONLINE GROUP NONE ONLINE NONE ONLINE ONLINE ONLINE ONLINE ONLINE ONLINE GROUP ONLINE ONLINE ONLINE ONLINE ONLINE GROUP ONLINE ONLINE ONLINE ONLINE 36 4363 204 16033 12.1 1494.7 43.63 160.33 14.947 1.13 10 1 203 ONLINE