AVEDEV
AVEDEV(value1, [value2, ...])
Calculates the average of the magnitudes of deviations of data from a dataset's mean. Learn more
Apri schedaFunzioni Google Sheets
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.
AVERAGE
AVERAGE(value1, [value2, ...])
Returns the numerical average value in a dataset, ignoring text. Learn more
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.
Apri schedaAVERAGEA
AVERAGEA(value1, [value2, ...])
Returns the numerical average value in a dataset. Learn more
Apri schedaAVERAGEIF
AVERAGEIF(criteria_range, criterion, [average_range])
Returns the average of a range depending on criteria. Learn more
Apri schedaAVERAGEIFS
AVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])
Returns the average of a range depending on multiple criteria. Learn more
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.
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.
Apri schedaBETADIST
BETADIST(value, alpha, beta, lower_bound, upper_bound)
See BETA.DIST.
Apri schedaBETAINV
BETAINV(probability, alpha, beta, lower_bound, upper_bound)
See BETA.INV
Apri schedaBINOM.DIST
BINOM.DIST(num_successes, num_trials, prob_success, cumulative)
See BINOMDIST
Apri schedaBINOM.INV
BINOM.INV(num_trials, prob_success, target_prob)
See CRITBINOM
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
Apri schedaCHIDIST
CHIDIST(x, degrees_freedom)
Calculates the right-tailed chi-squared distribution, often used in hypothesis testing. Learn more
Apri schedaCHIINV
CHIINV(probability, degrees_freedom)
Calculates the inverse of the right-tailed chi-squared distribution. Learn more
Apri schedaCHISQ.DIST
CHISQ.DIST(x, degrees_freedom, cumulative)
Calculates the left-tailed chi-squared distribution, often used in hypothesis testing. Learn more
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
Apri schedaCHISQ.INV
CHISQ.INV(probability, degrees_freedom)
Calculates the inverse of the left-tailed chi-squared distribution. Learn more
Apri schedaCHISQ.INV.RT
CHISQ.INV.RT(probability, degrees_freedom)
Calculates the inverse of the right-tailed chi-squared distribution. Learn more
Apri schedaCHISQ.TEST
CHISQ.TEST(observed_range, expected_range)
See CHITEST
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
Apri schedaCONFIDENCE
CONFIDENCE(alpha, standard_deviation, pop_size)
See CONFIDENCE.NORM
Apri schedaCONFIDENCE.NORM
CONFIDENCE.NORM(alpha, standard_deviation, pop_size)
Calculates the width of half the confidence interval for a normal distribution. Learn more.
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.
Apri schedaCORREL
CORREL(data_y, data_x)
Calculates r, the Pearson product-moment correlation coefficient of a dataset. Learn more
Apri schedaCOUNT
COUNT(value1, [value2, ...])
Returns a count of the number of numeric values in a dataset. Learn more
Apri schedaCOUNTA
COUNTA(value1, [value2, ...])
Returns a count of the number of values in a dataset. Learn more
Apri schedaCOVAR
COVAR(data_y, data_x)
Calculates the covariance of a dataset. Learn more
Apri schedaCOVARIANCE.P
COVARIANCE.P(data_y, data_x)
See COVAR
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.
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
Apri schedaDEVSQ
DEVSQ(value1, value2)
Calculates the sum of squares of deviations based on a sample. Learn more
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.
Apri schedaEXPONDIST
EXPONDIST(x, LAMBDA, cumulative)
See EXPON.DIST
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
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
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
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
Apri schedaF.TEST
F.TEST(range1, range2)
See FTEST.
Apri schedaFDIST
FDIST(x, degrees_freedom1, degrees_freedom2)
See F.DIST.RT.
Apri schedaFINV
FINV(probability, degrees_freedom1, degrees_freedom2)
See F.INV.RT
Apri schedaFISHER
FISHER(value)
Returns the Fisher transformation of a specified value. Learn more
Apri schedaFISHERINV
FISHERINV(value)
Returns the inverse Fisher transformation of a specified value. Learn more
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
Apri schedaFORECAST.LINEAR
FORECAST.LINEAR(x, data_y, data_x)
See FORECAST
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
Apri schedaGAMMA
GAMMA(number)
Returns the Gamma function evaluated at the specified value. Learn more.
Apri schedaGAMMA.DIST
GAMMA.DIST(x, alpha, beta, cumulative)
Calculates the gamma distribution, a two-parameter continuous probability distribution. Learn more
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.
Apri schedaGAMMADIST
GAMMADIST(x, alpha, beta, cumulative)
See GAMMA.DIST
Apri schedaGAMMAINV
GAMMAINV(probability, alpha, beta)
See GAMMA.INV.
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.
Apri schedaGEOMEAN
GEOMEAN(value1, value2)
Calculates the geometric mean of a dataset. Learn more
Apri schedaHARMEAN
HARMEAN(value1, value2)
Calculates the harmonic mean of a dataset. Learn more
Apri schedaHYPGEOM.DIST
HYPGEOM.DIST(num_successes, num_draws, successes_in_pop, pop_size)
See HYPGEOMDIST
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
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
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
Apri schedaLARGE
LARGE(data, n)
Returns the nth largest element from a data set, where n is user-defined. Learn more
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
Apri schedaLOGNORM.DIST
LOGNORM.DIST(x, mean, standard_deviation)
See LOGNORMDIST
Apri schedaLOGNORM.INV
LOGNORM.INV(x, mean, standard_deviation)
See LOGINV
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
Apri schedaMARGINOFERROR
MARGINOFERROR(range, confidence)
Calculates the amount of random sampling error given a range of values and a confidence level. Learn more
Apri schedaMAX
MAX(value1, [value2, ...])
Returns the maximum value in a numeric dataset. Learn more
Apri schedaMAXA
MAXA(value1, value2)
Returns the maximum numeric value in a dataset. Learn more
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.
Apri schedaMEDIAN
MEDIAN(value1, [value2, ...])
Returns the median value in a numeric dataset. Learn more
Apri schedaMIN
MIN(value1, [value2, ...])
Returns the minimum value in a numeric dataset. Learn more
Apri schedaMINA
MINA(value1, value2)
Returns the minimum numeric value in a dataset. Learn more
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.
Apri schedaMODE
MODE(value1, [value2, ...])
Returns the most commonly occurring value in a dataset. Learn more
Apri schedaMODE.MULT
MODE.MULT(value1, value2)
Returns the most commonly occurring values in a dataset. Learn more.
Apri schedaMODE.SNGL
MODE.SNGL(value1, [value2, ...])
See MODE
Apri schedaNEGBINOM.DIST
NEGBINOM.DIST(num_failures, num_successes, prob_success)
See NEGBINOMDIST
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
Apri schedaNORM.DIST
NORM.DIST(x, mean, standard_deviation, cumulative)
See NORMDIST
Apri schedaNORM.INV
NORM.INV(x, mean, standard_deviation)
See NORMINV
Apri schedaNORM.S.DIST
NORM.S.DIST(x)
See NORMSDIST
Apri schedaNORM.S.INV
NORM.S.INV(x)
See NORMSINV
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
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
Apri schedaNORMSDIST
NORMSDIST(x)
Returns the value of the standard normal cumulative distribution function for a specified value. Learn more
Apri schedaNORMSINV
NORMSINV(x)
Returns the value of the inverse standard normal distribution function for a specified value. Learn more
Apri schedaPEARSON
PEARSON(data_y, data_x)
Calculates r, the Pearson product-moment correlation coefficient of a dataset. Learn more
Apri schedaPERCENTILE
PERCENTILE(data, percentile)
Returns the value at a given percentile of a dataset. Learn more
Apri schedaPERCENTILE.EXC
PERCENTILE.EXC(data, percentile)
Returns the value at a given percentile of a dataset, exclusive of 0 and 1. Learn more.
Apri schedaPERCENTILE.INC
PERCENTILE.INC(data, percentile)
See PERCENTILE
Apri schedaPERCENTRANK
PERCENTRANK(data, value, [significant_digits])
Returns the percentage rank (percentile) of a specified value in a dataset. Learn more
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
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
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
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.
Apri schedaPHI
PHI(x)
The PHI function returns the value of the normal distribution with mean 0 and standard deviation 1. Learn more.
Apri schedaPOISSON
POISSON(x, mean, cumulative)
See POISSON.DIST
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.
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
Apri schedaQUARTILE
QUARTILE(data, quartile_number)
Returns a value nearest to a specified quartile of a dataset. Learn more
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.
Apri schedaQUARTILE.INC
QUARTILE.INC(data, quartile_number)
See QUARTILE
Apri schedaRANK
RANK(value, data, [is_ascending])
Returns the rank of a specified value in a dataset. Learn more
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
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
Apri schedaRSQ
RSQ(data_y, data_x)
Calculates the square of r, the Pearson product-moment correlation coefficient of a dataset. Learn more
Apri schedaSKEW
SKEW(value1, value2)
Calculates the skewness of a dataset, which describes the symmetry of that dataset about the mean. Learn more
Apri schedaSKEW.P
SKEW.P(value1, value2)
Calculates the skewness of a dataset that represents the entire population. Learn more.
Apri schedaSLOPE
SLOPE(data_y, data_x)
Calculates the slope of the line resulting from linear regression of a dataset. Learn more
Apri schedaSMALL
SMALL(data, n)
Returns the nth smallest element from a data set, where n is user-defined. Learn more
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
Apri schedaSTDEV
STDEV(value1, [value2, ...])
Calculates the standard deviation based on a sample. Learn more
Apri schedaSTDEV.P
STDEV.P(value1, [value2, ...])
See STDEVP
Apri schedaSTDEV.S
STDEV.S(value1, [value2, ...])
See STDEV
Apri schedaSTDEVA
STDEVA(value1, value2)
Calculates the standard deviation based on a sample, setting text to the value `0`. Learn more
Apri schedaSTDEVP
STDEVP(value1, value2)
Calculates the standard deviation based on an entire population. Learn more
Apri schedaSTDEVPA
STDEVPA(value1, value2)
Calculates the standard deviation based on an entire population, setting text to the value `0`. Learn more
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
Apri schedaT.DIST
T.DIST(x, degrees_freedom, cumulative)
Returns the right tailed Student distribution for a value x. Learn more.
Apri schedaT.DIST.2T
T.DIST.2T(x, degrees_freedom)
Returns the two tailed Student distribution for a value x. Learn more.
Apri schedaT.DIST.RT
T.DIST.RT(x, degrees_freedom)
Returns the right tailed Student distribution for a value x. Learn more.
Apri schedaT.INV
T.INV(probability, degrees_freedom)
Calculates the negative inverse of the one-tailed TDIST function. Learn more
Apri schedaT.INV.2T
T.INV.2T(probability, degrees_freedom)
Calculates the inverse of the two-tailed TDIST function. Learn more
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.
Apri schedaTDIST
TDIST(x, degrees_freedom, tails)
Calculates the probability for Student's t-distribution with a given input (x). Learn more
Apri schedaTINV
TINV(probability, degrees_freedom)
See T.INV.2T
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
Apri schedaTTEST
TTEST(range1, range2, tails, type)
See T.TEST.
Apri schedaVAR
VAR(value1, [value2, ...])
Calculates the variance based on a sample. Learn more
Apri schedaVAR.P
VAR.P(value1, [value2, ...])
See VARP
Apri schedaVAR.S
VAR.S(value1, [value2, ...])
See VAR
Apri schedaVARA
VARA(value1, value2)
Calculates an estimate of variance based on a sample, setting text to the value `0`. Learn more
Apri schedaVARP
VARP(value1, value2)
Calculates the variance based on an entire population. Learn more
Apri schedaVARPA
VARPA(value1, value2,...)
Calculates the variance based on an entire population, setting text to the value `0`. Learn more
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
Apri schedaWEIBULL.DIST
WEIBULL.DIST(x, shape, scale, cumulative)
See WEIBULL
Apri schedaZ.TEST
Z.TEST(data, value, [standard_deviation])
Returns the one-tailed P-value of a Z-test with standard distribution. Learn more.
Apri schedaZTEST
ZTEST(data, value, [standard_deviation])
See Z.TEST.
Apri scheda