Forum Discussion

tplyle's avatar
tplyle
Copper Contributor
Oct 05, 2020
Solved

Calculating F-test or T-test manually

How can the F-Test or T-Test be performed manually?  Specifically when using the F.DIST function, what does the "x" refer to?  I would like to compare two data sets, however the formula is asking for...
  • HansVogelaar's avatar
    Oct 05, 2020

    tplyle 

    F.DIST returns the value of the F-distribution for a specific point (x) on the curve. It does not perform the F-test. Use the F.TEST function for that.

    The T.TEST function evaluates the T-test.

Resources