SOLVED

Calculating F-test or T-test manually

%3CLINGO-SUB%20id%3D%22lingo-sub-1746661%22%20slang%3D%22en-US%22%3ECalculating%20F-test%20or%20T-test%20manually%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1746661%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20can%20the%20F-Test%20or%20T-Test%20be%20performed%20manually%3F%26nbsp%3B%20Specifically%20when%20using%20the%20F.DIST%20function%2C%20what%20does%20the%20%22x%22%20refer%20to%3F%26nbsp%3B%20I%20would%20like%20to%20compare%20two%20data%20sets%2C%20however%20the%20formula%20is%20asking%20for%20a%20single%20value%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1746661%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1746871%22%20slang%3D%22en-US%22%3ERe%3A%20Calculating%20F-test%20or%20T-test%20manually%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1746871%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F820859%22%20target%3D%22_blank%22%3E%40tplyle%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EF.DIST%20returns%20the%20value%20of%20the%20%3CA%20href%3D%22https%3A%2F%2Fen.wikipedia.org%2Fwiki%2FF-distribution%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EF-distribution%3C%2FA%3E%20for%20a%20specific%20point%20(x)%20on%20the%20curve.%20It%20does%20not%20perform%20the%20%3CA%20href%3D%22https%3A%2F%2Fen.wikipedia.org%2Fwiki%2FF-test%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EF-test%3C%2FA%3E.%20Use%20the%20F.TEST%20function%20for%20that.%3C%2FP%3E%0A%3CP%3EThe%20T.TEST%20function%20evaluates%20the%20%3CA%20href%3D%22https%3A%2F%2Fen.wikipedia.org%2Fwiki%2FStudent%2527s_t-test%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3ET-test%3C%2FA%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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.