Question: Can this exercise be solved using a Z-test? The sample size > 30 and variance can be easily computed in Excel. Is it a Z-test
Can this exercise be solved using a Z-test? The sample size > 30 and variance can be easily computed in Excel. Is it a Z-test more appropriate in this case than a t-test? Please, solve in excel. Thank you in advance
The data sheet for red blood cell counts for 71 healthy subjects (40 female, 31 male) is shown below.
Specify with the significance level of 0.01 if the mean blood cell count is different in patients with different gender.
# Female Male 1 5.8 4.72 2 4.8 6.81 3 4.69 4.27 4 4.67 4.72 5 4.74 6.66 6 4.18 5.6 7 4.58 5.07 8 4.73 6.22 9 4.37 4.18 10 4.06 4.9 11 4.41 6.53 12 4.49 5.3 13 4.76 5.03 14 4.47 5.52 15 4.42 6.71 16 4.84 5.44 17 4.44 6.46 18 4.88 5.15 19 4.98 6.9 20 4.24 5.72 21 4.69 5.18 22 4.63 6.5 23 4.6 4.53 24 4.31 6.78 25 4.02 4.25 26 4.71 6.95 27 4.79 4.83 28 4.69 6.58 29 4.17 5.39 30 4.71 6.1 31 4.04 5.32 32 4.83 33 4.71 34 4.55 35 4.82 36 4.93 37 4.48 38 4.29 39 4.84 40 4.15
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
