Use the appropriate Excel template(s) from lab assignments, Excel feature(s), or Excel function(s) to answer the following questions. a. Suppose that resting heart rate in the population follows a normal distribution with a mean of 80 and a standard deviation of 5. What proportion of individuals in the population have a resting heart rate exceeding 85? 0.3672 O 0.1959 0.2356 O 0.2869 0.1587 b. Refer to the previous question. Suppose a random sample of 10 individuals from the population was obtained. What is the probability that at least two individuals in the sample have a resting heart rate exceeding 85? O 0.4331 O 0.5275 O 0.4742 O 0.4871 O 0.0251

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.5: Comparing Sets Of Data
Problem 13PPS
Question
None
Use the appropriate Excel template(s) from lab assignments, Excel feature(s), or Excel function(s) to answer the following questions.
a. Suppose that resting heart rate in the population follows a normal distribution with a mean of 80 and a standard deviation of 5. What proportion of individuals in the population have a resting heart rate exceeding 85?
0.3672
O 0.1959
0.2356
O 0.2869
0.1587
b. Refer to the previous question. Suppose a random sample of 10 individuals from the population was obtained. What is the probability that at least two individuals in the sample have a resting heart rate exceeding 85?
O 0.4331
O 0.5275
O 0.4742
O 0.4871
O 0.0251
Transcribed Image Text:Use the appropriate Excel template(s) from lab assignments, Excel feature(s), or Excel function(s) to answer the following questions. a. Suppose that resting heart rate in the population follows a normal distribution with a mean of 80 and a standard deviation of 5. What proportion of individuals in the population have a resting heart rate exceeding 85? 0.3672 O 0.1959 0.2356 O 0.2869 0.1587 b. Refer to the previous question. Suppose a random sample of 10 individuals from the population was obtained. What is the probability that at least two individuals in the sample have a resting heart rate exceeding 85? O 0.4331 O 0.5275 O 0.4742 O 0.4871 O 0.0251
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL