SOLVED

Calculating F-test or T-test manually

Copper Contributor

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?

1 Reply
best response confirmed by allyreckerman (Microsoft)
Solution

@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.

1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@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.

View solution in original post