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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!