12:45E Excel Computing Normal & Binomia... •..ers as an excel file with properly labeled answers. At thef the chapter 5 workbook you will find Practice problemse answer in excel only under practice problems 5.4ions: 1, 2, 3, 4, 5. If help is needed, tutorials are found inForkbook with relevant problems.These pictures will give you an idea where it is in thebook. You are responsible to use the workbook.OBK_Excel2007.pdf (SECURED) - Adobe Acrobat Pro DCndow Help9781284108217_W. x76 / 231149%-VISTRIBUTIONExcel to compute the 90th and 95th percentiles of BMI formen and women. The results are shown in Figure 5-12. InExcel can also be used to compute percentiles for the standardnormal distribution and any normal distribution. The two rel-men, 90% of BMIS are below 36.7, and 95% of BMIS are below38.9. In women, 90% of BMIS are below 37.0, and 95% of BMISevant functions are NORMSINV and NORMINV, respectively.The inputs for the functions are shown below. Recall fromChapter 5 in the textbook that a percentile is a score that holdsa specified percentage or proportion of scores below it. For ex-ample, the 80th percentile is the score that holds 80% of theare below 39,5.5.4PRACTICE PROBLEMS1. Total cholesterol in children aged 10-15 years is as-sumed to follow a normal distribution with a meanscores below it.The function to compute percentiles for the standard nor-of 191 and a standard deviation of 22.4.a. What proportion of children 10–15 years of agehave total cholesterol between 180 and 190?mal distribution is used as follows:b. What proportion of children 10-15 years of agewould be classified as hyperlipidemic (Assumethat hyperlipidemia is defined as a total choles-terol level over 200)?c. What is the 90th percentile of cholesterol levels?2. Among coffee drinkers, men drink a mean of 3.2 cupsper day, with a standard deviation of 0.8 cups. Assume=NORMSINV(probability)The input for the function is the desired percentile, entered asa probability or proportion. For example, to compute the 80thor the 95th percentile, we specify 0.80 or 0.95, respectively.The function to compute percentiles for any normal dis-tribution is used as follows:Copyright © 2018 by Jones & Bartlett Learning, LLC, an Ascend Learning Company208 PMV- A 4 ENG9/27/2019DBK Excel2007.pdf (SECURED) - Adobe Acrobat Pro DCndow Help9781284108217 W. x77 / 231149%O Sh72Working with Probability Functionsc. If the top 5% of coffee drinkers are consideredheavy coffee drinkers, what is the minimum num-ber of cups per day consumed by a heavy coffeedrinker? Hint: Find the 95th percentile.3. A study is conducted to assess theconsumption, smoking, alcohol consumption, andphysical activity on cardiovascular disease. Supposethat 40% of participants consume caffeine andsmoke. If 8 participants are evaluated, what is theprobability that:a. Exactly half of them consume caffeine and smoke?b. At most 6 consume caffeine and smoke?4. A recent study of cardiovascular risk factors reportedthat 30% of adults met criteria for hypertension. If 15FIGURE 5-12 Percentiles of BMI for Men andWomenChapters.als (Coof caffeinePage IConnections1HomeInsertRevieK ClearReapolyAdvancedPropertiesGet External RefreshData3I SortColumnsAllConnectionsSort & FiterD9SNORMINV(C9,A9,89)MENPercentile0.90.95MeanStd DevBMI292936 6893093938.86912176WOMENMean28Percentile0.90.95Std DevBMI36 9708609639 51397539adults are assessed, what is the probability that:28a. Exactly 5 meet the criteria for hypertension?b. None meet the criteria for hypertension?c. Less than or equal to 7 meet the criteria for hy-10pertension?209 PM^V 4 ENG 9/27/2019OBK Excel2007.pdf (SECURED) - Adobe Acrobat Pro DCndow Help9781284108217_w. x77 / 231149%5. Diastolic blood pressures are assumed to follow a nor-mal distribution with a mean of 85 and a standarddeviation of 12.a What pronortion of people have djastolic bloodthe number of coffee drinks per day follows a nor-pressure less than 90?

Note: Hey there! Thank you for the question. As you have posted multiple questions, we have helped…

1. Total cholesterol in children aged 10–15 years is as- sumed to follow a normal distribution with a mean of 191 and a standard deviation of 22.4. a. What proportion of children 10–15 years of age have total cholesterol between 180 and 190? b. What proportion of children 10–15 years of age would be classified as hyperlipidemic (Assume that hyperlipidemia is defined as a total choles- terol level over 200)? c. What is the 90th percentile of cholesterol levels?

1. Total cholesterol in children aged 10–15 years is as- sumed to follow a normal distribution with a mean of 191 and a standard deviation of 22.4. a. What proportion of children 10–15 years of age have total cholesterol between 180 and 190? b. What proportion of children 10–15 years of age would be classified as hyperlipidemic (Assume that hyperlipidemia is defined as a total choles- terol level over 200)? c. What is the 90th percentile of cholesterol levels?

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Q: Too much cholesterol in the blood increases the risk of heart disease. The cholesterol levels of…

A: From the provided information, Mean (µ) = 185 milligrams per decilitre Standard deviation (σ) = 39…

Q: Which proportion of a normal distribution is located between z = 0 and z = +1.50?

A: Solution: Here, it is needed to find the proportion of a normal distribution is located between z=0…

Q: The scores of an exam in a graduate level course follow a normal distribution with a mean of 62 and…

A: Given: Mean = µ = 62 Standard Deviation = σ = 6

Q: Imagine that scores for national aptitude exam have a normal distribution with a mean of 700 a…

A: Given: Mean = 700 Standard deviation = 30 Let X ~ N(700, 302)

Q: given a normal distribution curve, what is the area below a z-score of -1.2?

A: Given that, The z-score value is -1.2.

Q: Assume the average amount of caffeine consumed daily by adults is normally distributed with a mean…

Q: In a standard normal model, what percentage of values are less than 2.15? 2) In a standard normal…

A: We have given that Standard normal distribution X~N(0,1) mu=0 , sigma =1 Z-score =(x-mu)/sigma

Q: Find ?z such that the proportion of observations that are less than ?z in a standard normal…

A: Given in a standard normal distribution is 0.24

Q: What proportion of a normal distribution is within one standard deviation of the mean? (b) What…

A: Given normal distribution is within one standard deviation of the mean

Q: Suppose the monthly charges for cell phone plans are normally distributed with mean u= $57 and…

A: For the given cell phone charges, that is claimed to be distributed normally, using the empirical…

Q: 16.)Find the percent of the area under a normal curve between the mean and the given number of…

A: Since z-value for mean is 0. So the area under a normal curve between the mean and the given number…

Q: The heights of adult American men can be modeled by a normal distribution with mean μ = 69 inches…

A: The heights of adult American men can be modeled by a normal distribution with mean μ = 69 inches…

Q: Find the Z-score that describes the following proportions under the normal curve (within 0.01…

A: The area is middle 20%.

Q: The red blood cell counts (in millions of cells per microliter) for a population of adult males can…

A: a. Consider that a random variable x, defines the red blood cell count.

Q: Consider a normal distribution with µ=72 and ó=12 1. What is the score at the 25th percentile? 2.…

A: Given that, μ=72,σ=12 (1) The score at the 25th percentile is Therefore, the score at the 25th…

Q: A. About what percent of x values lie between the mean and one standard deviation (one sided)?…

Q: 2. A child is 40 inches tall, which places her at the 90th percentile of all children of similar…

Q: 2) A normal distribution has a mean of µ = 10 with o = 3.5. What proportion of the scores in this…

A: The question is about normal distribution.Given :Mean of a normal distribution ( ) = 10Standard…

Q: e) By examining the histogram of the weight data, determine the percent of the data that fall within…

A: Given that The histogram looks like bell shape or normally distributed

Q: What proportion of a normal distribution is located in the tail beyond z = 1.50?

A: It is given that the z-score is 1.50. The proportion of a normal distribution is located in the tail…

Q: 1 HW.pdf Upgrad- Sign- Name: Date: Class: Stats 6.1 Homework p. 281-285 #2, 4, 5, 7, 8, 15 2.…

A: “Since you have asked multiple question, we will solve the first question for you. If youwant any…

Q: Use the Standard Normal Distribution to answer the following question: The mean serum…

A: Given that Mean = 53 , s.d = 12 Find ( a ) P( X < = 60 ) =? ( b ) P( 29 < x < 77 ) = ?

Q: About what percentage of a normal distribution falls within 2.5 standard deviations of the mean?

A: 98.76 percentage of a normal distribution falls within 2.5 standard deviations of the mean

Q: Assume the birth weights at a local hospital have a normal distribution with a mean of 110 oz and a…

A: Given that, μ=110,σ=15 (a) The percentile rank is equal to 100×P(X<140) The value of P(X<140)…

Q: 1. IQ scores are standardized to produce a normal distribution with a mean of µ = 100 and a standard…

A: Standardized z-score: The standardized z-score represents the number of standard deviations the…

Q: According to the Center for Disease Control and Prevention (CDC), the mean life expectancy in 2015…

Q: 6. Find the area of the shaded region. The graph depicts the standard normal distribution of bone…

A: Given Data: Z follows standard normal distribution Mean=0 SD=1

Concept explainers

Continuous Probability Distributions

Probability distributions are of two types, which are continuous probability distributions and discrete probability distributions. A continuous probability distribution contains an infinite number of values. For example, if time is infinite: you could count from 0 to a trillion seconds, billion seconds, so on indefinitely. A discrete probability distribution consists of only a countable set of possible values.

Normal Distribution

Suppose we had to design a bathroom weighing scale, how would we decide what should be the range of the weighing machine? Would we take the highest recorded human weight in history and use that as the upper limit for our weighing scale? This may not be a great idea as the sensitivity of the scale would get reduced if the range is too large. At the same time, if we keep the upper limit too low, it may not be usable for a large percentage of the population!

Question

12:45
E Excel Computing Normal & Binomia... •..
ers as an excel file with properly labeled answers. At the
f the chapter 5 workbook you will find Practice problems
e answer in excel only under practice problems 5.4
ions: 1, 2, 3, 4, 5. If help is needed, tutorials are found in
Forkbook with relevant problems.
These pictures will give you an idea where it is in the
book. You are resp
onsible to use the workbook.
OBK_Excel2007.pdf (SECURED) - Adobe Acrobat Pro DC
ndow Help
9781284108217_W. x
76 / 231
149%-
VISTRIBUTION
Excel to compute the 90th and 95th percentiles of BMI for
men and women. The results are shown in Figure 5-12. In
Excel can also be used to compute percentiles for the standard
normal distribution and any normal distribution. The two rel-
men, 90% of BMIS are below 36.7, and 95% of BMIS are below
38.9. In women, 90% of BMIS are below 37.0, and 95% of BMIS
evant functions are NORMSINV and NORMINV, respectively.
The inputs for the functions are shown below. Recall from
Chapter 5 in the textbook that a percentile is a score that holds
a specified percentage or proportion of scores below it. For ex-
ample, the 80th percentile is the score that holds 80% of the
are below 39,5.
5.4
PRACTICE PROBLEMS
1. Total cholesterol in children aged 10-15 years is as-
sumed to follow a normal distribution with a mean
scores below it.
The function to compute percentiles for the standard nor-
of 191 and a standard deviation of 22.4.
a. What proportion of children 10–15 years of age
have total cholesterol between 180 and 190?
mal distribution is used as follows:
b. What proportion of children 10-15 years of age
would be classified as hyperlipidemic (Assume
that hyperlipidemia is defined as a total choles-
terol level over 200)?
c. What is the 90th percentile of cholesterol levels?
2. Among coffee drinkers, men drink a mean of 3.2 cups
per day, with a standard deviation of 0.8 cups. Assume
=NORMSINV(probability)
The input for the function is the desired percentile, entered as
a probability or proportion. For example, to compute the 80th
or the 95th percentile, we specify 0.80 or 0.95, respectively.
The function to compute percentiles for any normal dis-
tribution is used as follows:
Copyright © 2018 by Jones & Bartlett Learning, LLC, an Ascend Learning Company
208 PM
V- A 4 ENG
9/27/2019
DBK Excel2007.pdf (SECURED) - Adobe Acrobat Pro DC
ndow Help
9781284108217 W. x
77 / 231
149%
O Sh
72
Working with Probability Functions
c. If the top 5% of coffee drinkers are considered
heavy coffee drinkers, what is the minimum num-
ber of cups per day consumed by a heavy coffee
drinker? Hint: Find the 95th percentile.
3. A study is conducted to assess the
consumption, smoking, alcohol consumption, and
physical activity on cardiovascular disease. Suppose
that 40% of participants consume caffeine and
smoke. If 8 participants are evaluated, what is the
probability that:
a. Exactly half of them consume caffeine and smoke?
b. At most 6 consume caffeine and smoke?
4. A recent study of cardiovascular risk factors reported
that 30% of adults met criteria for hypertension. If 15
FIGURE 5-12 Percentiles of BMI for Men and
Women
Chapters.als (Co
of caffeine
Page I
Connections1
Home
Insert
Revie
K Clear
Reapoly
Advanced
Properties
Get External Refresh
Data
3I Sort
Columns
All
Connections
Sort & Fiter
D9
SNORMINV(C9,A9,89)
MEN
Percentile
0.9
0.95
Mean
Std Dev
BMI
29
29
36 68930939
38.86912176
WOMEN
Mean
28
Percentile
0.9
0.95
Std Dev
BMI
36 97086096
39 51397539
adults are assessed, what is the probability that:
28
a. Exactly 5 meet the criteria for hypertension?
b. None meet the criteria for hypertension?
c. Less than or equal to 7 meet the criteria for hy-
10
pertension?
209 PM
^V 4 ENG 9/27/2019
OBK Excel2007.pdf (SECURED) - Adobe Acrobat Pro DC
ndow Help
9781284108217_w. x
77 / 231
149%
5. Diastolic blood pressures are assumed to follow a nor-
mal distribution with a mean of 85 and a standard
deviation of 12.
a What pronortion of people have djastolic blood
the number of coffee drinks per day follows a nor-
pressure less than 90?

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

Step 2

Step 3

Step 4

Step 5

Trending now

This is a popular solution!

Step by step

Solved in 5 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Continuous Probability Distribution$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.

Similar questions

7. What percentage of z-scores in the standard normal distribution are less than z = 2.36?
glucose levels in oatients free of diabetes are assumed to follow a normal distribution with a mean of 120 and a standard deviation of 16. What proportion of patients have glucose levels exceesing 115?
14.What is the range of the center 50% of the batting average? 13. How high most players batting average be to fall in the top 25%? 16. What percentage of the batting averages are below 0.95? 15. What percentage of the batting averages fall between 0.228 and 0.294?
Suppose the mean retail price oer gallon of regular gasoline int the United States is $3.42 with a standard eviation of $0.40 and the retail price per gallon has a normal bell shaped distribution. Use the Empirical Rule to answer the following quesitona. What percentage of regular gasoline sold between $2.62 and $3.82 per gallon? what percentage of regualr gasoline sold for more the $3.82 per gallon?
1. Among American women aged 20 to 29 years, 10% are less than 60.8 inches tall, 80% are between 60.8 and 67.6 inches tall, and 10% are more than 67.6 inches tall. Assuming that the height distribution can adequately be approximated by a normal curve, find the mean and standard deviation of the distribution.
2. A. What percent of the area under a perfect normal curve lies between the mean and the mean +1 standard deviation as shown by the shaded area below? B. What percent of the area under a perfect normal curve lies in the shaded section in the graph shown below? -2 +1 0 +2 +3 1
According to a study conducted by a statistical organization, the proportion of people who are satisfied with the way things are going in their lives is 0.88. Suppose that a random sample of 100 people is obtained. Complete parts (a) through (e) below. (a) Suppose the random sample of 100 people is asked, "Are you satisfied with the way things are going in your life?" Is the response to this question qualitative or quantitative? Explain. A. The response is qualitative because the responses can be classified based on the characteristic of being satisfied or not. B. The response is quantitative because the number of people satisfied can be counted. C. The response is quantitative because the responses can be classified based on the characteristic of being satisfied or not. D. The response is qualitative because the number of people satisfied can be counted. (b) Explain why the sample proportion, p, is a random variable. What is the source…