+ Reply to Thread
Results 1 to 3 of 3

Thread: p-value in excel

  1. #1
    Points: 3,400, Level: 36
    Level completed: 34%, Points required for next Level: 100

    Location
    Adelaide, Australia
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    p-value in excel




    the formula =TDIST(ABS(X10),18,2) gives the p-value.
    How does it do this? I know there's the degrees of freedom, but i have no idea what that is all about. HELP!

    Thanks in advance!

  2. #2
    TS Contributor
    Points: 13,042, Level: 74
    Level completed: 48%, Points required for next Level: 208
    JohnM's Avatar
    Posts
    1,948
    Thanks
    0
    Thanked 5 Times in 4 Posts
    The p-value is the probability of obtaining the t statistic (or larger) if the null hypothesis is true.

  3. #3
    Dark Knight
    Points: 2,479, Level: 30
    Level completed: 20%, Points required for next Level: 121
    vinux's Avatar
    Posts
    1,898
    Thanks
    45
    Thanked 193 Times in 160 Posts

    Quote Originally Posted by resonance View Post
    the formula =TDIST(ABS(X10),18,2) gives the p-value.
    How does it do this? I know there's the degrees of freedom, but i have no idea what that is all about. HELP!

    Thanks in advance!

    I guess you need the following.

    X10 is the t-statistic value.
    and
    Pvalue = TDIST(ABS(X10),18,2) = P[ T<-X10 or T >X10 ]

    where T follows Student's T distribution with 18 df
    In the long run, we're all dead.

+ Reply to Thread

           




Similar Threads

  1. [Excel] - My Excel Template for Robust Statistics
    By gianmarco in forum Other Software
    Replies: 6
    Last Post: 04-27-2011, 01:50 PM
  2. Replies: 2
    Last Post: 10-28-2010, 04:14 AM
  3. Excel - please help
    By Fred in forum Statistics
    Replies: 3
    Last Post: 04-09-2009, 12:20 PM
  4. Excel Help
    By utkstudent in forum Statistics
    Replies: 2
    Last Post: 03-07-2009, 11:44 AM
  5. Excel TTEST() vs Excel DataAnalysis\t-test
    By fiducial in forum Statistics
    Replies: 5
    Last Post: 02-06-2008, 12:49 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts






Advertise on Talk Stats