software

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: www.excelforum.com/member.php...oamp;userid=17538
View this thread: www.excelforum.com/showthread...hreadid=493992gpktm -

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

gt; wrote in message
...
gt;
gt; How do I use the Student, x^2 and Gaus (normal) distributions?
gt;
gt; For example in student distribution for n samples and error probability
gt; of 5% I'm going to Student's table I'm going in n-1 row and t=95 and
gt; find the corresponding number. But in Excel I don't know how it works.
gt;
gt;
gt; --
gt; gpktm
gt; ------------------------------------------------------------------------
gt; gpktm's Profile:
gt; www.excelforum.com/member.php...oamp;userid=17538
gt; View this thread: www.excelforum.com/showthread...hreadid=493992
gt;
Your description seems a bit garbled, but you migt want to see help for
TINV and NORMINV functions.

Jerry

gpktm wrote:

gt; How do I use the Student, x^2 and Gaus (normal) distributions?
gt;
gt; For example in student distribution for n samples and error probability
gt; of 5% I'm going to Student's table I'm going in n-1 row and t=95 and
gt; 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.--
gpktm
------------------------------------------------------------------------
gpktm's Profile: www.excelforum.com/member.php...oamp;userid=17538
View this thread: www.excelforum.com/showthread...hreadid=493992