PEARSON
PEARSON(data_y, data_x)
Calculates r, the Pearson product-moment correlation coefficient of a dataset. Learn more
Analisi dati
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.
369 formule trovate · pagina 7 di 8
Non sai da dove partire?
Percorsi per livello e use case
Base
Intermedio
Avanzato
Use case
Sfida del giorno
PERCENTILE
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 scheda