B
BJBenton
I am trying to put together a spreadsheet to calculate the pricing of
financial options. However I need a column for the value of N(x) which using
polynomial approximation gives the probability that a normally distributed
variable with a mean of zero and a standard deviation of 1 is less than x. Is
this a possible function on EXCEL and if so how do i use it?
financial options. However I need a column for the value of N(x) which using
polynomial approximation gives the probability that a normally distributed
variable with a mean of zero and a standard deviation of 1 is less than x. Is
this a possible function on EXCEL and if so how do i use it?