Excel Exercise Week 7

suppose we want to merely determine whether or not subsequent blood pressure measurement where higher or lower than another. One approach would be to use the sign test. Refer to the SIGN TEST tab in the assignment spreadsheet.(attached to bottom) How many subjects are in the study? How many subjects blood pressure increased from the first measurement to the second? How many subjects blood pressure decreased from the first measurement to the second? For alpha of 0.05 two sided Test the critical Value= _________. Comparing the smaller of positive and negative values to the critical value which of the following is (are true)? a) there is statistically significant evidence at alpha=0.05 to show diastolic 1 Grp2 and diastolic 2 Grp2 differ from each other. b) There is not statistically significant evidence at alpha=0.05 to show diastolic 1 Grp2 and diastolic 2 Grp2 differ from each other. c) There are not enough data points to reach a conclusion. d) The tied value makes the analysis suspect.

 

90

17+

2+

-9-

10899-9-951005+94

9+

1064+

9410814+1061071+93996+921008+10398-5-99

2+

106100-6-109107-2-

108-2-

971069+

98-7-

105

-1-

110107-3-1051083+9210614+91987+110101-9-991034+10798-9-

941039+

      

16

  

11

Diastolic_1_Grp2	Diastolic_2_Grp2
				107
					106					108
	109				100
			103
102
	101
		110
		105
104
Positive=>
Negative=>