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?

Question

Accepted Answer

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