Using EXCEL for Standard Normal Distribution Probabilities
Please see the attached file for the full problem description.
Let Z be a standard normal random variable. Use a calculator to determine the value of c such that:
P (c <= Z <= 1.24) = 0.8533
Carry your intermediate computations to at least four decimal places. Round your answer to at least two decimal places.
© BrainMass Inc. brainmass.com June 7, 2023, 2:30 pm ad1c9bdddfhttps://brainmass.com/statistics/probability/using-excel-for-standard-normal-distribution-probabilities-13483
Solution Summary
This solution shows how to use EXCEL when working with a standard normal probability distribution. You can use EXCEL functions the same way you would use calculator functions when working with a standard normal probability distribution, eliminating the need to use the Z tables. Attached to this solution is a Word document which contains the solution.
Free BrainMass Quizzes
-
This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.
-
Terms and Definitions for Statistics
This quiz covers basic terms and definitions of statistics.
-
Tests knowledge of the three main measures of central tendency, including some simple calculation questions.
-
Know Your Statistical Concepts
Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.