Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. statistics
  3. hey im having trouble with this use excel to find

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

Other questions asked by students

Q

What is the formula to calculate how much a savings accountwould be worth if...

Accounting
Q

Part A At a pH of 7.40, what is the ratio of the molar concentrations of HPO42−...

Chemistry
Q

In 1965, AB Hill described nine aspects of an association to consider before interpreting it as...

Medical Sciences
Q

Determine the remaining sides and angles of the triangle ABC A 22 62 B 36...

Geometry
Q

Find the derivative of f t t4 t5 1 t6 f t Plot the graphs...

Calculus
Q

By reviewing IBMs balance sheets, we learn: Group of answer choices IBM must have made...

Accounting
Q

Haas Company manufactures and sells one product. The following information pertains to each of the...

Accounting
Q

The Strill Oil Company is trying to decide whether to lease or buy a new...

Accounting
Q

Gross Profit During the current year, merchandise is sold for $162,400 cash and $485,900 on...

Accounting
Q

Statutes relating to a shareholder s right to inspect corporate records usually DO NOT include......

Accounting
Q

A company purchased 500 units for $ 30 each on January 31. It purchased 650...

Accounting
Q

Question 1 1.5 pts The random variable x is known to be uniformly distributed between...

Accounting