I hope I'm not doing someone's homework, but this is a normal distribution table that you can exactly duplicate in excel.

the NORMDIST function wants four arguments. First is the point on the distribution you want. Here it is the sum of the number on the left and the number on the top of the table (0.1 + 0.01) for second row, second column.

Second is the mean for your normal distribution. Here they are using a mean of zero. Third is the standard deviation of your normal distribution. Here they are using 1.

Fourth is True if you want the area under the curve.

Only trick here is they are showing area * above* the point, not below. So just calculate 1 minus the NormDist result.

If this was homework, please read your statistics book. This stuff is important.:biggrin: