Una scheda strutturata per ogni funzione: sintassi, argomenti, esempi pratici, errori comuni, FAQ e collegamenti a formule correlate.
Digita almeno 2 lettere per vedere i suggerimenti.
369 formule trovate · pagina 6 di 8
F.DIST(x, degrees_freedom1, degrees_freedom2, cumulative)
Calculates the left-tailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately called Fisher-Snedecor distribution or Snedecor's F distribution. Learn more
Analisi dati
Apri schedaF.DIST.RT(x, degrees_freedom1, degrees_freedom2)
Calculates the right-tailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately called Fisher-Snedecor distribution or Snedecor's F distribution. Learn more
Analisi dati
Apri schedaF.INV(probability, degrees_freedom1, degrees_freedom2)
Calculates the inverse of the left-tailed F probability distribution. Also called the Fisher-Snedecor distribution or Snedecor’s F distribution. Learn more
Analisi dati
Apri schedaF.INV.RT(probability, degrees_freedom1, degrees_freedom2)
Calculates the inverse of the right-tailed F probability distribution. Also called the Fisher-Snedecor distribution or Snedecor’s F distribution. Learn more
Analisi dati
Apri schedaF.TEST(range1, range2)
See FTEST.
Analisi dati
Apri schedaFDIST(x, degrees_freedom1, degrees_freedom2)
See F.DIST.RT.
Analisi dati
Apri schedaFINV(probability, degrees_freedom1, degrees_freedom2)
See F.INV.RT
Analisi dati
Apri schedaFISHER(value)
Returns the Fisher transformation of a specified value. Learn more
Analisi dati
Apri schedaFISHERINV(value)
Returns the inverse Fisher transformation of a specified value. Learn more
Analisi dati
Apri schedaFORECAST(x, data_y, data_x)
Calculates the expected y-value for a specified x based on a linear regression of a dataset. Learn more
Analisi dati
Apri schedaFORECAST.LINEAR(x, data_y, data_x)
See FORECAST
Analisi dati
Apri schedaFTEST(range1, range2)
Returns the probability associated with an F-test for equality of variances. Determines whether two samples are likely to have come from populations with the same variance. Learn more
Analisi dati
Apri schedaGAMMA(number)
Returns the Gamma function evaluated at the specified value. Learn more.
Analisi dati
Apri schedaGAMMA.DIST(x, alpha, beta, cumulative)
Calculates the gamma distribution, a two-parameter continuous probability distribution. Learn more
Analisi dati
Apri schedaGAMMA.INV(probability, alpha, beta)
The GAMMA.INV function returns the value of the inverse gamma cumulative distribution function for the specified probability and alpha and beta parameters. Learn more.
Analisi dati
Apri schedaGAMMADIST(x, alpha, beta, cumulative)
See GAMMA.DIST
Analisi dati
Apri schedaGAMMAINV(probability, alpha, beta)
See GAMMA.INV.
Analisi dati
Apri schedaGAUSS(z)
The GAUSS function returns the probability that a random variable, drawn from a normal distribution, will be between the mean and z standard deviations above (or below) the mean. Learn more.
Analisi dati
Apri schedaGEOMEAN(value1, value2)
Calculates the geometric mean of a dataset. Learn more
Analisi dati
Apri schedaHARMEAN(value1, value2)
Calculates the harmonic mean of a dataset. Learn more
Analisi dati
Apri schedaHYPGEOM.DIST(num_successes, num_draws, successes_in_pop, pop_size)
See HYPGEOMDIST
Analisi dati
Apri schedaHYPGEOMDIST(num_successes, num_draws, successes_in_pop, pop_size)
Calculates the probability of drawing a certain number of successes in a certain number of tries given a population of a certain size containing a certain number of successes, without replacement of draws. Learn more
Analisi dati
Apri schedaINTERCEPT(data_y, data_x)
Calculates the y-value at which the line resulting from linear regression of a dataset will intersect the y-axis (x=0). Learn more
Analisi dati
Apri schedaKURT(value1, value2)
Calculates the kurtosis of a dataset, which describes the shape, and in particular the "peakedness" of that dataset. Learn more
Analisi dati
Apri schedaLARGE(data, n)
Returns the nth largest element from a data set, where n is user-defined. Learn more
Analisi dati
Apri schedaLOGINV(x, mean, standard_deviation)
Returns the value of the inverse log-normal cumulative distribution with given mean and standard deviation at a specified value. Learn more
Analisi dati
Apri schedaLOGNORM.DIST(x, mean, standard_deviation)
See LOGNORMDIST
Analisi dati
Apri schedaLOGNORM.INV(x, mean, standard_deviation)
See LOGINV
Analisi dati
Apri schedaLOGNORMDIST(x, mean, standard_deviation)
Returns the value of the log-normal cumulative distribution with given mean and standard deviation at a specified value. Learn more
Analisi dati
Apri schedaMARGINOFERROR(range, confidence)
Calculates the amount of random sampling error given a range of values and a confidence level. Learn more
Analisi dati
Apri schedaMAXA(value1, value2)
Returns the maximum numeric value in a dataset. Learn more
Analisi dati
Apri schedaMAXIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], …)
Returns the maximum value in a range of cells, filtered by a set of criteria. Learn more.
Analisi dati
Apri schedaMEDIAN(value1, [value2, ...])
Returns the median value in a numeric dataset. Learn more
Analisi dati
Apri schedaMINA(value1, value2)
Returns the minimum numeric value in a dataset. Learn more
Analisi dati
Apri schedaMINIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], …)
Returns the minimum value in a range of cells, filtered by a set of criteria. Learn more.
Analisi dati
Apri schedaMODE(value1, [value2, ...])
Returns the most commonly occurring value in a dataset. Learn more
Analisi dati
Apri schedaMODE.MULT(value1, value2)
Returns the most commonly occurring values in a dataset. Learn more.
Analisi dati
Apri schedaMODE.SNGL(value1, [value2, ...])
See MODE
Analisi dati
Apri schedaNEGBINOM.DIST(num_failures, num_successes, prob_success)
See NEGBINOMDIST
Analisi dati
Apri schedaNEGBINOMDIST(num_failures, num_successes, prob_success)
Calculates the probability of drawing a certain number of failures before a certain number of successes given a probability of success in independent trials. Learn more
Analisi dati
Apri schedaNORM.DIST(x, mean, standard_deviation, cumulative)
See NORMDIST
Analisi dati
Apri schedaNORM.INV(x, mean, standard_deviation)
See NORMINV
Analisi dati
Apri schedaNORM.S.DIST(x)
See NORMSDIST
Analisi dati
Apri schedaNORM.S.INV(x)
See NORMSINV
Analisi dati
Apri schedaNORMDIST(x, mean, standard_deviation, cumulative)
Returns the value of the normal distribution function (or normal cumulative distribution function) for a specified value, mean, and standard deviation. Learn more
Analisi dati
Apri schedaNORMINV(x, mean, standard_deviation)
Returns the value of the inverse normal distribution function for a specified value, mean, and standard deviation. Learn more
Analisi dati
Apri schedaNORMSDIST(x)
Returns the value of the standard normal cumulative distribution function for a specified value. Learn more
Analisi dati
Apri schedaNORMSINV(x)
Returns the value of the inverse standard normal distribution function for a specified value. Learn more
Analisi dati
Apri scheda