Page

The Excel Inverse Standard Normal Distribution Function, NORMSINV(P), returns the z score which has an area to the left equal to P. Parallel to the other two columns column to enter a third column generated by NORMSINV(j/46). This will provide a column of 45 z scores distributed across N(0, 1) with equal probability between each score. ... ................
................