please compete excel assignment below/ use the attached excel spreadsheet, super quick and easy assignment

User Generated

Zvenpyr99

Health Medical

Liberty University

Description

Excel Exercise Module/Week 5

Refer to the Scatterplot and Regressions tabs to answer the following questions.

Looking at the scatterplot what is the maximum value for systolic blood pressure?_____1 pt.

Looking at the scatterplot what is the range of weights for Wt_Grp_3?_______1 pt.

True/False. The slope of the regression line is 114.283 and the y-intercept is 0.1128 ______1 pt

If you plugged the value x = 300 into the regression equation shown on the scatterplot, what would be the numeric result?______2 pt.

True/False. According to the trend line where x represents weight and y represents diastolic pressure, a 300lb participant would have diastolic pressure of less than 150. ______1pt.

Based on the appearance of the scatterplot would you say weight is a good predictor of blood pressure for this sample? _____ 2 pts.

Looking at the Regression Tab, what cell (E.g. E12) in this sheet tells you that weight group 3 does not have a linear relation in terms of weight vs diastolic pressure? _____2 pts

Unformatted Attachment Preview

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 BP_1_Grp3 0.241479 1 Mean Ht_Grp_1 69.65217391 Ht_Grp_2 66.44444444 Ht_Grp_3 64.71428571 Standard Error Median Mode Standard Deviation Sample Variance Kurtosis 0.750780084 0.625510238 0.827530819 71 66 64.5 65 66 69 3.600614792 3.250246539 4.378881498 12.96442688 10.56410256 19.17460317 -1.584074669 -1.199804176 -1.203816837 Skewness -0.336385159 0.185587117 0.13320545 Range 10 10 14 Minimum 64 62 58 Maximum 74 72 72 1602 1794 1812 23 27 28 1.557022588 1.285754696 1.697952968 Upper Limt CI 71.2091965 67.73019914 66.41223868 Lower Limit CI 68.09515133 65.15868975 63.01633275 Sum Count Confidence Level(95.0%) Wt_Grp_1 182.3478261 Wt_Grp_2 183.1111111 Wt_Grp_3 185.2142857 Age_Grp_1 65.7826087 Age_Grp_2 56.51851852 3.901762395 184 187 18.71219509 350.1462451 -0.350453055 3.919900768 180 188 20.36840187 414.8717949 -1.042831305 4.388946295 195 156 23.22412083 539.3597884 -1.58460311 0.674072402 67 67 3.232737677 10.45059289 -1.328800368 0.534748045 57 57 2.778632347 7.720797721 -0.506629866 0.38465888 0.230383023 -0.152256731 -0.316555613 -0.631264392 64 63 70 9 9 154 154 150 61 51 218 217 220 70 60 4194 4944 5186 1513 1526 23 27 29 23 27 8.09175991 8.057471346 9.005373841 1.397940595 1.099190337 190.439586 191.1685825 194.2196596 67.18054929 57.61770886 174.2560662 175.0536398 176.2089119 64.3846681 55.41932818 2.795881189 2.198380674 Age_Grp_3 44.75 Group_1 Surv 0.464285714 Group_2 Surv 0.476190476 Group_3 Surv 0.428571429 0.581061335 44.5 41 3.074687578 9.453703704 -1.225470626 0.095979259 0 0 0.5078745 0.257936508 -2.135289941 0.111676566 0 0 0.511766316 0.261904762 -2.210526316 0.095238095 0 0 0.503952631 0.253968254 -2.059615385 0.294851831 0.151460798 0.102842992 0.305278997 9 1 1 1 41 0 0 0 50 1 1 1 1253 13 10 12 28 28 21 28 1.192239366 0.19693317 0.232953233 0.195412428 45.94223937 0.661218884 0.70914371 0.623983856 43.55776063 0.267352544 0.243237243 0.233159001 2.384478731 Systolic BP_1_Grp1 157.9130435 Diastolic_1_Grp_1 100.9565217 Mean BP_1_Grp_1 119.942029 2.661326784 158 152 12.76327488 162.9011858 -1.370149848 1.284566737 101 101 6.160565653 37.95256917 -1.023091066 1.450039324 120.6666667 115 6.954144302 48.36012297 -1.068280768 0.122185251 -0.178875263 0.044968372 39 20 23 140 90 109.3333333 179 110 132.3333333 3632 2322 2758.666667 23 23 23 5.519253917 2.664028348 3.007197488 163.4322974 103.6205501 122.9492265 152.3937896 98.29249339 116.9348315 Systolic BP_2_Grp1 162.1304348 Diastolic_2_Grp_1 102.7391304 Mean BP_2_Grp_1 122.5362319 2.339136312 160 158 11.21810366 125.8458498 -0.701004489 0.7035129 102 99 3.373929343 11.38339921 -1.371326513 0.881353993 122.6666667 118 4.226825265 17.86605182 -1.260734346 0.387180302 0.246800809 -0.146813288 39 10 13.33333333 145 98 115 184 108 128.3333333 3729 2363 2818.333333 23 23 23 4.851071778 1.458996449 1.827816302 166.9815066 104.1981269 124.3640482 157.279363 101.280134 120.7084156 Systolic BP_1_Grp2 138.8518519 Diastolic_1_Grp2 101.1481481 Mean BP_1_Grp2 113.7160494 2.093745743 136 125 10.87942201 118.3618234 -1.149144748 1.327662839 103 106 6.898738478 47.59259259 -1.544293401 1.041206064 114 114.6666667 5.410265412 29.27097183 -0.687875084 0.429537413 -0.231528 -0.164006758 33 20 18.66666667 125 90 104.3333333 158 110 123 3749 2731 3070.333333 27 27 27 4.303755969 2.729050024 2.140229695 143.1556078 103.8771982 115.8562791 134.5480959 98.41909812 111.5758197 Systolic BP_2_Grp2 166.6296296 Diastolic_2_Grp2 103.0740741 Mean BP_2_Grp2 124.2592593 2.285310547 169 169 11.87482194 141.011396 -1.187750661 0.723882233 103 107 3.761402418 14.14814815 -1.655598214 0.810725298 125 126.6666667 4.212652222 17.74643875 0.106462277 -0.190886747 0.003312789 -0.373695571 38 10 17.66666667 146 98 114 184 108 131.6666667 4499 2783 3355 27 27 27 4.69752306 1.487961225 1.666469701 171.3271527 104.5620353 125.925729 161.9321066 101.5861128 122.5927896 Systolic BP_1_Grp3 135.4285714 Diastolic_1_Grp3 99.35714286 Mean BP_1_Grp3 111.3809524 2.060223296 136 150 10.90167697 118.8465608 -1.054939205 1.093770583 100 104 5.78768991 33.4973545 -0.905978945 1.162655524 112 107.3333333 6.152194754 37.84950029 -0.732864811 -0.23199297 -0.24694326 -0.436152736 35 19 21.33333333 115 90 98.33333333 150 109 119.6666667 3792 2782 3118.666667 28 28 28 4.227228981 2.244231835 2.385572057 139.6558004 101.6013747 113.7665244 131.2013424 97.11291102 108.9953803 Systolic BP_2_Grp3 161 Diastolic_2_Grp3 103.1071429 Mean BP_2_Grp3 140.9166667 1.682464808 160.5 149 8.902766944 79.25925926 -1.085675411 0.615795794 103 101 3.258485057 10.61772487 -1.26964024 1.306680816 140.8333333 133.6666667 6.914304966 47.80761317 0.182929055 0.066813371 -0.068227101 -0.318040063 32 10 31 146 98 123 178 108 154 4508 2887 3945.666667 28 28 28 3.452132597 1.263508587 2.681087544 164.4521326 104.3706514 143.5977542 157.5478674 101.8436343 138.2355791 Mean B 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 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 Mean BP_2_Grp3 4.9 of Variation 8 7 6 Frequency 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% 5 4 3 2 1 0 141-150 151-160 161-170 171-180 181-190 Weight Classes Histogram 120.00% 100.00% 80.00% 60.00% Frequency 40.00% 20.00% 0.00% 171-180 181-190 191-200 201-210 211-220 Weight Classes Cumulative % Participant 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Diastolic_1_Grp_1 Diseased? Diastolic_2_Grp_1 92 0 99 109 1 103 108 1 99 101 1 100 90 0 108 92 0 104 101 1 105 93 0 106 95 0 105 106 1 100 101 1 98 99 0 102 104 1 107 105 1 106 99 0 101 94 0 108 105 1 102 99 0 104 108 1 99 110 1 101 101 1 99 100 0 108 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 Mean Variance Observations Pearson Correlation Hypothesized Mean Difference df t Stat P(T 13 Disease=> 98 -9 - Disease Free=> 10 Disease Free=> 103 9 + Positive=> 16 Negative=> 11 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 1 SUMMARY OUTPUT Regression Statistics R Square 0.058312 Standard Error 10.62585 Observations 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% Intercept 114.2828 16.32854 6.99896 1.6E-07 80.77942 147.7862 Wt_Grp_3 0.112806 0.087242 1.293029 0.206956 -0.0662 0.291811 Lower 95.0% Upper 95.0% 80.77942 147.7862 -0.0662 0.291811 160 150 140 130 120 110 y = 0.1128x + 114.28 R² = 0.0583 Systolic BP 100 90 80 70 60 50 40 30 20 10 0 0 10 20 30 40 50 60 70 80 90 100 110 120 130 Wt_Grp_3 140 150 160 170 180 190 200 210 220 230 240 Participant Diastolic_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 % Survived 0.7 0.6 0.5 0.4 0.3 0.2 0.1 0 0 1 2 3 5 6 9 10 11 12 13 14 Time (months) 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 at Number 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 Wt_Grp_1 Wt_Grp_2 Mean 182.3478 183.1111 Variance 350.1462 414.8718 Observations 23 27 Pooled Variance 385.2059 Hypothesized Mean Difference 0 df 48 t Stat -0.13706 P(T
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

Refer to the Scatterplot and Regressions tabs to answer the following questions.
Looking at the scatterplot what is the maximum value for systolic blood pressure?__150___1 pt.
Looking at the sc...


Anonymous
Nice! Really impressed with the quality.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags