 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / December 2005How 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.  Signaturegpktm 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 > 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. 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. Signaturegpktm Your description seems a bit garbled, but you migt want to see help for TINV and NORMINV functions. Jerry > 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.