Anova: Single Factor SUMMARY Groups Diastolic_2_Grp_1 Diastolic_2_Grp2 Diastolic_2_Grp3 Count 23 27 29 ANOVA Source of Variation Between Groups Within Groups SS 1.633924 909.2522 Total 910.8861 Sum 2363 2783 2988 df Average Variance 102.7391 11.3834 103.0741 14.14815 103.0345 10.39163 MS F F crit 2 0.816962 0.068286 3.116982 76 11.96384 78 Wt_Grp_3 Systolic BP_1_Grp3 Wt_Grp_3 1 Systolic B 0.241479 1 Ht_Grp_1 Mean Ht_Grp_2 Ht_Grp_3 Wt_Grp_1 69.652173913 66.444444444 64.714285714 182.347826087 Standard Error Median Mode Standard Deviation Sample Variance Kurtosis 0.7507800835 0.6255102381 0.8275308189 3.9017623948 71 66 64.5 184 65 66 69 187 3.6006147916 3.250246539 4.3788814981 18.7121950893 12.964426877 10.564102564 19.174603175 350.146245059 -1.5840746686 -1.1998041757 -1.2038168366 -0.3504530552 Skewness -0.3363851592 0.1855871166 0.1332054502 0.3846588796 Range 10 10 14 64 Minimum 64 62 58 154 Maximum 74 72 72 218 1602 1794 1812 4194 23 27 28 23 Sum Count Confidence Level(95.0%) 1.5570225879 1.2857546959 1.6979529681 8.0917599104 Upper Limt CI 71.209196501 67.73019914 66.412238682 190.439585997 Lower Limit CI 68.095151325 65.158689749 63.016332746 174.256066177 Wt_Grp_2 Wt_Grp_3 Age_Grp_1 Age_Grp_2 Age_Grp_3 183.111111111 185.214285714 65.7826086957 56.5185185185 3.9199007682 4.3889462954 0.6740724024 180 195 67 188 156 67 20.3684018733 23.2241208307 3.2327376765 414.871794872 539.35978836 10.4505928854 -1.0428313054 -1.5846031099 -1.3288003683 0.2303830228 -0.1522567307 44.75 0.5347480445 57 57 2.7786323472 7.7207977208 -0.5066298662 0.5810613351 44.5 41 3.0746875782 9.4537037037 -1.2254706258 -0.3165556133 -0.6312643925 0.294851831 63 70 9 9 9 154 150 61 51 41 217 220 70 60 50 4944 5186 1513 1526 1253 27 29 23 27 28 8.0574713465 9.005373841 1.3979405947 1.099190337 1.1922393656 191.168582458 194.219659555 67.1805492904 57.6177088555 45.9422393656 175.053639765 176.208911873 64.3846681009 55.4193281815 43.5577606344 2.7958811895 2.1983806741 2.3844787312 Group_1 Surv Group_2 Surv Group_3 Surv Systolic BP_1_Grp1 0.4642857143 0.4761904762 0.4285714286 157.9130434783 0.0959792589 0 0 0.5078745002 0.2579365079 -2.1352899408 0.1116765657 0 0 0.5117663157 0.2619047619 -2.2105263158 0.0952380952 0 0 0.5039526307 0.253968254 -2.0596153846 2.6613267839 158 152 12.7632748842 162.9011857708 -1.3701498485 0.1514607977 0.1028429917 0.3052789974 0.1221852512 1 1 1 39 0 0 0 140 1 1 1 179 13 10 12 3632 28 21 28 23 0.1969331701 0.2329532333 0.1954124279 5.5192539166 0.6612188844 0.7091437095 0.6239838565 163.4322973948 0.2673525442 0.2432372429 0.2331590007 152.3937895617 Diastolic_1_Grp_1 Mean BP_1_Grp_1 Systolic BP_2_Grp1 100.9565217391 119.9420289855 162.1304347826 1.2845667375 101 101 6.1605656534 37.95256917 -1.023091066 1.4500393243 120.6666666667 115 6.9541443017 48.3601229688 -1.0682807681 2.3391363122 160 158 11.2181036634 125.8458498024 -0.7010044888 -0.1788752633 0.0449683718 0.3871803024 20 23 39 90 109.3333333333 145 110 132.3333333333 184 2322 2758.6666666667 3729 23 23 23 2.6640283485 3.0071974882 4.8510717776 103.6205500876 122.9492264737 166.9815065602 98.2924933907 116.9348314973 157.279363005 Diastolic_2_Grp_1 Mean BP_2_Grp_1 Systolic BP_1_Grp2 102.7391304348 122.5362318841 138.8518518519 0.7035129 102 99 3.3739293427 11.3833992095 -1.3713265129 0.8813539935 122.6666666667 118 4.2268252652 17.8660518226 -1.2607343464 2.0937457428 136 125 10.8794220141 118.3618233618 -1.1491447485 0.2468008092 -0.1468132877 0.429537413 10 13.3333333333 33 98 115 125 108 128.3333333333 158 2363 2818.3333333333 3749 23 23 27 1.4589964494 1.8278163019 4.3037559692 104.1981268842 124.364048186 143.1556078211 101.2801339854 120.7084155821 134.5480958826 Diastolic_1_Grp2 Mean BP_1_Grp2 Systolic BP_2_Grp2 101.1481481481 113.7160493827 166.6296296296 1.3276628392 103 106 6.8987384783 47.5925925926 -1.5442934008 1.041206064 114 114.6666666667 5.4102654118 29.2709718265 -0.6878750843 2.2853105471 169 169 11.874821936 141.0113960114 -1.187750661 -0.231528 -0.1640067578 -0.1908867475 20 18.6666666667 38 90 104.3333333333 146 110 123 184 2731 3070.3333333333 4499 27 27 27 2.7290500238 2.1402296952 4.6975230599 103.8771981719 115.8562790779 171.3271526896 98.4190981244 111.5758196875 161.9321065697 Diastolic_2_Grp2 Mean BP_2_Grp2 Systolic BP_1_Grp3 103.0740740741 124.2592592593 135.4285714286 0.7238822328 103 107 3.7614024177 14.1481481481 -1.6555982145 0.8107252982 125 126.6666666667 4.2126522223 17.7464387464 0.1064622765 2.0602232962 136 150 10.9016769741 118.8465608466 -1.0549392047 0.0033127891 -0.3736955711 -0.2319929697 10 17.6666666667 35 98 114 115 108 131.6666666667 150 2783 3355 3792 27 27 28 1.487961225 1.6664697007 4.2272289815 104.5620352991 125.92572896 139.6558004101 101.586112849 122.5927895585 131.2013424471 Diastolic_1_Grp3 Mean BP_1_Grp3 Systolic BP_2_Grp3 99.3571428571 111.380952381 161 1.0937705834 100 104 5.7876899103 33.4973544974 -0.9059789451 1.1626555241 112 107.3333333333 6.1521947542 37.8495002939 -0.7328648113 1.6824648082 160.5 149 8.902766944 79.2592592593 -1.0856754114 -0.2469432596 -0.4361527359 0.0668133707 19 21.3333333333 32 90 98.3333333333 146 109 119.6666666667 178 2782 3118.6666666667 4508 28 28 28 2.2442318354 2.3855720571 3.4521325967 101.6013746926 113.7665244381 164.4521325967 97.1129110217 108.9953803239 157.5478674033 Diastolic_2_Grp3 Mean BP_2_Grp3 103.1071428571 140.9166666667 0.6157957937 103 101 3.2584850572 10.6177248677 -1.2696402397 1.3066808164 140.8333333333 133.6666666667 6.9143049664 47.8076131687 0.1829290545 -0.0682271006 -0.3180400626 10 31 98 123 108 154 2887 3945.6666666667 28 28 1.263508587 2.6810875437 104.3706514441 143.5977542104 101.8436342701 138.2355791229 Variable Ht_Grp_1 Ht_Grp_2 Ht_Grp_3 Wt_Grp_1 Wt_Grp_2 Coefficient of Variation 5.2 4.9 6.8 10.3 11.1 Wt_Grp_3 12.5 Age_Grp_1 4.9 Age_Grp_2 4.9 Age_Grp_3 6.9 Group_1 Surv 109.4 Group_2 Surv 107.5 Group_3 Surv 117.6 Systolic BP_1_Grp1 8.1 Diastolic_1_Grp_1 Mean BP_1_Grp_1 Systolic BP_2_Grp1 Diastolic_2_Grp_1 Mean BP_2_Grp_1 Systolic BP_1_Grp2 Diastolic_1_Grp2 Mean BP_1_Grp2 Systolic BP_2_Grp2 Diastolic_2_Grp2 Mean BP_2_Grp2 Systolic BP_1_Grp3 Diastolic_1_Grp3 Mean BP_1_Grp3 Systolic BP_2_Grp3 Diastolic_2_Grp3 Mean BP_2_Grp3 6.1 5.8 6.9 3.3 3.4 7.8 6.8 4.8 7.1 3.6 3.4 8 5.8 5.5 5.5 3.2 4.9 Weight GroupFrequency 3 Cumulative % 141-150 1 3.45% 151-160 5 20.69% 161-170 4 34.48% 171-180 2 41.38% 181-190 0 41.38% 191-200 7 65.52% 201-210 5 82.76% 211-220 5 100.00% Histogram 8 7 6 5 4 Frequency 3 2 1 0 Weight Classes Histogram 120.00% 100.00% 80.00% 60.00% 40.00% 20.00% 0.00% Weight Classes Frequency Cumulative % Participant Diastolic_1_Grp_1 Diseased? Diastolic_2_Grp_1 1 92 0 99 2 109 1 103 3 108 1 99 4 101 1 100 5 90 0 108 6 92 0 104 7 101 1 105 8 93 0 106 9 95 0 105 10 106 1 100 11 101 1 98 12 99 0 102 13 104 1 107 14 105 1 106 15 99 0 101 16 94 0 108 17 105 1 102 18 99 0 104 19 108 1 99 20 110 1 101 21 101 1 99 22 100 0 108 23 110 1 99 13 0 Diseased at Start Diseased at Start Diseased at Start 1 1 Diseased at Start 1 1 Diseased at Start Diseased at Start 1 Diseased at Start Diseased at Start 1 1 Diseased at Start 1 Diseased at Start Diseased at Start Diseased at Start 1 Diseased at Start 9 t-Test: Paired Two Sample for Means Diastolic_1_Grp2 Diastolic_2_Grp2 Mean 101.148148148 103.0740740741 Variance 47.5925925926 14.1481481481 Observations 27 27 Pearson Correlation 0.0781174947 Hypothesized Mean Difference 0 df 26 t Stat -1.3176011151 P(T<=t) two-tail t Critical two-tail 0.1991303141 2.0555294185 Point Wt_Grp_3 8 220 17 216 15 213 27 213 4 211 2 209 10 205 13 205 29 202 3 201 11 200 7 196 14 196 25 195 26 195 19 193 5 191 12 174 21 172 24 165 22 163 9 162 23 161 18 159 1 157 6 156 28 156 16 152 20 150 Rank 1 2 3 3 5 6 7 7 9 10 11 12 12 14 14 16 17 18 19 20 21 22 23 24 25 26 26 28 29 Percent 100.00% 96.40% 89.20% 89.20% 85.70% 82.10% 75.00% 75.00% 71.40% 67.80% 64.20% 57.10% 57.10% 50.00% 50.00% 46.40% 42.80% 39.20% 35.70% 32.10% 28.50% 25.00% 21.40% 17.80% 14.20% 7.10% 7.10% 3.50% 0.00% Ht_Grp_1 Ht_Grp_2 Ht_Grp_3 Wt_Grp_1 Wt_Grp_2 Wt_Grp_3 Age_Grp_1 Age_Grp_2 Age_Grp_3 Group_1 Surv 73 66 59 174 188 157 69 55 45 0 68 66 58 186 157 209 67 57 50 0 65 72 69 154 191 201 62 60 49 0 65 64 66 202 179 211 65 57 45 1 70 64 63 218 175 191 62 59 41 0 65 70 67 185 156 156 65 57 46 1 74 66 64 187 214 196 61 55 47 0 71 66 72 187 166 220 69 60 44 1 73 68 67 184 177 162 67 52 44 1 71 63 61 187 180 205 66 54 49 1 64 62 65 172 155 200 67 57 42 0 70 70 59 193 214 174 68 51 42 1 66 71 60 180 180 205 61 58 44 1 74 66 60 217 187 196 61 57 49 0 72 62 72 215 202 213 70 59 41 0 73 62 60 172 154 152 61 54 48 0 72 63 69 157 170 216 69 58 41 1 74 64 62 168 195 159 68 55 42 1 72 69 68 192 177 193 70 57 46 1 65 62 72 155 215 150 63 60 41 0 65 64 64 184 217 172 65 59 41 1 67 68 62 164 211 163 67 56 43 0 73 66 62 161 165 161 70 57 50 0 70 69 155 165 52 41 1 70 66 188 195 59 45 0 68 69 203 195 51 46 1 72 68 173 213 60 43 0 59 156 48 0 61 202 45 1 Group_2 Surv Group_3 Surv Systolic BP_1_Grp1 Diastolic_1_Grp_1 Mean BP_1_Grp_1 Systolic BP_2_Grp1 1 1 152 92 0 0 179 109 0 0 173 108 0 1 147 101 0 1 158 90 0 0 166 92 1 1 143 101 1 0 142 93 1 1 141 95 1 1 149 106 1 1 173 101 1 0 169 99 1 0 162 104 0 1 168 105 0 1 178 99 0 0 140 94 0 1 152 105 0 1 146 99 0 0 155 108 1 0 159 110 1 0 143 101 0 165 100 0 172 110 0 1 0 0 0 1 112.0 132.3 129.7 116.3 112.7 116.7 115.0 109.3 110.3 120.3 125.0 122.3 123.3 126.0 125.3 109.3 120.7 114.7 123.7 126.3 115.0 121.7 130.7 156 145 184 161 165 160 174 154 169 178 158 170 166 158 162 146 181 177 151 158 156 153 147 Diastolic_2_Grp_1 Mean BP_2_Grp_1 Systolic BP_1_Grp2 Diastolic_1_Grp2 Mean BP_1_Grp2 Systolic BP_2_Grp2 99 103 99 100 108 104 105 106 105 100 98 102 107 106 101 108 102 104 99 101 99 108 99 118.0 117.0 127.3 120.3 127.0 122.7 128.0 122.0 126.3 126.0 118.0 124.7 126.7 123.3 121.3 120.7 128.3 128.3 116.3 120.0 118.0 123.0 115.0 137 90 125 106 136 109 134 108 151 95 131 94 132 102 125 94 143 106 152 93 158 92 157 103 139 99 132 106 126 109 149 110 126 97 134 105 138 105 135 110 125 105 131 92 156 91 143 110 150 99 154 107 130 94 105.7 112.3 118.0 116.7 113.7 106.3 112.0 104.3 118.3 112.7 114.0 121.0 112.3 114.7 114.7 123.0 106.7 114.7 116.0 118.3 111.7 105.0 112.7 121.0 116.0 122.7 106.0 161 151 169 154 179 184 168 170 172 169 159 181 174 170 179 164 156 172 147 181 152 153 146 181 169 184 154 166.6296296296 Diastolic_2_Grp2 Mean BP_2_Grp2 Systolic BP_1_Grp3 Diastolic_1_Grp3 Mean BP_1_Grp3 Systolic BP_2_Grp3 107 108 100 99 100 103 106 108 107 99 100 98 101 100 107 108 106 98 104 107 108 106 98 101 103 98 103 125.0 122.3 123.0 117.3 126.3 130.0 126.7 128.7 128.7 122.3 119.7 125.7 125.3 123.3 131.0 126.7 122.7 122.7 118.3 131.7 122.7 121.7 114.0 127.7 125.0 126.7 120.0 118 94 129 91 142 107 140 91 131 104 122 100 134 93 137 97 138 99 130 100 150 101 149 104 121 90 131 109 145 104 121 104 129 103 148 105 150 101 136 100 147 97 133 90 141 109 115 90 150 95 149 103 136 102 120 99 130 99 102.0 103.7 118.7 107.3 113.0 107.3 106.7 110.3 112.0 110.0 117.3 119.0 100.3 116.3 117.7 109.7 111.7 119.3 117.3 112.0 113.7 104.3 119.7 98.3 113.3 118.3 113.3 106.0 109.3 167 160 154 149 146 178 149 161 168 153 170 154 159 164 158 169 174 168 163 162 149 172 153 159 172 171 150 156 150 Diastolic_2_Grp3 Mean BP_2_Grp3 101 107 103 106 103 106 103 98 101 101 99 100 105 102 99 108 98 108 107 98 107 103 106 105 107 101 101 104 101 123.0 142.3 137.0 134.7 131.7 154.0 133.7 140.0 145.7 135.7 146.3 136.0 141.0 143.3 138.3 148.7 148.7 148.0 144.3 140.7 135.0 149.0 137.3 141.0 150.3 147.7 133.7 138.7 133.7 Wt_Grp_3 Systolic BP_1_Grp3 157 118 209 129 201 142 211 140 191 131 156 122 196 134 220 137 162 138 205 130 200 150 174 149 205 121 196 131 213 145 152 121 216 129 159 148 193 150 150 136 172 147 163 133 161 141 165 115 195 150 195 149 213 136 156 120 202 130 220 Diastolic_2_Grp_1 Diastolic_2_Grp2 Diastolic_2_Grp3 Diastolic_1_Grp2 Diastolic_2_Grp2 99 107 101 90 107 103 108 107 106 108 99 100 103 109 100 100 99 106 108 99 108 100 103 95 100 104 103 106 94 103 105 106 103 102 106 106 108 98 94 108 105 107 101 106 107 100 99 101 93 99 98 100 99 92 100 102 98 100 103 98 107 101 105 99 101 106 100 102 106 100 101 107 99 109 107 108 108 108 110 108 102 106 98 97 106 104 98 108 105 98 99 104 107 105 104 101 107 98 110 107 99 108 107 105 108 108 106 103 92 106 99 98 106 91 98 101 105 110 101 103 107 99 103 98 101 107 98 103 101 94 103 104 101 Diastolic_1_Grp_1 Diastolic_2_Grp_1 17 + 92 0 99 0 2 + 109 1 103 Diseased at Start -9 - 108 1 99 Diseased at Start -9 - 101 1 100 Diseased at Start 5 + 90 0 108 1 9 + 92 0 104 1 4 + 101 1 105 Diseased at Start 14 + 93 0 106 1 1 + 95 0 105 1 6 + 106 1 100 Diseased at Start 8 + 101 1 98 Diseased at Start -5 - 99 0 102 1 2 + 104 1 107 Diseased at Start -6 - 105 1 106 Diseased at Start -2 - 99 0 101 1 -2 - 94 0 108 1 9 + 105 1 102 Diseased at Start -7 - 99 0 104 1 -1 - 108 1 99 Diseased at Start -3 - 110 1 101 Diseased at Start 3 + 101 1 99 Diseased at Start 14 + 100 0 108 1 7 + 110 1 99 Diseased at Start -9 - 4 + Disease=> 13 Disease=> 9 -9 - Disease Free=> 10 Disease Free=> 1 9 + Positive=> 16 Negative=> 11 SUMMARY OUTPUT Regression Statistics R Square 0.058312 Standard E 10.62585 Observatio 29 ANOVA df Regression Residual Total SS MS F Significance F 1 188.7748 188.7748 1.671924 0.206956 27 3048.536 112.9087 28 3237.31 Coefficients Standard Error t Stat P-value Lower 95%Upper 95% Lower 95.0% Intercept 114.2828 16.32854 6.99896 1.6E-007 80.77942 147.7862 80.77942 Wt_Grp_3 0.112806 0.087242 1.293029 0.206956 -0.066199 0.291811 -0.066199 Upper 95.0% 147.7862 0.291811 160 150 140 130 f(x) = 0.1128058985x + 114.2828213329 R?? = 0.0583122458 120 110 100 90 80 Systolic BP 70 60 50 40 30 20 10 0 140 150 160 170 180 Wt_Grp_3 190 200 210 220 230 ParticipantDiastolic_1_Grp2 Diastolic_2_Grp2 1 90 107 2 106 108 3 109 100 4 108 99 5 95 100 6 94 103 7 102 106 8 94 108 9 106 107 10 93 99 11 92 100 12 103 98 13 99 101 14 106 100 15 109 107 16 110 108 17 97 106 18 105 98 19 105 104 20 110 107 21 105 108 22 92 106 23 91 98 24 110 101 25 99 103 26 107 98 27 94 103 17 2 -9 -9 5 9 4 14 1 6 8 -5 2 -6 -2 -2 9 -7 -1 -3 3 14 7 -9 4 -9 9 Positive=> Negative=> + + + + + + + + + + + + + + + + 16 11 1.1 1 0.9 0.8 0.7 0.6 % Survived 0.5 0.4 0.3 0.2 0.1 0 0 1 2 3 5 6 9 10 11 12 13 Time (months) 14 17 17 18 19 21 23 24 24 24 Year of Death Year of Last Contact 1 2 3 4 6 9 10 11 12 13 14 17 17 18 19 21 23 24 24 24 Time 0 1 2 3 5 6 9 10 11 12 13 14 17 17 18 19 21 23 24 24 24 Event (1=death, 0=censored) 1 0 1 1 0 0 0 0 0 0 1 1 0 0 0 0 1 0 0 0 Number atNumber Risk of Deaths Number Dt Cesored 20 19 18 17 16 15 14 13 12 11 10 9 9 7 6 5 4 3 3 3 1 0 1 1 0 0 0 0 0 0 1 1 0 0 0 0 1 0 0 0 0 1 0 0 1 1 1 1 1 1 0 0 1 1 1 1 0 1 1 1 1 0.95 0.95 0.897222 0.844444 0.844444 0.844444 0.844444 0.844444 0.844444 0.844444 0.76 0.675556 0.675556 0.675556 0.675556 0.675556 0.506667 0.506667 0.506667 0.506667 t-Test: Two-Sample Assuming Equal Variances Mean Variance Observations Pooled Variance Hypothesized Mean Difference df t Stat P(T<=t) two-tail t Critical two-tail Wt_Grp_1 Wt_Grp_2 182.3478 183.1111 350.1462 414.8718 23 27 385.2059 0 48 -0.137057 0.891559 2.010635 HLTH 501 EXCEL EXERCISE MODULE/WEEK 6 Refer to the Incidence tab in the assignment spreadsheet: True/False. This sheet compares the same group of participants before/after diastolic blood pressure readings. ______1 pt How many total patients are in group 1?____ 1 pts How many of these patients had disease at the start of the study?___ 1 pts Based on Column C, what diastolic value appears to be the cutoff between diseased and diseasefree? ______1 pt True/False. Participant 9 had an initial diastolic of 95 and was considered disease free. At a later date, their diastolic rose to 105 and they became categorized as diseased. ______1 pt Was participant 1 found disease-free after the first and second diagnostic measurements? ____ 1 pts True/False. Participant 11 was diseased at the start, but then their second diastolic reading showed they are now diseased free; however, this reversal is not noted in the incidence tab. ____1pt True/False. The prevalence of diastolic hypertension is the percentage of participants who were diseased after diastolic 2 pressure was measured. ____1pt What is the prevalence of diastolic hypertension? . ____ % 1pt Provide three numbers. The number of subjects disease free at the beginning, how many of these ended up with the disease at the end, and the incidence of diastolic hypertension_____ 1 pts