The random variable Z is standard normal distributed
Ask Expert

Be Prepared For The Toughest Questions

Practice Problems

The random variable Z is standard normal distributed

Problem#16.  Standard Normal Distribution

Answer the following questions using Excel functions. The random variable Z is standard normal distributed. 

a) P(Z ≤ 0.4) = ?

b) P(-0.75 ≤ Z ≤ 0.6) = ?

c) Find the value of C such that P(Z<=C)=0.15.

d) Find the value of C such that P(Z>=C)=0.08.

Problem#17.  Standard Normal Distribution

Use Excel to compute the following for a standard normal distributed random variable Z. 

a) P(Z > 0.6)=?

b) P(-0.2 ≤ Z ≤ 0.2)=?

c) P(0.2 ≤ Z ≤ 0.5)=?

d) Find the value of C such that P(Z > C) = 0.75.

Hint
Accounts & Finance Excel functions include count and sum, logical, cell references, and date and time. Excel is a computer program that plays key roles in many sectors. It is the popular and commonly used spreadsheet program in numerous business activities, classwork, and even personal data organization....

Know the process

Students succeed in their courses by connecting and communicating with
an expert until they receive help on their questions

1
img

Submit Question

Post project within your desired price and deadline.

2
img

Tutor Is Assigned

A quality expert with the ability to solve your project will be assigned.

3
img

Receive Help

Check order history for updates. An email as a notification will be sent.

img
Unable to find what you’re looking for?

Consult our trusted tutors.

Developed by Versioning Solutions.