area under a distribution curve

["Walter Lake" <wlake@xxxxxxxxx>]

If I have a daily High Low range of 45 ticks, for example, and I want to
figure out the upper and lower values for 50% of the area under a normal
distribution curve ... how do I do this in Excel?

a Z-score of 0.67 will give me an area in the tails of 0.5029 which is close
enough.

Best regards

Walter

Attachment Converted: "c:\eudora\attach\img0152.gif"