Shana is a physiciantesting whether the average total blood sugarlevel of adults with severe diabetes is less than215mg

dL

. She randomly selects35

people in the region who willingly allowed their blood to be drawn for the survey. Based on several previous studies, she assumes that the population standard deviation for the total blood sugarlevel is50.31mg

dL

.

For this test:H0:=215

;Ha:<215

, which is a left-tailed test.

Patient cholesterolis given below.

Use Excel to test whether the average total cholesterol level of adults in the region is less than215mg

dL

, where=0.05

.Calculate the test statistic,z

,rounding to two decimal places, and the p-value, rounding to three decimal places.

Cholesterol (mg/dL)

170

255

154

210

196

205

216

224

214

249

201

181

182

297

110

124

158

236

220

144

254

168

224

219

161

139

136

167

156

181

261

212

182

208

175

Test Statistic= ? P-Value = ?