Standard Normal Loss Value

G

Guest

How do I find the Standard Normal Loss value in Excel?
I can find the function for Standard Normal, but I also need the Loss value.

James
 
G

Guest

I have no experience with this usage, but a Google search on "Standard Normal
Loss" gives many hits. The first being a power point presentation that on
slide 10 defines the standard normal loss function L(z) as
=NORMDIST(z,0,1,FALSE)-z*NORMSDIST(-z)
so it seems to be dealing with the discrepancy between the actual tail
probability and the 1-term asymptotic approximation to the tail probability

Jerry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

running total of difference 4
Acoustics - 80Hz loss in car! 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
subtraction task 5
Lost bottom toolbar and gray panel appeared at left 6
spreadsheet with negitive numbers 1
How do I save the Recent Colors that I frequently use in Excel. 1
Finding Cell with Minor loss of fidelity 1

Top