# Z Table Extra Credit Assignment (due at the start of class on Tuesday, September 7)

Here’s an extra credit opportunity for Finance 4335. Working on your own (i.e., this is not a group project; credit will only be given for spreadsheets that are uniquely your own), build your own “z” table in Excel (patterned after the table located at http://fin4335.garven.com/stdnormal.pdf); the top row should have values ranging from 0.00 to 0.09, and the first column should have z values ranging from -3.0 to +3.0, in increments of 0.1).

Quite conveniently, Excel has the standard normal distribution function built right in; e.g., if you type “=normsdist(z)”, Excel returns the probability associated with whatever z value that you provide. Not surprisingly, if you type “=normsdist(0)”, .5 is returned since half of the area under the curve lies to the left of the expected value E(z) = 0. Similarly, if you type “=normsdist(1)”, then .8413 is returned because 84.13% of the area under the curve lies to the left of z = 1. Perhaps you recall from your QBA course that 68.26% of the area under the curve lies between z = -1; this “confidence interval” of +/- 1 one standard deviation away from the mean (E(z)=0) is calculated in Excel with the following code: “=normsdist(1)-normsdist(-1)”, and so forth.