Question 10 (1 point) What value does the NORM.INV function return with the following arguments: Standard Deviation = 2.35 Mean = 10 Probability = 50%
Added by Marta K.
Close
Step 1
INV function. The NORM.INV function (or NORMINV in some software like Excel) returns the inverse of the normal cumulative distribution for a specified mean and standard deviation. In simpler terms, given a probability, mean, and standard deviation, it finds the Show more…
Show all steps
Your feedback will help us improve your experience
Pritesh Ranjan and 64 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
For a process that follows the normal distribution, with mean 50 and standard deviation of 10, determine the probability of the process producing a result of 35 or less
Pritesh R.
Step 1: Use the NORM.S.DIST function to calculate the following probabilities using a standard normal distribution (Z). Note: Use cumulative probabilities and show 3 decimal places but do not round. Probability of a Z score < 1.55 = Probability of a Z Score > 1.55 = Probability of a Z Score < -1.55 = Probability of a Z Score > -1.55 = Probability of a Z Score between -1.55 and 1.55 = Step 2: Complete the table below by calculating the Z scores and probability that the value will be less than the calculated Z scores. Show 3 decimals in the Probability column but do not round. Value Mean St Deviation Z Score Probability 35 45 10 35 45 6 35 25 10 35 25 20 Step 3: Use the NORM.S.INV function to calculate the Z score from the standard distribution for the 90th percentile and use the NORM.INV function to calculate the value of a data point at the 90th percentile from a normal distribution with a mean of 35 and a standard deviation of 25. Show 3 decimals but do not round. 90th percentile from standard normal = 90th percentile value from stated normal distribution =
Sri K.
Find the 30th percentile for the standard normal distribution Find the 30th percentile for a normal distribution with mean 10 and std. dev. 1.5
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD