LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
plh plh is offline
external usenet poster
 
Posts: 48
Default [Statistical functions] Function to return result from Z table?

Here is what I am wondering, is there a statistical function in Excel that,
given a value of Z, returns the look up value from a Cumulative Standard Normal
Distribution table? That is, if Z = 0, returns .5, if Z = 1, returns .84134, if
2, .97725, etc.
Thanx,
-plh


--
Where are we going and why am I in this HAND BASKET??
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
can a function return part of it's result in italics? Jamie Excel Worksheet Functions 1 June 2nd 08 08:46 PM
Help with Excel array functions - select, add & return result [email protected] Excel Worksheet Functions 0 July 12th 07 06:36 PM
All arithmetic functions return Zero as result Khoshravan Setting up and Configuration of Excel 9 June 26th 06 03:24 AM
Need subtotal function to return text as result Alby Excel Discussion (Misc queries) 0 February 15th 06 10:47 PM
using muliple functions to return one result tauwnia Excel Worksheet Functions 1 January 17th 06 08:45 PM


All times are GMT +1. The time now is 07:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"