(solution) I have some doubt with this assignment and I have attached the

I have some doubt with this assignment and I have attached the excel spreadsheet with this paper, Thanks.

The standard deviation is a measure of how much variation is present in a sample or population. Refer to the Descriptives table in the spreadsheet and identify the standard deviation for the weights of the three groups. Enter the standard deviation next to the variable names below.

A. Wt_Grp_1 = _____

B. Wt_Grp_2 = _____

C. Wt_Grp_3 = _____

For the three histograms below enter the letter corresponding to the Wt_Grp with a standard deviation most consistent with the shape of the histogram.

Letter ______ (1 pt)

Letter: ______ (1 pt)

Letter ______ (1 pt)

Refer to the TwoSampleTTest tab in the assignment spreadsheet.

Answer the following questions:

Which group of subjects is least alike with regard to weight? ____ (1 pt)

Do the two groups have significantly different mean weights? (Yes/No)_____ (1 pt)

Refer to the PairedTTest tab in the assignment spreadsheet.

Answer the following questions:

Which group of subjects are least alike with regard to blood pressure? ____ (1 pt)

Do the two groups have significantly different mean blood pressures? (Yes/No)______ (1 pt)

To answer the question: Is the 2nd diastolic blood pressure significantly different between Groups

1, 2, and 3?refer to the ANOVA tab in the assignment spreadsheet.

Which group is most alike with respect to blood pressure? ____ (1 pt)

Is there a significant difference in mean blood pressure between the groups? ______ (1 pt)

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

P-value

F crit

2 0.816962 0.068286 0.934051 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

194

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 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 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 Lower Limit of WtFrequency

Class Cumulative %

150

1

3.45%

160

5 20.69%

170

4 34.48%

180

2 41.38%

190

0 41.38%

200

7 65.52%

210

5 82.76%

220

5 100.00% Histogram

8

6

4

Frequency

2

0 150.00%

100.00%

50.00%

150160170180190200210220 Frequen

Cumulati 0.00% Lower Limit of Wt Class **The limit points are not included in the cumulative %. E.g. 82.76% of the participants were strictly less gram 210220 150.00%

100.00%

50.00% Frequency

Cumulative % 0.00% Wt Class articipants were strictly less than 210 lbs. Diastolic_1_Grp_1

92

109

108

101

90

92

101

93

95

106

101

99

104

105

99

94

105

99

108

110

101

100

110

Disease=&gt;

Disease Free=&gt; Diastolic_2_Grp_1

0

99

1

103

1

99

1

100

0

108

0

104

1

105

0

106

0

105

1

100

1

98

0

102

1

107

1

106

0

101

0

108

1

102

0

104

1

99

1

101

1

99

0

108

1

99

13 Disease=&gt;

10 Disease Free=&gt; 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 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&lt;=t) one-tail

0.0995651571

t Critical one-tail

1.7056179005

P(T&lt;=t) two-tail

0.1991303141

t Critical two-tail

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 Lower Limit of Wt Class

150

160

170

180

190

200

210

220 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=&gt; 13 Disease=&gt; 9 -9 - Disease Free=&gt; 10 Disease Free=&gt; 1 9 + Positive=&gt; 16 Negative=&gt; 11 SUMMARY OUTPUT

Regression Statistics

Multiple R 0.241479

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 Diastolic_ Diastolic_2_Grp2

90

107

106

108

109

100

108

99

95

100

94

103

102

106

94

108

106

107

93

99

92

100

103

98

99

101

106

100

109

107

110

108

97

106

105

98

105

104

110

107

105

108

92

106

91

98

110

101

99

103

107

98

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=&gt;

Negative=&gt; 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&lt;=t) one-tail

t Critical one-tail

P(T&lt;=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.44578

1.677224

0.891559

2.010635

Solution details:

STATUS

QUALITY

Approved

Sep 13, 2020

EXPERT

Tutor