Oct 05 2020 10:57 AM
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?
Oct 05 2020 11:44 AM
SolutionF.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.
Oct 05 2020 11:44 AM
SolutionF.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.