Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to use distribution functions?
How do I use the Student, x^2 and Gaus (normal) distributions? For example in student distribution for n samples and error probability of 5% I'm going to Student's table I'm going in n-1 row and t=95 and find the corresponding number. But in Excel I don't know how it works. -- gpktm ------------------------------------------------------------------------ gpktm's Profile: http://www.excelforum.com/member.php...o&userid=17538 View this thread: http://www.excelforum.com/showthread...hreadid=493992 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to use distribution functions?
gpktm -
See Excel's online or offline Help for examples of the TDIST, CHIDIST, and NORMDIST worksheet functions. Then ask specific questions. (Your original question did not specify one-tail versus two-tail. And if you want an exact correspondence between Excel and a table from a book, you'll have to specify the exact assumptions for the book's table. For example, your book may be assuming degrees of freedom for the t distribution is df = n-1, but the t distribution is used in other contexts, like multiple regression, where df is not necessarily n-1.) - Mike www.mikemiddleton.com wrote in message ... How do I use the Student, x^2 and Gaus (normal) distributions? For example in student distribution for n samples and error probability of 5% I'm going to Student's table I'm going in n-1 row and t=95 and find the corresponding number. But in Excel I don't know how it works. -- gpktm ------------------------------------------------------------------------ gpktm's Profile: http://www.excelforum.com/member.php...o&userid=17538 View this thread: http://www.excelforum.com/showthread...hreadid=493992 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to use distribution functions?
Your description seems a bit garbled, but you migt want to see help for
TINV and NORMINV functions. Jerry gpktm wrote: How do I use the Student, x^2 and Gaus (normal) distributions? For example in student distribution for n samples and error probability of 5% I'm going to Student's table I'm going in n-1 row and t=95 and find the corresponding number. But in Excel I don't know how it works. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to use distribution functions?
Nevermind I found it, and by the way it wasn't any of these functions (TDIST, CHIDIST, NORMDIST). It was the inverse function of t distribution. -- gpktm ------------------------------------------------------------------------ gpktm's Profile: http://www.excelforum.com/member.php...o&userid=17538 View this thread: http://www.excelforum.com/showthread...hreadid=493992 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User-defined functions created in Excel 2000 fail in Excel 2003 | Excel Discussion (Misc queries) | |||
Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
Are there functions that perform robust statistics in Excel? | Excel Worksheet Functions | |||
Visible rows and functions that work | Excel Worksheet Functions | |||
Distribution functions | Excel Worksheet Functions |