AVEDEV
AVEDEV(value1, [value2, ...])
Calculates the average of the magnitudes of deviations of data from a dataset's mean. Learn more
Analisi dati
Apri schedaFormula reference avanzata
Cerca per funzione o sintassi, filtra i casi d’uso e passa direttamente agli strumenti operativi senza onboarding.
Digita almeno 2 lettere per vedere i suggerimenti.
136 formule trovate
Non sai da dove partire?
Percorsi per livello e use case
Base
Intermedio
Avanzato
Use case
Sfida del giorno
AVERAGE
AVERAGE(value1, [value2, ...])
Returns the numerical average value in a dataset, ignoring text. Learn more
Analisi dati
Apri schedaAVERAGE.WEIGHTED
AVERAGE.WEIGHTED(values, weights, [additional values], [additional weights])
Finds the weighted average of a set of values, given the values and the corresponding weights. Learn more.
Analisi dati
Apri schedaAVERAGEA
AVERAGEA(value1, [value2, ...])
Returns the numerical average value in a dataset. Learn more
Analisi dati
Apri schedaAVERAGEIF
AVERAGEIF(criteria_range, criterion, [average_range])
Returns the average of a range depending on criteria. Learn more
Analisi dati
Apri schedaAVERAGEIFS
AVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])
Returns the average of a range depending on multiple criteria. Learn more
Analisi dati
Apri schedaBETA.DIST
BETA.DIST(value, alpha, beta, cumulative, lower_bound, upper_bound)
Returns the probability of a given value as defined by the beta distribution function. Learn more.
Analisi dati
Apri schedaBETA.INV
BETA.INV(probability, alpha, beta, lower_bound, upper_bound)
Returns the value of the inverse beta distribution function for a given probability. Learn more.
Analisi dati
Apri schedaBETADIST
BETADIST(value, alpha, beta, lower_bound, upper_bound)
See BETA.DIST.
Analisi dati
Apri schedaBETAINV
BETAINV(probability, alpha, beta, lower_bound, upper_bound)
See BETA.INV
Analisi dati
Apri schedaBINOM.DIST
BINOM.DIST(num_successes, num_trials, prob_success, cumulative)
See BINOMDIST
Analisi dati
Apri schedaBINOM.INV
BINOM.INV(num_trials, prob_success, target_prob)
See CRITBINOM
Analisi dati
Apri schedaBINOMDIST
BINOMDIST(num_successes, num_trials, prob_success, cumulative)
Calculates the probability of drawing a certain number of successes (or a maximum number of successes) in a certain number of tries given a population of a certain size containing a certain number of successes, with replacement of draws. Learn more
Analisi dati
Apri schedaCHIDIST
CHIDIST(x, degrees_freedom)
Calculates the right-tailed chi-squared distribution, often used in hypothesis testing. Learn more
Analisi dati
Apri schedaCHIINV
CHIINV(probability, degrees_freedom)
Calculates the inverse of the right-tailed chi-squared distribution. Learn more
Analisi dati
Apri schedaCHISQ.DIST
CHISQ.DIST(x, degrees_freedom, cumulative)
Calculates the left-tailed chi-squared distribution, often used in hypothesis testing. Learn more
Analisi dati
Apri schedaCHISQ.DIST.RT
CHISQ.DIST.RT(x, degrees_freedom)
Calculates the right-tailed chi-squared distribution, which is commonly used in hypothesis testing. Learn more
Analisi dati
Apri schedaCHISQ.INV
CHISQ.INV(probability, degrees_freedom)
Calculates the inverse of the left-tailed chi-squared distribution. Learn more
Analisi dati
Apri schedaCHISQ.INV.RT
CHISQ.INV.RT(probability, degrees_freedom)
Calculates the inverse of the right-tailed chi-squared distribution. Learn more
Analisi dati
Apri schedaCHISQ.TEST
CHISQ.TEST(observed_range, expected_range)
See CHITEST
Analisi dati
Apri schedaCHITEST
CHITEST(observed_range, expected_range)
Returns the probability associated with a Pearson’s chi-squared test on the two ranges of data. Determines the likelihood that the observed categorical data is drawn from an expected distribution. Learn more
Analisi dati
Apri schedaCONFIDENCE
CONFIDENCE(alpha, standard_deviation, pop_size)
See CONFIDENCE.NORM
Analisi dati
Apri schedaCONFIDENCE.NORM
CONFIDENCE.NORM(alpha, standard_deviation, pop_size)
Calculates the width of half the confidence interval for a normal distribution. Learn more.
Analisi dati
Apri schedaCONFIDENCE.T
CONFIDENCE.T(alpha, standard_deviation, size)
Calculates the width of half the confidence interval for a Student’s t-distribution. Learn more.
Analisi dati
Apri schedaCORREL
CORREL(data_y, data_x)
Calculates r, the Pearson product-moment correlation coefficient of a dataset. Learn more
Analisi dati
Apri schedaCOUNT
COUNT(value1, [value2, ...])
Returns a count of the number of numeric values in a dataset. Learn more
Analisi dati
Apri schedaCOUNTA
COUNTA(value1, [value2, ...])
Returns a count of the number of values in a dataset. Learn more
Analisi dati
Apri schedaCOVAR
COVAR(data_y, data_x)
Calculates the covariance of a dataset. Learn more
Analisi dati
Apri schedaCOVARIANCE.P
COVARIANCE.P(data_y, data_x)
See COVAR
Analisi dati
Apri schedaCOVARIANCE.S
COVARIANCE.S(data_y, data_x)
Calculates the covariance of a dataset, where the dataset is a sample of the total population. Learn more.
Analisi dati
Apri schedaCRITBINOM
CRITBINOM(num_trials, prob_success, target_prob)
Calculates the smallest value for which the cumulative binomial distribution is greater than or equal to a specified criteria. Learn more
Analisi dati
Apri schedaDEVSQ
DEVSQ(value1, value2)
Calculates the sum of squares of deviations based on a sample. Learn more
Analisi dati
Apri schedaEXPON.DIST
EXPON.DIST(x, LAMBDA, cumulative)
Returns the value of the exponential distribution function with a specified LAMBDA at a specified value. Learn more.
Analisi dati
Apri schedaEXPONDIST
EXPONDIST(x, LAMBDA, cumulative)
See EXPON.DIST
Analisi dati
Apri schedaF.DIST
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
F.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
F.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
F.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
F.TEST(range1, range2)
See FTEST.
Analisi dati
Apri schedaFDIST
FDIST(x, degrees_freedom1, degrees_freedom2)
See F.DIST.RT.
Analisi dati
Apri schedaFINV
FINV(probability, degrees_freedom1, degrees_freedom2)
See F.INV.RT
Analisi dati
Apri schedaFISHER
FISHER(value)
Returns the Fisher transformation of a specified value. Learn more
Analisi dati
Apri schedaFISHERINV
FISHERINV(value)
Returns the inverse Fisher transformation of a specified value. Learn more
Analisi dati
Apri schedaFORECAST
FORECAST(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
FORECAST.LINEAR(x, data_y, data_x)
See FORECAST
Analisi dati
Apri schedaFTEST
FTEST(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
GAMMA(number)
Returns the Gamma function evaluated at the specified value. Learn more.
Analisi dati
Apri schedaGAMMA.DIST
GAMMA.DIST(x, alpha, beta, cumulative)
Calculates the gamma distribution, a two-parameter continuous probability distribution. Learn more
Analisi dati
Apri schedaGAMMA.INV
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
GAMMADIST(x, alpha, beta, cumulative)
See GAMMA.DIST
Analisi dati
Apri schedaGAMMAINV
GAMMAINV(probability, alpha, beta)
See GAMMA.INV.
Analisi dati
Apri schedaGAUSS
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
GEOMEAN(value1, value2)
Calculates the geometric mean of a dataset. Learn more
Analisi dati
Apri schedaHARMEAN
HARMEAN(value1, value2)
Calculates the harmonic mean of a dataset. Learn more
Analisi dati
Apri schedaHYPGEOM.DIST
HYPGEOM.DIST(num_successes, num_draws, successes_in_pop, pop_size)
See HYPGEOMDIST
Analisi dati
Apri schedaHYPGEOMDIST
HYPGEOMDIST(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
INTERCEPT(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
KURT(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
LARGE(data, n)
Returns the nth largest element from a data set, where n is user-defined. Learn more
Analisi dati
Apri schedaLOGINV
LOGINV(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
LOGNORM.DIST(x, mean, standard_deviation)
See LOGNORMDIST
Analisi dati
Apri schedaLOGNORM.INV
LOGNORM.INV(x, mean, standard_deviation)
See LOGINV
Analisi dati
Apri schedaLOGNORMDIST
LOGNORMDIST(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
MARGINOFERROR(range, confidence)
Calculates the amount of random sampling error given a range of values and a confidence level. Learn more
Analisi dati
Apri schedaMAX
MAX(value1, [value2, ...])
Returns the maximum value in a numeric dataset. Learn more
Analisi dati
Apri schedaMAXA
MAXA(value1, value2)
Returns the maximum numeric value in a dataset. Learn more
Analisi dati
Apri schedaMAXIFS
MAXIFS(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
MEDIAN(value1, [value2, ...])
Returns the median value in a numeric dataset. Learn more
Analisi dati
Apri schedaMIN
MIN(value1, [value2, ...])
Returns the minimum value in a numeric dataset. Learn more
Analisi dati
Apri schedaMINA
MINA(value1, value2)
Returns the minimum numeric value in a dataset. Learn more
Analisi dati
Apri schedaMINIFS
MINIFS(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
MODE(value1, [value2, ...])
Returns the most commonly occurring value in a dataset. Learn more
Analisi dati
Apri schedaMODE.MULT
MODE.MULT(value1, value2)
Returns the most commonly occurring values in a dataset. Learn more.
Analisi dati
Apri schedaMODE.SNGL
MODE.SNGL(value1, [value2, ...])
See MODE
Analisi dati
Apri schedaNEGBINOM.DIST
NEGBINOM.DIST(num_failures, num_successes, prob_success)
See NEGBINOMDIST
Analisi dati
Apri schedaNEGBINOMDIST
NEGBINOMDIST(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
NORM.DIST(x, mean, standard_deviation, cumulative)
See NORMDIST
Analisi dati
Apri schedaNORM.INV
NORM.INV(x, mean, standard_deviation)
See NORMINV
Analisi dati
Apri schedaNORM.S.DIST
NORM.S.DIST(x)
See NORMSDIST
Analisi dati
Apri schedaNORM.S.INV
NORM.S.INV(x)
See NORMSINV
Analisi dati
Apri schedaNORMDIST
NORMDIST(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
NORMINV(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
NORMSDIST(x)
Returns the value of the standard normal cumulative distribution function for a specified value. Learn more
Analisi dati
Apri schedaNORMSINV
NORMSINV(x)
Returns the value of the inverse standard normal distribution function for a specified value. Learn more
Analisi dati
Apri schedaPEARSON
PEARSON(data_y, data_x)
Calculates r, the Pearson product-moment correlation coefficient of a dataset. Learn more
Analisi dati
Apri schedaPERCENTILE
PERCENTILE(data, percentile)
Returns the value at a given percentile of a dataset. Learn more
Analisi dati
Apri schedaPERCENTILE.EXC
PERCENTILE.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
PERCENTILE.INC(data, percentile)
See PERCENTILE
Analisi dati
Apri schedaPERCENTRANK
PERCENTRANK(data, value, [significant_digits])
Returns the percentage rank (percentile) of a specified value in a dataset. Learn more
Analisi dati
Apri schedaPERCENTRANK.EXC
PERCENTRANK.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
PERCENTRANK.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
PERMUT(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
PERMUTATIONA(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
PHI(x)
The PHI function returns the value of the normal distribution with mean 0 and standard deviation 1. Learn more.
Analisi dati
Apri schedaPOISSON
POISSON(x, mean, cumulative)
See POISSON.DIST
Analisi dati
Apri schedaPOISSON.DIST
POISSON.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
PROB(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
QUARTILE(data, quartile_number)
Returns a value nearest to a specified quartile of a dataset. Learn more
Analisi dati
Apri schedaQUARTILE.EXC
QUARTILE.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
QUARTILE.INC(data, quartile_number)
See QUARTILE
Analisi dati
Apri schedaRANK
RANK(value, data, [is_ascending])
Returns the rank of a specified value in a dataset. Learn more
Analisi dati
Apri schedaRANK.AVG
RANK.AVG(value, data, [is_ascending])
Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the average rank of the entries will be returned. Learn more
Analisi dati
Apri schedaRANK.EQ
RANK.EQ(value, data, [is_ascending])
Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the top rank of the entries will be returned. Learn more
Analisi dati
Apri schedaRSQ
RSQ(data_y, data_x)
Calculates the square of r, the Pearson product-moment correlation coefficient of a dataset. Learn more
Analisi dati
Apri schedaSKEW
SKEW(value1, value2)
Calculates the skewness of a dataset, which describes the symmetry of that dataset about the mean. Learn more
Analisi dati
Apri schedaSKEW.P
SKEW.P(value1, value2)
Calculates the skewness of a dataset that represents the entire population. Learn more.
Analisi dati
Apri schedaSLOPE
SLOPE(data_y, data_x)
Calculates the slope of the line resulting from linear regression of a dataset. Learn more
Analisi dati
Apri schedaSMALL
SMALL(data, n)
Returns the nth smallest element from a data set, where n is user-defined. Learn more
Analisi dati
Apri schedaSTANDARDIZE
STANDARDIZE(value, mean, standard_deviation)
Calculates the normalized equivalent of a random variable given mean and standard deviation of the distribution. Learn more
Analisi dati
Apri schedaSTDEV
STDEV(value1, [value2, ...])
Calculates the standard deviation based on a sample. Learn more
Analisi dati
Apri schedaSTDEV.P
STDEV.P(value1, [value2, ...])
See STDEVP
Analisi dati
Apri schedaSTDEV.S
STDEV.S(value1, [value2, ...])
See STDEV
Analisi dati
Apri schedaSTDEVA
STDEVA(value1, value2)
Calculates the standard deviation based on a sample, setting text to the value `0`. Learn more
Analisi dati
Apri schedaSTDEVP
STDEVP(value1, value2)
Calculates the standard deviation based on an entire population. Learn more
Analisi dati
Apri schedaSTDEVPA
STDEVPA(value1, value2)
Calculates the standard deviation based on an entire population, setting text to the value `0`. Learn more
Analisi dati
Apri schedaSTEYX
STEYX(data_y, data_x)
Calculates the standard error of the predicted y-value for each x in the regression of a dataset. Learn more
Analisi dati
Apri schedaT.DIST
T.DIST(x, degrees_freedom, cumulative)
Returns the right tailed Student distribution for a value x. Learn more.
Analisi dati
Apri schedaT.DIST.2T
T.DIST.2T(x, degrees_freedom)
Returns the two tailed Student distribution for a value x. Learn more.
Analisi dati
Apri schedaT.DIST.RT
T.DIST.RT(x, degrees_freedom)
Returns the right tailed Student distribution for a value x. Learn more.
Analisi dati
Apri schedaT.INV
T.INV(probability, degrees_freedom)
Calculates the negative inverse of the one-tailed TDIST function. Learn more
Analisi dati
Apri schedaT.INV.2T
T.INV.2T(probability, degrees_freedom)
Calculates the inverse of the two-tailed TDIST function. Learn more
Analisi dati
Apri schedaT.TEST
T.TEST(range1, range2, tails, type)
Returns the probability associated with Student's t-test. Determines whether two samples are likely to have come from the same two underlying populations that have the same mean. Learn more.
Analisi dati
Apri schedaTDIST
TDIST(x, degrees_freedom, tails)
Calculates the probability for Student's t-distribution with a given input (x). Learn more
Analisi dati
Apri schedaTINV
TINV(probability, degrees_freedom)
See T.INV.2T
Analisi dati
Apri schedaTRIMMEAN
TRIMMEAN(data, exclude_proportion)
Calculates the mean of a dataset excluding some proportion of data from the high and low ends of the dataset. Learn more
Analisi dati
Apri schedaTTEST
TTEST(range1, range2, tails, type)
See T.TEST.
Analisi dati
Apri schedaVAR
VAR(value1, [value2, ...])
Calculates the variance based on a sample. Learn more
Analisi dati
Apri schedaVAR.P
VAR.P(value1, [value2, ...])
See VARP
Analisi dati
Apri schedaVAR.S
VAR.S(value1, [value2, ...])
See VAR
Analisi dati
Apri schedaVARA
VARA(value1, value2)
Calculates an estimate of variance based on a sample, setting text to the value `0`. Learn more
Analisi dati
Apri schedaVARP
VARP(value1, value2)
Calculates the variance based on an entire population. Learn more
Analisi dati
Apri schedaVARPA
VARPA(value1, value2,...)
Calculates the variance based on an entire population, setting text to the value `0`. Learn more
Analisi dati
Apri schedaWEIBULL
WEIBULL(x, shape, scale, cumulative)
Returns the value of the Weibull distribution function (or Weibull cumulative distribution function) for a specified shape and scale. Learn more
Analisi dati
Apri schedaWEIBULL.DIST
WEIBULL.DIST(x, shape, scale, cumulative)
See WEIBULL
Analisi dati
Apri schedaZ.TEST
Z.TEST(data, value, [standard_deviation])
Returns the one-tailed P-value of a Z-test with standard distribution. Learn more.
Analisi dati
Apri schedaZTEST
ZTEST(data, value, [standard_deviation])
See Z.TEST.
Analisi dati
Apri scheda