Excel Assignment Spreadsheet(3)

Excel Assignment Spreadsheet(3) - Anova Single Factor...

Info icon This preview shows pages 1–13. Sign up to view the full content.

View Full Document Right Arrow Icon
Anova: Single Factor SUMMARY Groups Count Sum Average Variance Diastolic_2_Grp_1 23 2363 102.7391 11.3834 Diastolic_2_Grp2 27 2783 103.0741 14.14815 Diastolic_2_Grp3 29 2988 103.0345 10.39163 ANOVA Source of Variation SS df MS F P-value F crit Between Groups 1.633924 2 0.816962 0.068286 0.934051 3.116982 Within Groups 909.2522 76 11.96384 Total 910.8861 78
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Wt_Grp_3 olic BP_1_Grp3 Wt_Grp_3 1 Systolic B 0.241479 1
Image of page 2
Ht_Grp_1 Ht_Grp_2 Ht_Grp_3 Wt_Grp_1 Mean 69.652173913 66.444444444 64.714285714 182.347826087 Standard Error 0.7507800835 0.6255102381 0.8275308189 3.9017623948 Median 71 66 64.5 184 Mode 65 66 69 187 Standard Deviation 3.6006147916 3.250246539 4.3788814981 18.7121950893 Sample Variance 12.964426877 10.564102564 19.174603175 350.146245059 Kurtosis -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 Sum 1602 1794 1812 4194 Count 23 27 28 23 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
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Wt_Grp_2 Wt_Grp_3 Age_Grp_1 Age_Grp_2 Age_Grp_3 183.111111111 185.214285714 65.7826086957 56.5185185185 44.75 3.9199007682 4.3889462954 0.6740724024 0.5347480445 0.5810613351 180 194 67 57 44.5 188 156 67 57 41 20.3684018733 23.2241208307 3.2327376765 2.7786323472 3.0746875782 414.871794872 539.35978836 10.4505928854 7.7207977208 9.4537037037 -1.0428313054 -1.5846031099 -1.3288003683 -0.5066298662 -1.2254706258 0.2303830228 -0.1522567307 -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 28 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
Image of page 4
Group_1 Surv Group_2 Surv Group_3 Surv Systolic BP_1_Grp1 0.4642857143 0.4761904762 0.4285714286 157.9130434783 0.0959792589 0.1116765657 0.0952380952 2.6613267839 0 0 0 158 0 0 0 152 0.5078745002 0.5117663157 0.5039526307 12.7632748842 0.2579365079 0.2619047619 0.253968254 162.9011857708 -2.1352899408 -2.2105263158 -2.0596153846 -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
Image of page 5

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Diastolic_1_Grp_1 Mean BP_1_Grp_1 Systolic BP_2_Grp1 100.9565217391 119.9420289855 162.1304347826 1.2845667375 1.4500393243 2.3391363122 101 120.6666666667 160 101 115 158 6.1605656534 6.9541443017 11.2181036634 37.95256917 48.3601229688 125.8458498024 -1.023091066 -1.0682807681 -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
Image of page 6
Diastolic_2_Grp_1 Mean BP_2_Grp_1 Systolic BP_1_Grp2 102.7391304348 122.5362318841 138.8518518519 0.7035129 0.8813539935 2.0937457428 102 122.6666666667 136 99 118 125 3.3739293427 4.2268252652 10.8794220141 11.3833992095 17.8660518226 118.3618233618 -1.3713265129 -1.2607343464 -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
Image of page 7

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Diastolic_1_Grp2 Mean BP_1_Grp2 Systolic BP_2_Grp2 101.1481481481 113.7160493827 166.6296296296 1.3276628392 1.041206064 2.2853105471 103 114 169 106 114.6666666667 169 6.8987384783 5.4102654118 11.874821936 47.5925925926 29.2709718265 141.0113960114 -1.5442934008 -0.6878750843 -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
Image of page 8
Diastolic_2_Grp2 Mean BP_2_Grp2 Systolic BP_1_Grp3 103.0740740741 124.2592592593 135.4285714286 0.7238822328 0.8107252982 2.0602232962 103 125 136 107 126.6666666667 150 3.7614024177 4.2126522223 10.9016769741 14.1481481481 17.7464387464 118.8465608466 -1.6555982145 0.1064622765 -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
Image of page 9

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Diastolic_1_Grp3 Mean BP_1_Grp3 Systolic BP_2_Grp3 99.3571428571 111.380952381 161 1.0937705834 1.1626555241 1.6824648082 100 112 160.5 104 107.3333333333 149 5.7876899103 6.1521947542 8.902766944 33.4973544974 37.8495002939 79.2592592593 -0.9059789451 -0.7328648113 -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
Image of page 10
Diastolic_2_Grp3 Mean BP_2_Grp3 103.1071428571 140.9166666667 0.6157957937 1.3066808164 103 140.8333333333 101 133.6666666667 3.2584850572 6.9143049664 10.6177248677 47.8076131687 -1.2696402397 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
Image of page 11

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Variable Coefficient of Variation Ht_Grp_1 5.2 Ht_Grp_2 4.9 Ht_Grp_3 6.8 Wt_Grp_1 10.3 Wt_Grp_2 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
Image of page 12
Image of page 13
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern