Fifteen adult males between the ages of 35 and 50 participated in a study to evaluate the effect of diet and exercise on blood cholesterol levels. The total cholesterol was measured in each subject initially and then three months after participating in an aerobic exercise program and switching to a low-fat diet. The data are shown in the following table: Blood Cholesterol Level Subject Before After 1 265 229 2 240 231 3 258 227 4 295 240 5 251 238 6 245 241 7 287 234 8 314 256 9 260 247 10 279 239 11 283 246 12 240 218 13 238 219 14 225 226 15 247 233 Do the data support the claim that low-fat diet and aerobic exercise are of value in producing a mean reduction in blood cholesterol levels? Use a = 0.05

Linear Algebra: A Modern Introduction
4th Edition
ISBN:9781285463247
Author:David Poole
Publisher:David Poole
Chapter7: Distance And Approximation
Section7.3: Least Squares Approximation
Problem 31EQ
icon
Related questions
Question

Please solve using EXCEL (PLEASE ATTACH THE SCREENSHOT OF THE EXCEL SHEET)

 

Fifteen adult males between the ages of 35 and 50 participated in a study to evaluate the effect of
diet and exercise on blood cholesterol levels. The total cholesterol was measured in each subject
initially and then three months after participating in an aerobic exercise program and switching to
a low-fat diet. The data are shown in the following table:
Blood Cholesterol Level
Subject
Before
After
1
265
229
2
240
231
258
227
295
240
251
238
245
241
287
234
314
256
260
247
279
239
11
283
246
12
240
218
13
238
219
14
225
226
15
247
233
Do the data support the claim that low-fat diet and aerobic exercise are of value in producing a
mean reduction in blood cholesterol levels? Use a = 0.05
a.
None among the choices
b. Reject the Null Hypothesis. 5.465 > 1.761
O c. Reject the Null Hypothesis. 5.465 > 1.753
d. Fail to reject the Null Hypothesis. 5.465 > 1.753
WN
3
4
5
6
7
8
9
10
Transcribed Image Text:Fifteen adult males between the ages of 35 and 50 participated in a study to evaluate the effect of diet and exercise on blood cholesterol levels. The total cholesterol was measured in each subject initially and then three months after participating in an aerobic exercise program and switching to a low-fat diet. The data are shown in the following table: Blood Cholesterol Level Subject Before After 1 265 229 2 240 231 258 227 295 240 251 238 245 241 287 234 314 256 260 247 279 239 11 283 246 12 240 218 13 238 219 14 225 226 15 247 233 Do the data support the claim that low-fat diet and aerobic exercise are of value in producing a mean reduction in blood cholesterol levels? Use a = 0.05 a. None among the choices b. Reject the Null Hypothesis. 5.465 > 1.761 O c. Reject the Null Hypothesis. 5.465 > 1.753 d. Fail to reject the Null Hypothesis. 5.465 > 1.753 WN 3 4 5 6 7 8 9 10
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Recommended textbooks for you
Linear Algebra: A Modern Introduction
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning
Functions and Change: A Modeling Approach to Coll…
Functions and Change: A Modeling Approach to Coll…
Algebra
ISBN:
9781337111348
Author:
Bruce Crauder, Benny Evans, Alan Noell
Publisher:
Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill