is distributed as a standard normal variable. Given the following probability, find the z corresponding to the probability. Round your answer to two decimal places, e.g. 0.31. Find the value of a such that Pr(Z > a) = 0.279 by using Excel What is the excel formula

Holt Mcdougal Larson Pre-algebra: Student Edition 2012
1st Edition
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Chapter7: Percents
Section7.1: Percents And Fractions
Problem 31E
icon
Related questions
Question
100%

Z is distributed as a standard normal variable. Given the following probability, find the z corresponding to the probability. Round your answer to two decimal places, e.g. 0.31.

Find the value of a such that Pr(Z > a) = 0.279 by using Excel

What is the excel formula

Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Calculus For The Life Sciences
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill