ABC

Home Insert Page Layout Formulas Data Review View Calibri (Body) . 11 A- A- Number Conditional Forma Format as Table Paste B I U . MY A $ % $.0 Call Styles . F12 X V fx | =((B24-1)"B23^2 + (C24-1)"(23^2) / (B24+C24-2) A B C D E F G H K L M N 3 B. Apply Hypothesis test for two independent samples assuming population standard devations are equal. 4 5 Hypothesis Test #1 Treatment Placebo Sample # Group Group 0.364 0.508 HO: mul = mu2 Formulas (for reference) 2 0.536 0.472 H1: mul not= mu2 3 0.467 0.630 542 = ( (n1-1)" (s1)42 + (n2-1)" (s2)^2 ) / (n1 + n2-2) 10 4 0.635 0.639 alpha 0.10 _stat = (Xbarl - Xbar2) / (s * (sqrt(11+ 12)) 5 0.518 L347 6 0.410 1.336 542= 0.839818 df = ni+ n2 -2 7 1975 1778 t_stat 1.730 8 0.391 0.012 P-value (two-tailed] = 2 * P( T