I need help getting started with this assignment. I don't know what the starting part should be. What should I enter into excel to begin? I am a week beind the due date, so any help would be greatly appreciated. AutoSaveOffEXCEL EXERCISE WEEK 3 - Saved to this PC -P SearchStephanie R HowardFileHomeInsertDrawDesignLayoutReferencesMailingsReviewViewHelpA ShareP CommentsX CutO FindReplaceAav A E -E - E -vTimes New Rom v 12- A AAaBbCcDc AaBbCcD AaBbC AaBbCcC AaB AaBbCcC AaBbCcD AaBbCcDtB CopyPasteBI U - ab x, x' A- ev A -1 NormalEditorDictate三三。。I No Spac. Heading 1 Heading 2TitleSubtle Em. EmphasisSubtitleS Format PainterA Select vClipboardFontParagraphStylesEditingVoiceEditorEXCEL EXERCISE WEEK 3For this exercise, please refer to the downloaded Excel Workbook (See Excel WorkbookInstructions) from the JB Learning website with your access code. Please upload your answers asan excel file with properly labeled answers. At the end of the chapter 5 workbook, you will findPractice problems. Please answer in excel only under practice problems 5.4 questions: 1, 2, 3, 4,5. If help is needed, tutorials are found in the workbook with relevant problems.Note: These pictures will give you an idea where it is in the workbook. You are responsible to usethe workbook.A 9781284108217 WOBK Excel2007.pdf (SECURED - Adobe Acrobat Pro DcFile Edit View Window HelpHomeTools9781284100217 W76 / 231O Share149%VISTRIBUTIIONExcel to compute the 90th and 95th percentiles of BMI forExcel can also be used to compute percentiles for the standardnormal distribution and any normal distribution. The two rel-evant 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 holdsmen and women. The results are shown in Figure 5–12. Inmen, 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 BMISare below 39.5.5.4PRACTICE PROBLEMSa specified percentage or proportion of scores below it. For ex-ample, the 80th percentile is the score that holds 80% of thescores below it.The function to compute percentiles for the standard nor-1. Total cholesterol in children aged 10-15 years is as-sumed to follow a normal distribution with a meanof 191 and a standard deviation of 22.4.mal distribution is used as follows:a. What proportion of children 10–15 years of agehave total cholesterol between 180 and 190?b. What proportion of children 10-15 years of age-NORMSINV(probability)would be classified as hyperlipidemic (AssumeThe input for the function is the desired percentile, entered asthat hyperlipidemia is defined as a total choles-a probability or proportion. For example, to compute the 80thor the 95th percentile, we specify 0.80 or 0.95, respectively.terol level over 200)?c. What is the 90th percentile of cholesterol levels?2. Among coffee drinkers, men drink a mean of 3.2 cupsner dav with a standard deviation.of 08.cuns AssumeThe function to compute percentiles for any normal dis-tribution is used as folloaePage 1 of 2O Focus101 words132% AutoSaveOffEXCEL EXERCISE WEEK 3 - Saved to this PC -P SearchStephanie R HowardFileDesignReferencesMailingsReviewViewHelpA ShareP CommentsHomeInsertDrawLayoutX CutO FindReplace- A A Aa - AvTimes New Rom v 12AaBbCcDc AaBbCcDc AaBbC AaBbCcC AaB AaBbccc AaBbCcD AaBbCcDB CopyPaste三三。。I NormalI No Spac. Heading 1 Heading 2EditorBIU v ab x. x A - Iv A vTitleSubtitleSubtle Em. Emphasis -DictateS Format PainterA Select vClipboardFontParagraphStylesEditingVoiceEditorWorking with Probability Functions72c. If the top 5% of coffee drinkers are consideredFIGURE 5-12 Percentiles of BMI for Men andheavy coffee drinkers, what is the minimum num-Womenber of cups per day consumed by a heavy coffeedrinker? Hint: Find the 95th percentile.Chaptersls Co3. A study is conducted to assess the impact of caffeineconsumption, smoking, alcohol consumption, andphysical activity on cardiovascular disease. SupposeHomeInsertPage LayoutFormulasData ReviewConnectionsPropertiesCearReapplyTert toAdvanced ColumnFiterGet External RetreshDataAl Edt LinksConnections11 Sortthat 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?Sot & FiterD9NORMINV(C9,AS,89)A B C1MEND.2MeanStd DevPercentile09BMI2936.689309392960 9538.86912176A recent study of cardiovascular risk factors reportedthat 30% of adults met criteria for hypertension. If 15adults are assessed, what is the probability that: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-4.6 WOMEN7.Percentile0.90 95Std DevBMIMean282836 9708609639 513975391011pertension?209 PMofUw6 0 ENG9/27/2019A 9781284108217 woaK Excel2007.pdf (SECURED - Adobe Acrobat Pro DCFile Edit View Window HelpHomeTools9781284108217 W77 / 231149%O Share5. Diastolic blood pressures are assumed to followa nor-mal distribution with a mean of 85 and a standarddeviation of 12.Whata. proportion of people have diastolic bloodpressure less than 90?b. What proportion have diastolic blood pressure be-tween 80 and 90?c. If someone has a diastolic blood pressure of 100,what percentile is he/she in?the number of coffee drinks per day follows a nor-mal distribution.a. What proportion drink 2 cups per day or more?b. What proportion drink no more than 4 cups perday?Page 2 of 2D Focus101 words132%

Name: I need help getting started with this assignment. I don't know what th
Uploaded: 2024-03-20T07:07:26.000Z
Channel: Bartleby
Description: I need help getting started with this assignment. I don't know what the starting part should be. What should I enter into excel to begin? I am a week beind the due date, so any help would be greatly appreciated. AutoSaveOffEXCEL EXERCISE WEEK 3 - Sav