MEDIAN() =MEDIAN(A2:A10) : Median value

MODE.SNGL() =MODE.SNGL(A2:A10) : Most frequent value

PERCENTILE.EXC() =PERCENTILE.EXC(A2:A10,0.9) : Exclusive percentile

PERCENTILE.INC() =PERCENTILE.INC(A2:A10,0.9) : Inclusive percentile

QUARTILE.EXC() =QUARTILE.EXC(A2:A10,1) : First quartile excl

QUARTILE.INC() =QUARTILE.INC(A2:A10,1) : First quartile incl

STDEV.P() =STDEV.P(A2:A10) : Population stdev

STDEV.S() =STDEV.S(A2:A10) : Sample stdev

VAR.P() =VAR.P(A2:A10) : Population variance

VAR.S() =VAR.S(A2:A10) : Sample variance

COVARIANCE.P() =COVARIANCE.P(A2:A10,B2:B10) : Population covariance

CORREL() =CORREL(A2:A10,B2:B10) : Correlation coefficient

TREND() =TREND(known_y,known_x,new_x) : Linear trend values

FORECAST.LINEAR() =FORECAST.LINEAR(new_x,known_y,known_x) : Predict with linear regression
Previous Next