Share via

T-test functions in Excel

Anonymous
2019-05-15T17:37:41+00:00

I'm currently trying to find p-values on a set of data. I have 6 data points, and when I perform the t-test using the Data Analysis tool, I get one value. When I use the =t.test or =ttest function, I get a different value that is several times larger. Using the =ttest function over the =t.test function was recommended in another post, but this did not solve the issue. Which p-value is correct, and why are they different?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2019-05-15T19:02:45+00:00

    The results of the t.test and ttest functions are based on Hypothesized Mean Difference equal to zero, and that assumption cannot be changed.

    The t-Test of the Analysis ToolPak allows you to specify the Hypothesized Mean Difference, and you specified 0.05.

    If you use the t-Test of the Analysis ToolPak and specify Hypothesized Mean Difference equal to zero, the results will show "P(T<=t) two-tail" equal to 0.187626 (formatted to show six decimal digits), which is the same as the results using the t.test and ttest functions.

    3 people found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-05-15T17:47:29+00:00
    0 comments
  2. Vijay A. Verma 104.8K Reputation points Volunteer Moderator
    2019-05-15T17:40:26+00:00

    Hi Neil_6803

    I am Vijay, an Independent Advisor. I am here to work with you on this problem.

    Can you please post a screenshot of your worksheet without any confidential / sensitive data? Make sure that your row numbers and column letters are visible in the screenshot.

    Then I can experiment on your data set to see the results.

    0 comments