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.
131 formule trovate · pagina 2 di 3
GAUSS(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 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 schedaPROB(data, probabilities, low_limit, [high_limit])
Given a set of values and corresponding probabilities, calculates the probability that a value chosen at random falls between two limits. Learn more
Analisi dati
Apri schedaQUARTILE(data, quartile_number)
Returns a value nearest to a specified quartile of a dataset. Learn more
Analisi dati
Apri schedaQUARTILE.EXC(data, quartile_number)
Returns value nearest to a given quartile of a dataset, exclusive of 0 and 4. Learn more.
Analisi dati
Apri schedaQUARTILE.INC(data, quartile_number)
See QUARTILE
Analisi dati
Apri schedaRANK(value, data, [is_ascending])
Returns the rank of a specified value in a dataset. Learn more
Analisi dati
Apri scheda