Sheila's doctor is concerned that she may suffer from gestational diabetes (high blood glucose levels during pregnancy). There is variation both in the actual gluco level and in the blood test that measures the level. A patient is classified as having gestational diabetes if her glucose level is above 155 milligrams per deciliter (mg/ one hour after a sugary drink. Sheila's measured glucose level one hour after the sugary drink varies according to the normal distribution with u 140 mg/dl and =
Sheila's doctor is concerned that she may suffer from gestational diabetes (high blood glucose levels during pregnancy). There is variation both in the actual gluco level and in the blood test that measures the level. A patient is classified as having gestational diabetes if her glucose level is above 155 milligrams per deciliter (mg/ one hour after a sugary drink. Sheila's measured glucose level one hour after the sugary drink varies according to the normal distribution with u 140 mg/dl and =
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
How would you do this in excel?
![**Educational Website Text:**
Sheila's doctor is concerned that she may suffer from gestational diabetes (high blood glucose levels during pregnancy). There is variation both in the actual glucose level and in the blood test that measures the level. A patient is classified as having gestational diabetes if her glucose level is above 155 milligrams per deciliter (mg/dl) one hour after a sugary drink. Sheila's measured glucose level one hour after the sugary drink varies according to the normal distribution with \( \mu = 140 \) mg/dl and \( \sigma = 12 \) mg/dl. Suppose Sheila repeats this process on three separate randomly selected days.
What sample mean blood glucose level is higher than 95% of all other sample mean blood glucose levels? Use 2 decimal places.
**[Incorrect Submission Box]**
- 159.74
**Feedback**
**General Feedback**
Hint: this requires a backwards normal calculation, so draw and picture to identify the requested percentile, then use the =norm.inv(probability, \(\mu\), \(\sigma\)) function in Excel.
Note: it is OK to use the normal distribution here because the population is normally distributed. So the distribution of \( \bar{x} \) is **exactly** normal, regardless of the sample size.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F29b25716-5eb6-4537-b644-b049114aff43%2Ff435800c-e322-432c-b98b-2301860f28ed%2Frj6zxg_processed.png&w=3840&q=75)
Transcribed Image Text:**Educational Website Text:**
Sheila's doctor is concerned that she may suffer from gestational diabetes (high blood glucose levels during pregnancy). There is variation both in the actual glucose level and in the blood test that measures the level. A patient is classified as having gestational diabetes if her glucose level is above 155 milligrams per deciliter (mg/dl) one hour after a sugary drink. Sheila's measured glucose level one hour after the sugary drink varies according to the normal distribution with \( \mu = 140 \) mg/dl and \( \sigma = 12 \) mg/dl. Suppose Sheila repeats this process on three separate randomly selected days.
What sample mean blood glucose level is higher than 95% of all other sample mean blood glucose levels? Use 2 decimal places.
**[Incorrect Submission Box]**
- 159.74
**Feedback**
**General Feedback**
Hint: this requires a backwards normal calculation, so draw and picture to identify the requested percentile, then use the =norm.inv(probability, \(\mu\), \(\sigma\)) function in Excel.
Note: it is OK to use the normal distribution here because the population is normally distributed. So the distribution of \( \bar{x} \) is **exactly** normal, regardless of the sample size.
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!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman