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.
136 formule trovate · pagina 2 di 3
GAMMA.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 schedaMAX(value1, [value2, ...])
Returns the maximum value in a numeric dataset. 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 schedaMIN(value1, [value2, ...])
Returns the minimum 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 schedaPEARSON(data_y, data_x)
Calculates r, the Pearson product-moment correlation coefficient of a dataset. Learn more
Analisi dati
Apri schedaPERCENTILE(data, percentile)
Returns the value at a given percentile of a dataset. Learn more
Analisi dati
Apri schedaPERCENTILE.EXC(data, percentile)
Returns the value at a given percentile of a dataset, exclusive of 0 and 1. Learn more.
Analisi dati
Apri schedaPERCENTILE.INC(data, percentile)
See PERCENTILE
Analisi dati
Apri schedaPERCENTRANK(data, value, [significant_digits])
Returns the percentage rank (percentile) of a specified value in a dataset. Learn more
Analisi dati
Apri schedaPERCENTRANK.EXC(data, value, [significant_digits])
Returns the percentage rank (percentile) from 0 to 1 exclusive of a specified value in a dataset. Learn more
Analisi dati
Apri schedaPERCENTRANK.INC(data, value, [significant_digits])
Returns the percentage rank (percentile) from 0 to 1 inclusive of a specified value in a dataset. Learn more
Analisi dati
Apri schedaPERMUT(n, k)
Returns the number of ways to choose some number of objects from a pool of a given size of objects, considering order. Learn more
Analisi dati
Apri schedaPERMUTATIONA(number, number_chosen)
Returns the number of permutations for selecting a group of objects (with replacement) from a total number of objects. Learn more.
Analisi dati
Apri schedaPHI(x)
The PHI function returns the value of the normal distribution with mean 0 and standard deviation 1. Learn more.
Analisi dati
Apri schedaPOISSON(x, mean, cumulative)
See POISSON.DIST
Analisi dati
Apri schedaPOISSON.DIST(x, mean, [cumulative])
Returns the value of the Poisson distribution function (or Poisson cumulative distribution function) for a specified value and mean. Learn more.
Analisi dati
Apri scheda