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: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

define the concepts of monopoly and oligopoly and discuss the extent to which large corporations are...

Psychology
Q

Graph the equation by hand by plotting points. Verify your results using a graphing utility.y=2x+9

Basic Math
Q

The radius of a circular disk is given as 29 cm with a maximum error...

Calculus
Q

There are 1 368 grams of CS What is the mass of the carbon if...

Algebra
Q

Find each quotient Simplify your answers 1 1 1 500 to check 4 58 2...

Algebra
Q

(a) journalize the transactions 4-P13-2A ASSIGMENT CAP 13 PAG...

Accounting
Q

Required information [The following information applies to the questions displayed below.] Suresh...

Accounting
Q

Exercise 16-12 Determining the payback period LO 16-4 Baird Airline Company is considering expanding its...

Accounting
Q

Current Attempt in Progress The Brambenisa restaurant in Flagstaft Arrons it species in southwesternstie masina...

Accounting
Q

Good to Go Auto Products distributes automobile parts to service stations and repair shops. The...

Accounting
Q

5 . Calculate the annual amount of interest (assuming no principal repayment) for each...

Accounting
Q

Bed \& Bath, a retailing company, has two departments - Hardware and Linens. The company's...

Accounting