If there are 7 sampled data points that were perfectly Normally distributed, there
would be 1/7 of the total Normal curve area between each sampled point.
The Z Score at each sampled point are found with the following Excel formula:
NORMSINV (CDF at each Sample Point)
The Expected Sample Values are found by the following Excel formula:
NORMINV (CDF at Sample Point, Sample Mean, Sample Stan. Dev.)