Question: a) make standard Normal distribution plot (Normal curve, a Bell shaped curve). In Excel, list a column for z-value for the range of (-3.5, 3.5)

a) make standard Normal distribution plot (Normal curve, a Bell shaped curve). In Excel, list a column for z-value for the range of (-3.5, 3.5) with Increment of 0.5, calculate in another column for Norm .S. Distribution (z-value, False), then plot 'Scatter with Smooth Lines' plot on both columns.

b) Find the z value (to two decimal places) that cuts off an area in the upper tail section of the standard normal curve with following probabilities and label them on x-axis of the figure-

1)0.25 2) 0.05 3) 0.025 4)0.001

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!