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 · pagina 1 di 3
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 scheda