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
Get step-by-step solutions from verified subject matter experts
