A study conducted in the forestry and wildlife department examined the influence of certain drug on the circulation levels of androgens in the blood. Blood samples from wild deer were obtained via the jaguar vein immediately after an intramuscular injection of the drug using darts and a capture gun. Deer were bled again approximately 30 minutes after the injection and then released.
The levels of androgens at time of capture and 30 minutes later, measured in nanograms per milliliter (ng/ml), for 10 deers are as in the table. Assuming that the populations of androgen at time of injection and 30 minutes later are normally distributed, test at the 0.05 level of significance whether the androgen concentrations are altered after 30 minutes of restraint. Solve on Excel and give Excel output and your conclusions.
Deer
|
Androgen (ng/ml) At the time of injection
|
Androgen (ng/ml) 30 minutes after injection
|
1
|
2.76
|
7.02
|
2
|
5.18
|
3.10
|
3
|
2.68
|
5.44
|
4
|
3.05
|
3.99
|
5
|
4.79
|
18.53
|
6
|
7.39
|
7.91
|
7
|
7.30
|
4.85
|
8
|
11.78
|
11.10
|
9
|
3.90
|
3.74
|
10
|
26.00
|
94.03
|