File Home Insert Page Layout Formulas Data Review View Help Share Comments X Cut Calibri v 20 AA ap Wrap Text General AutoSum ~ AY O [a Copy Fill * Paste Conditional Format as Cell Insert Delete Format Sort & Find & Ideas Sensitivity Format Painter BIU TCA ~ Merge & Center $ ~ % " Formatting * Table Styles Clear Filter * Select Clipboard Font Alignment Number Styles Cells Editing Ideas Sensitivity H6 X V Since the P-value is > our level od signifiance (0.05) we fail to reject our null hypothesis B D E G Are all assumptions and Now using online 'P Value from T Score Conditions for Inference Randomly-sampled secondary school students in Canada Randomly-sampled secondary school students in Germany Calculator' and the values of t, df, and satisfied? level of significance (0.05) we can calculate our p-value Randomization condition OK sample size= n1 40 sample size= n2 40 P-value = 0.07 5 mean travel time = y 1 20.65 mean travel time = J 2 16.8 Since the P-value is > our level of Independent groups OK Standard deviation = s_1= 13.2 Standard deviation =s_2= 9.53 signifiance (0.05) we fail to reject our assumption null hypothesis Lets set our alpha level at 0.05 or 5% and calculate degree of freedom (df) using degree of freedom formula excel sheet provided to you + df = 71 HO: H1-42= 0. HA: /1-12>0. ONE TAILED TEST Because que. Asks - Do German students have shorter average travel times than Canadian students? t = (V1-12)-(U1-U2) 1.50 SE()1-V2) N'N SE ()1 - y2) = + = 2.574203275 n1 12From our calculations Two-tail probability 0.20 0.10 0.05 0.02 0.01 One-tail probability 0.10 0.05 1025 0.01 0.005 table T ar Value of to 3.078 6.314 12.706 31.821 63.657 1.886 2.920 1.303 6.965 9.925 1.638 2.353 3.182 4.541 5.841 1) Value of test statistic = 1.50 1.533 2.132 2.736 3.747 4.60- 1.476 2.015 2.57 3.365 4.032 1.44 1.943 2.447 3.143 3.707 1.415 1.895 2365 2.998 3.499 2) Degrees of freedom = 71 Two tails 1.397 1.860 2.306 2.896 3.355 1.383 1.833 2.262 2.821 3.250 10 1.372 1.812 2.228 2.764 3.169 10 1.363 1.796 2.201 2.718 3.106 3) One tailed test 1.356 1.782 2.179 2.681 3.055 12 1.350 1.771 2.160 2.650 3.012 13 1.345 1.761 2.145 2.624 2.977 14 One tail 1.341 1.753 2.131 2.602 2.947 15 1.337 1.746 2.120 2.583 2.921 16 1.333 1.740 2.110 2.567 2.898 17 1.330 1.734 2.101 2.552 2.878 18 1.328 1.729 2.093 2.539 2.861 19 1.325 1.725 2.086 2.528 2.845 20 1.323 1.721 2.080 2.518 2.83 21 1.321 1.717 2.074 2.508 2.819 22 WWNNS 1.319 1.714 2.069 2.500 2.807 23 1.318 1.71) 2064 2.492 2.797 24 1.316 1.708 2060 2.485 2.787 25 1.315 1.706 2.056 2.479 2.779 26 1.314 1.703 2.052 2.473 2.771 27 1.313 1.701 2.048 2.467 2.763 28 1.311 1.699 2045 2.462 2.756 29 .310 1.697 2.042 2.457 2.750 30 1.309 1.694 2.037 2.449 2.738 32 1.306 1.690 2.030 2.438 2.725 35 1.303 1.684 2.021 2.423 2.70 1.301 1.679 2.014 2.412 2.690 1.299 1.676 2.009 2.403 2.678 50 60 1.296 1.671 2.00 2.390 2.660 60 75 1.293 1.665 1.992 2.377 2.643 75 100 1.290 1.660 1.984 2364 2.626 100 120 1.289 1.658 1.980 2.358 2.617 120 140 1.288 1.656 1.977 2.353 2.61 140 180 1.286 1.653 1.973 2.347 2.603 180 250 1.285 1.651 1.969 2.341 2.59 250 400 1.284 1.649 1.966 2.336 2.58 400 1000 1.282 1.646 .962 2.330 2 58 100 1.282 1.645 1.960 2.326 2.576 Confidence levels 80% 90% 98 99%
