hey im having trouble with this Use Excel to find the Standard Normal Probability for the following...

50.1K

Verified Solution

Question

Statistics

hey im having trouble with this
Use Excel to find the Standard Normal Probability for thefollowing questions. Don't forget to sketch the normal distributionand shade the required area.
a) What is the area under the standard normal curve to the leftof z = 0.89? (4dp) Answer
b) What is the area under the standard normal curve between z =-0.89 and z = 1.63? (4dp) Answer
c) What is the z-value that gives the right hand tail area equalto 0.0268? (2dp) Answer d) What is the absolute value of z suchthat the total area under the standard normal curve between â€“z and+z will be 0.9443? (2dp) Answer

Answer & Explanation Solved by verified expert

4.3 Ratings (895 Votes)

In an Excel spreadsheet the functionNORMSDISTzgives area under the standard normal curve probability for theinterval from to z aGiven z 089Using excel formulaNORMSDIST08908133 round upto four decimals place The area See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member