Excel Exercise Module/Week 8

Refer to the Survival Graph and Survival Analysis tabs in the Excel Assigment spresdsheet. Move your mouse over the blue diamonds to read their exact values.

What percent of participants are assumed alive after 5 months? ____2 pt

How many patients started the study at time zero? _____2 pt

What does it mean when a patient is censored? ______2 pt

True/False. There is a blue diamond at t = 2 to denote that contact was lost with a participant. _____2 pt

Why is there no time 4 on the Survival Graph? __ __2 pt

True/False. The relatively long period between 5 months and 13 months where the survival rate stayed level was really a result of six patients being censored. ______2 pt

How many patients actually died during the 24 months of the study? _____ 2 pt

How many patients stayed in contact with researchers and were alive until month 24? ______2 pt

How many patients' were lost to contact? ______2 pts

What is the worst case survival rate after 24 months, assuming all the patients censored ended up dying? What is the best case survival rate after 24 months? ______ 2 pt

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.62962962963 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 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.90176239476 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.38465887958 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.09175991045 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.78260869565 56.51851851852 44.75 3.91990076817 4.38894629544 0.674072402426 0.534748044541 0.581061335086 180 195 67 57 44.5 188 156 67 57 41 20.3684018733 23.2241208307 3.232737676548 2.778632347181 3.074687578227 414.871794872 539.35978836 10.45059288538 7.720797720798 9.453703703704 -1.0428313054 -1.5846031099 -1.32880036829 -0.50662986615 -1.22547062579 0.23038302277 -0.1522567307 -0.3165556133 -0.63126439246 0.294851830973 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.397940594745 1.09919033703 1.192239365616 191.168582458 194.219659555 67.1805492904 57.61770885555 45.94223936562 175.053639765 176.208911873 64.38466810091 55.41932818149 43.55776063438 2.79588118949 2.198380674059 2.384478731233 Group_1 Surv Group_2 Surv Group_3 Surv Systolic BP_1_Grp1 0.46428571428572 0.47619047619048 0.42857142857143 157.913043478261 0.09597925890832 0.11167656571008 0.0952380952381 0 0 0 0 0 0 0.50787450018337 0.51176631571916 0.50395263067897 0.25793650793651 0.26190476190476 0.25396825396825 -2.1352899408284 -2.2105263157895 -2.0596153846154 2.66132678393734 158 152 12.7632748842431 162.901185770752 -1.37014984848595 0.15146079768782 0.10284299167562 0.30527899743053 0.12218525120233 1 1 1 39 0 0 0 140 1 1 1 179 13 10 12 3632 28 21 28 23 0.19693317012081 0.23295323332067 0.19541242790197 5.51925391658137 0.66121888440652 0.70914370951115 0.6239838564734 163.432297394842 0.26735254416491 0.24323724286981 0.23315900066946 152.39378956168 Diastolic_1_Grp_1 Mean BP_1_Grp_1 Systolic BP_2_Grp1 100.95652173913 119.942028985507 162.130434782609 1.28456673748068 101 101 6.16056565340884 37.9525691699607 -1.02309106596434 1.45003932433668 120.666666666667 115 6.95414430169692 48.3601229688237 -1.06828076809546 2.33913631220152 160 158 11.2181036633815 125.845849802374 -0.701004488784259 -0.17887526329263 0.044968371803472 0.387180302409616 20 23 39 90 109.333333333333 145 110 132.333333333333 184 2322 2758.66666666667 3729 23 23 23 2.66402834846957 3.00719748824 4.85107177760245 103.6205500876 122.949226473747 166.981506560211 98.2924933906609 116.934831497267 157.279363005006 Diastolic_2_Grp_1 Mean BP_2_Grp_1 Systolic BP_1_Grp2 102.739130434783 122.536231884058 138.851851851852 0.703512899961655 102 99 3.37392934269325 11.3833992094865 -1.37132651289683 0.881353993495731 122.666666666667 118 4.22682526520438 17.86605182257 -1.26073434635065 2.09374574283104 136 125 10.8794220141432 118.361823361824 -1.14914474845487 0.246800809230583 -0.146813287726727 0.429537412996996 10 13.3333333333333 33 98 115 125 108 128.333333333333 158 2363 2818.33333333333 3749 23 23 27 1.45899644940796 1.82781630194966 4.3037559692079 104.198126884191 124.364048186008 143.15560782106 101.280133985375 120.708415582108 134.548095882644 Diastolic_1_Grp2 Mean BP_1_Grp2 Systolic BP_2_Grp2 101.148148148148 113.716049382716 166.62962962963 1.32766283918037 103 106 6.89873847834464 47.5925925925929 -1.54429340082014 1.04120606397058 114 114.666666666667 5.41026541183759 29.2709718265262 -0.687875084310737 2.28531054710697 169 169 11.8748219359869 141.011396011396 -1.187750661036 -0.23152800000062 -0.164006757788115 -0.19088674745546 20 18.6666666666667 38 90 104.333333333333 146 110 123 184 2731 3070.33333333333 4499 27 27 27 2.72905002375884 2.14022969519202 4.69752305994258 103.877198171907 115.856279077908 171.327152689572 98.4190981243892 111.575819687524 161.932106569687 Diastolic_2_Grp2 Mean BP_2_Grp2 Systolic BP_1_Grp3 103.074074074074 124.259259259259 135.428571428571 0.723882232803412 103 107 3.76140241773573 14.1481481481482 -1.65559821445515 0.810725298191454 125 126.666666666667 4.21265222234708 17.7464387464458 0.106462276549884 2.06022329620707 136 150 10.9016769740514 118.846560846561 -1.05493920474114 0.003312789114382 -0.373695571140696 -0.23199296966129 10 17.6666666666667 35 98 114 115 108 131.666666666667 150 2783 3355 3792 27 27 28 1.4879612250429 1.66646970073906 4.22722898148622 104.562035299117 125.925728959998 139.655800410058 101.586112849031 122.59278955852 131.201342447085 Diastolic_1_Grp3 Mean BP_1_Grp3 Systolic BP_2_Grp3 99.3571428571429 111.380952380952 161 1.0937705834366 100 104 5.78768991026254 33.4973544973548 -0.905978945050798 1.1626555240658 112 107.333333333333 6.15219475422718 37.8495002939405 -0.732864811347927 1.68246480815731 160.5 149 8.9027669440045 79.2592592592593 -1.08567541135605 -0.246943259641646 -0.436152735856202 0.066813370659067 19 21.3333333333333 32 90 98.3333333333333 146 109 119.666666666667 178 2782 3118.66666666667 4508 28 28 28 2.24423183540954 2.38557205709901 3.45213259672723 101.601374692552 113.766524438051 164.452132596727 97.1129110217333 108.995380323853 157.547867403273 Diastolic_2_Grp3 Mean BP_2_Grp3 103.107142857143 140.916666666667 0.615795793718675 103 101 3.25848505715849 10.6177248677252 -1.2696402396557 1.30668081642998 140.833333333333 133.666666666667 6.91430496642511 47.807613168731 0.182929054527672 -0.068227100618399 -0.318040062582706 10 31 98 123 108 154 2887 3945.66666666667 28 28 1.26350858699506 2.68108754373084 104.370651444138 143.597754210397 101.843634270148 138.235579122936 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 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 Diastolic_2_Grp3 Mean BP_2_Grp3 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 120. 7 100. 6 80.0 Frequency 5 4 60.0 3 40.0 2 20.0 1 0 0.00 1 5 -1 41 0 1 6 -1 51 0 1 7 -1 61 0 1 71 18 0 1 9 -1 81 0 1 0 -2 91 Weight Classes 0 2 01 21 0 2 2 -2 11 0 Histogram 9 -1 81 120.00% 100.00% 80.00% 60.00% 40.00% 20.00% 0.00% 0 1 0 -2 91 eight Classes 0 2 01 21 0 2 2 -2 11 0 Frequency Cumulative % 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 % Survived 0.6 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 a 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