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 3 di 3
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(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 schedaRANK.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(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(data_y, data_x)
Calculates the square of r, the Pearson product-moment correlation coefficient of a dataset. Learn more
Analisi dati
Apri schedaSKEW(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(value1, value2)
Calculates the skewness of a dataset that represents the entire population. Learn more.
Analisi dati
Apri schedaSLOPE(data_y, data_x)
Calculates the slope of the line resulting from linear regression of a dataset. Learn more
Analisi dati
Apri schedaSMALL(data, n)
Returns the nth smallest element from a data set, where n is user-defined. Learn more
Analisi dati
Apri schedaSTANDARDIZE(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(value1, [value2, ...])
Calculates the standard deviation based on a sample. Learn more
Analisi dati
Apri schedaSTDEV.P(value1, [value2, ...])
See STDEVP
Analisi dati
Apri schedaSTDEV.S(value1, [value2, ...])
See STDEV
Analisi dati
Apri schedaSTDEVA(value1, value2)
Calculates the standard deviation based on a sample, setting text to the value `0`. Learn more
Analisi dati
Apri schedaSTDEVP(value1, value2)
Calculates the standard deviation based on an entire population. Learn more
Analisi dati
Apri schedaSTDEVPA(value1, value2)
Calculates the standard deviation based on an entire population, setting text to the value `0`. Learn more
Analisi dati
Apri schedaSTEYX(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(x, degrees_freedom, cumulative)
Returns the right tailed Student distribution for a value x. Learn more.
Analisi dati
Apri schedaT.DIST.2T(x, degrees_freedom)
Returns the two tailed Student distribution for a value x. Learn more.
Analisi dati
Apri schedaT.DIST.RT(x, degrees_freedom)
Returns the right tailed Student distribution for a value x. Learn more.
Analisi dati
Apri schedaT.INV(probability, degrees_freedom)
Calculates the negative inverse of the one-tailed TDIST function. Learn more
Analisi dati
Apri schedaT.INV.2T(probability, degrees_freedom)
Calculates the inverse of the two-tailed TDIST function. Learn more
Analisi dati
Apri schedaT.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(x, degrees_freedom, tails)
Calculates the probability for Student's t-distribution with a given input (x). Learn more
Analisi dati
Apri schedaTINV(probability, degrees_freedom)
See T.INV.2T
Analisi dati
Apri schedaTRIMMEAN(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(range1, range2, tails, type)
See T.TEST.
Analisi dati
Apri schedaVAR(value1, [value2, ...])
Calculates the variance based on a sample. Learn more
Analisi dati
Apri schedaVAR.P(value1, [value2, ...])
See VARP
Analisi dati
Apri schedaVAR.S(value1, [value2, ...])
See VAR
Analisi dati
Apri schedaVARA(value1, value2)
Calculates an estimate of variance based on a sample, setting text to the value `0`. Learn more
Analisi dati
Apri schedaVARP(value1, value2)
Calculates the variance based on an entire population. Learn more
Analisi dati
Apri schedaVARPA(value1, value2,...)
Calculates the variance based on an entire population, setting text to the value `0`. Learn more
Analisi dati
Apri schedaWEIBULL(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(x, shape, scale, cumulative)
See WEIBULL
Analisi dati
Apri schedaZ.TEST(data, value, [standard_deviation])
Returns the one-tailed P-value of a Z-test with standard distribution. Learn more.
Analisi dati
Apri schedaZTEST(data, value, [standard_deviation])
See Z.TEST.
Analisi dati
Apri scheda