FTEST function

Excel » Functions » Compatibility » FTEST function »

How to use the FTEST function

The FTEST function calculates the value from an F-test. The value shows if the variances from two data sets are […]

English

Spanish

Share
Tweet

Additional Info
Excel functions Compatibility BETADIST function BETAINV function BINOMDIST CHIDIST function CHIINV function CHITEST function CONFIDENCE COVAR function CRITBINOM EXPONDIST FDIST function FLOOR function FORECAST function FTEST function GAMMADIST LOGNORMDIST MODE function PERCENTRANK QUARTILE function RANK function STDEV function Database DAVERAGE function DCOUNT function DCOUNTA function DGET function DMAX function DMIN function DPRODUCT function DSTDEV function DSTDEVP function DSUM function DVARP function Date and Time DATE function DATEDIF function DATEVALUE DAY function DAYS function [2013] EDATE function EOMONTH function HOUR function MINUTE function MONTH function NETWORKDAYS NETWORKDAYS.INTL [2010] NOW function SECOND function TIME function TIMEVALUE TODAY function WEEKDAY function WEEKNUM function WORKDAY function YEAR function YEARFRAC function Engineering BIN2DEC function BIN2HEX function BIN2OCT function BITAND function [2013] BITLSHIFT [2013] BITOR function [2013] BITRSHIFT [2013] BITXOR function [2013] COMPLEX function CONVERT function DEC2BIN function DEC2HEX function DEC2OCT function DELTA function Financial ACCRINT function ACCRINTM function AMORDEGRC AMORLINC function CUMIPMT function CUMPRINC function DB function DDB function DOLLARFR function EFFECT function FV function IPMT function ISPMT function NOMINAL function PDURATION PMT function PPMT function PRICEMAT function RATE function RRI function SYD function TBILLPRICE TBILLYIELD VDB function XNPV function YIELD function Information CELL function ERROR.TYPE INFO function ISBLANK function ISERR function ISERROR function ISFORMULA [2013] ISLOGICAL ISNA function ISNONTEXT ISNUMBER function ISODD function ISREF function ISTEXT function N function NA function SHEET function SHEETS function TYPE function Logical AND function FALSE function IF function IFERROR function [2007] IFNA function [2013] IFS function [Office 365] NOT function OR function SWITCH function [2016] TRUE function XOR function [2013] Lookup and reference ADDRESS function AREAS function CHOOSE function COLUMN function COLUMNS function FORMULATEXT [2013] HLOOKUP function HYPERLINK INDEX function INDIRECT function LOOKUP function MATCH function OFFSET function ROW function ROWS function TRANSPOSE VLOOKUP function Math and trigonometry ABS function ACOS function ACOSH function ACOT function [2013] ACOTH function [2013] AGGREGATE ASIN function ASINH function ATAN function ATAN2 function ATANH function BASE function CEILING function COMBIN function COMBINA function [2013] COS function COSH function COT function [2013] COTH function [2013] CSC function DECIMAL function [2013] DEGREES function EVEN function EXP function FACT function FACTDOUBLE FLOOR.MATH [2013] FLOOR.PRECISE [2010] GCD function INT function LCM function LN function LOG function LOG10 function MINVERSE function MMULT function MOD function MROUND function MULTINOMIAL MUNIT function [2013] PI function POWER function PRODUCT function QUOTIENT function RADIANS function RAND function RANDBETWEEN ROUNDDOWN ROUNDUP function SEC function SECH function SERIESSUM SIGN function SIN function SINH function SQRT function SUBTOTAL function SUM function SUMIF function SUMIFS function [2007] SUMPRODUCT SUMSQ function SUMX2MY2 function SUMX2PY2 function SUMXMY2 function TAN function TANH function TRUNC function Statistical AVEDEV function AVERAGE function AVERAGEA function AVERAGEIF [2007] AVERAGEIFS [2007] BETA.DIST [2010] BETA.INV function [2010] BINOM.DIST [2010] BINOM.INV [2010] CHISQ.DIST CHISQ.DIST.RT [2010] CHISQ.INV [2010] CHISQ.INV.RT [2010] CHISQ.TEST [2010] CONFIDENCE.NORM [2010] CONFIDENCE.T [2010] CORREL function COUNT function COUNTA function COUNTBLANK COUNTIF function COUNTIFS function [2007] COVARIANCE.P [2010] COVARIANCE.S [2010] EXPON.DIST [2010] F.DIST function [2010] F.DIST.RT [2010] F.TEST function [2010] FORECAST.LINEAR [2016] FREQUENCY GAMMA function [2013] GAMMA.DIST [2010] GEOMEAN function GROWTH function INTERCEPT LARGE function LINEST function LOGEST function LOGNORM.DIST [2010] MAX function MAXIFS function [2016] MEDIAN function MIN function MINA function MINIFS function [2016] MODE.MULT [2010] MODE.SNGL [2010] NORM.DIST [2010] NORM.INV function [2010] PERCENTRANK.EXC [2010] PERCENTRANK.INC [2010] PERMUT function PERMUTATIONA PHI function PROB function QUARTILE.EXC [2010] QUARTILE.INC [2010] RANK.AVG function [2010] RANK.EQ function [2010] SKEW function SLOPE function SMALL function STANDARDIZE STDEV.P function [2010] STDEV.S function [2010] STDEVA function STDEVPA function TREND function TRIMMEAN function VAR.P function [2010] VAR.S function [2010] Text ASC function CHAR function CLEAN function CODE function CONCAT function [Office 365] CONCATENATE EXACT function FIND function FIXED function LEFT function LEN function LOWER function MID function REPT function RIGHT function SEARCH function SUBSTITUTE T function TEXT function TEXTJOIN function [Office 365] TRIM function UNICHAR function [2013] UNICODE function [2013] UPPER function VALUE function Web ENCODEURL [2013] WEBSERVICE [2013]

Additional Info

NETWORKDAYS.INTL [2010]

BITAND function [2013]

BITLSHIFT [2013]

BITOR function [2013]

BITRSHIFT [2013]

BITXOR function [2013]

IFERROR function [2007]

IFNA function [2013]

IFS function [Office 365]

NOT function

OR function

SWITCH function [2016]

Math and trigonometry

ACOTH function [2013]

COMBINA function [2013]

DECIMAL function [2013]

MUNIT function [2013]

SUMIFS function [2007]

BETA.INV function [2010]

CONFIDENCE.NORM [2010]

COUNTIFS function [2007]

COVARIANCE.P [2010]

COVARIANCE.S [2010]

EXPON.DIST [2010]

F.DIST function [2010]

F.DIST.RT [2010]

F.TEST function [2010]

FORECAST.LINEAR [2016]

FREQUENCY

GAMMA function [2013]

MAXIFS function [2016]

MEDIAN function

MIN function

MINA function

MINIFS function [2016]

MODE.MULT [2010]

MODE.SNGL [2010]

NORM.DIST [2010]

NORM.INV function [2010]

PERCENTRANK.EXC [2010]

PERCENTRANK.INC [2010]

RANK.AVG function [2010]

RANK.EQ function [2010]

STDEV.P function [2010]

STDEV.S function [2010]

VAR.P function [2010]

VAR.S function [2010]

CONCAT function [Office 365]

TEXTJOIN function [Office 365]

TRIM function

UNICHAR function [2013]

UNICODE function [2013]

Additional Info
Weekly Blog EMAIL Get a FREE PDF book! Email . . Formula categories Count Dates Extract Index and Match Logic Lookups String manipulation Sum Time Vlookup Welcome! I am Oscar and here to help you out. Feel free to comment and ask Excel questions. Make sure you subscribe to my newsletter so you don't miss new blog articles.

get-digital-help.com

FTEST function