IF Possible answer in Excel with formulas 1. A patient is classified as having gestational diabetes if their average glu

[answerhappygod]

If Possible Answer In Excel With Formulas 1 A Patient Is Classified As Having Gestational Diabetes If Their Average Glu 1 (75.69 KiB) Viewed 87 times

IF Possible answer in Excel with formulas 1. A patient is classified as having gestational diabetes if their average glucose level is above 140 milligrams per deciliter (mg/dl) one hour after a sugary drink is ingested. Rebecca's doctor is concerned that she may suffer from gestational diabetes. There is variation both in the actual glucose level and in the blood test that measures the level. Rebecca's measured glucose level one hour after ingesting the sugary drink varies according to the Normal distribution with u=140+# mg/dl and o=#+1 mg/dl, where # is 2 Using the Central Limit Theorem, determine the probability of Rebecca being diagnosed with gestational diabetes if her glucose level is measured: a. Once? b. n=#+2 times, where # is 2? c. n=#+4 times, where # is 2? d. Comment on the relationship between the probabilities observed in (a), (b), and (C). Explain, using concepts from lecture why this occurs and what it means in context. For each part, insert your sketch of the required area under the normal curve. In addition, include a screenshot of your Excel computation to find this area. i. Insert screenshot and figure for part (a) ii. Insert screenshot and figure for part (b) iii. Insert screenshot and figure for part (c) iv. Comment on the relationship among the probabilities in parts (alb), and (c).