Forum Discussion
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 a single value?
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.
1 Reply
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.