+ Reply to Thread
Results 1 to 4 of 4

t-Tests and p-Values

  1. #1
    Registered User
    Join Date
    05-12-2015
    Location
    Edmond, Oklahoma
    MS-Off Ver
    Office 2013
    Posts
    2

    t-Tests and p-Values

    I'm writing a guide for students using Excel in a lab course, and I've run into a little problem regarding consistency in Excel. When I run a t-test in the Data Analysis tool, I get a different result than if I use the =t.test function. The Data Analysis tool yields a p-value of 0.4631, while the t.test function gives me 0.4624. I made sure that I used the same settings for both (two-tailed, unequal variances). I also hand-calculated the degrees of freedom for the test, and it should be 11.46 or so, and the Data Analysis output yields 11, so I suspect that the function floats the degrees of freedom, while the tool approximates it to a whole number.

    I'm not sure, though, and I wanted to make sure I don't tell the students to do something wrong. To anyone who considers this problem, thank you.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,863

    Re: t-Tests and p-Values

    Attach sample data.
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    05-12-2015
    Location
    Edmond, Oklahoma
    MS-Off Ver
    Office 2013
    Posts
    2

    Re: t-Tests and p-Values

    You can find the whole file here.

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,863

    Re: t-Tests and p-Values

    May be function uses Welch-Satterthwaite correction?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] IF/OR, logical tests
    By aejaz7 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-12-2012, 08:55 AM
  2. 1 Fn, 2 Logical tests, 1 True value, 2 False values
    By ryanchry in forum Excel General
    Replies: 2
    Last Post: 01-03-2012, 04:09 PM
  3. If statement - 2 tests
    By RobertLees in forum Excel Formulas & Functions
    Replies: 25
    Last Post: 09-07-2005, 12:05 AM
  4. Replies: 4
    Last Post: 08-18-2005, 11:05 PM
  5. excel tests
    By Dave in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-11-2005, 02:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1