ou wish to test whether a particular drug manages to bring body temperature down. So, you conduct a pilot study where 47 people receive the drug, and 45 people receive a placebo. Download the dataset 2SHT_1234 and conduct a t-test using Excel. The body temperatures of patients from the treatment group are group 1 (variable X1); those from the placebo group are group 2 (variable X2). You test at the alpha=0.05 significance level. What is (are) your critical values? (Round your answer to two decimals.) X1 X2 98.11 99.91 97.12 98.52 98.59 97.72 98.59 99.14 99.12 100.26 98.46 99.11 99.89 99.10 98.01 98.41 98.57 99.80 96.40 99.05 97.68 99.56 98.38 99.79 99.09 98.50 98.34 100.53 98.97 98.32 97.64 99.47 98.85 98.91 100.88 100.74 98.92 98.75 98.19 98.95 97.98 98.37 98.73 98.63 100.64 99.69 99.76 99.33 99.65 98.46 98.93 99.46 99.33 100.14 99.42 98.07 99.48 99.32 98.58 95.88 99.56 98.96 99.21 99.47 97.95 98.67 99.39 100.52 96.52 99.15 99.04 98.95 99.40 99.97 100.55 98.31 97.30 97.45 98.47 99.07 99.03 96.86 96.27 98.80 97.84 98.63 99.62 99.10 98.79 99.77 98.29 99.07
You wish to test whether a particular drug manages to bring body temperature down. So, you conduct a pilot study where 47 people receive the drug, and 45 people receive a placebo.
Download the dataset 2SHT_1234 and conduct a t-test using Excel. The body temperatures of patients from the treatment group are group 1 (variable X1); those from the placebo group are group 2 (variable X2).
You test at the alpha=0.05 significance level. What is (are) your critical values? (Round your answer to two decimals.)
|
X1 |
X2 |
|
98.11 |
99.91 |
|
97.12 |
98.52 |
|
98.59 |
97.72 |
|
98.59 |
99.14 |
|
99.12 |
100.26 |
|
98.46 |
99.11 |
|
99.89 |
99.10 |
|
98.01 |
98.41 |
|
98.57 |
99.80 |
|
96.40 |
99.05 |
|
97.68 |
99.56 |
|
98.38 |
99.79 |
|
99.09 |
98.50 |
|
98.34 |
100.53 |
|
98.97 |
98.32 |
|
97.64 |
99.47 |
|
98.85 |
98.91 |
|
100.88 |
100.74 |
|
98.92 |
98.75 |
|
98.19 |
98.95 |
|
97.98 |
98.37 |
|
98.73 |
98.63 |
|
100.64 |
99.69 |
|
99.76 |
99.33 |
|
99.65 |
98.46 |
|
98.93 |
99.46 |
|
99.33 |
100.14 |
|
99.42 |
98.07 |
|
99.48 |
99.32 |
|
98.58 |
95.88 |
|
99.56 |
98.96 |
|
99.21 |
99.47 |
|
97.95 |
98.67 |
|
99.39 |
100.52 |
|
96.52 |
99.15 |
|
99.04 |
98.95 |
|
99.40 |
99.97 |
|
100.55 |
98.31 |
|
97.30 |
97.45 |
|
98.47 |
99.07 |
|
99.03 |
96.86 |
|
96.27 |
98.80 |
|
97.84 |
98.63 |
|
99.62 |
99.10 |
|
98.79 |
99.77 |
|
98.29 |
|
|
99.07 |
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 3 images
