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.
515 formule trovate · pagina 10 di 11
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(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 schedaARABIC(roman_numeral)
Computes the value of a Roman numeral. Learn more
Marketing
Apri schedaASC(text)
Converts full-width ASCII and katakana characters to their half-width counterparts. All standard-width characters will remain unchanged. Learn more.
Marketing
Apri schedaCHAR(table_number)
Convert a number into a character according to the current Unicode table. Learn more
Marketing
Apri schedaCLEAN(text)
Returns the text with the non-printable ASCII characters removed. Learn more
Marketing
Apri schedaCODE(string)
Returns the numeric Unicode map value of the first character in the string provided. Learn more
Marketing
Apri schedaCONCATENATE(string1, [string2, ...])
Appends strings to one another. Learn more
Marketing
Apri schedaDOLLAR(number, [number_of_places])
Formats a number into the locale-specific currency format. Learn more
Marketing
Apri schedaEXACT(string1, string2)
Tests whether two strings are identical. Learn more
Marketing
Apri schedaFIND(search_for, text_to_search, [starting_at])
Returns the position at which a string is first found within text. Learn more
Marketing
Apri schedaFINDB(search_for, text_to_search, [starting_at])
Returns the position at which a string is first found within text counting each double-character as 2. Learn more
Marketing
Apri schedaFIXED(number, [number_of_places], [suppress_separator])
Formats a number with a fixed number of decimal places. Learn more
Marketing
Apri schedaJOIN(delimiter, value_or_array1, [value_or_array2, ...])
Concatenates the elements of one or more one-dimensional arrays using a specified delimiter. Learn more
Marketing
Apri schedaLEFT(string, [number_of_characters])
Returns a substring from the beginning of a specified string. Learn more
Marketing
Apri schedaLEFTB(string, num_of_bytes)
Returns the left portion of a string up to a certain number of bytes. Learn more.
Marketing
Apri scheda