correl-strong-positive |
CORREL |
=CORREL(A1:A5, B1:B5) |
value |
|
correl-perfect-positive |
CORREL |
=CORREL(A1:A3, B1:B3) |
value |
1 |
correl-perfect-negative |
CORREL |
=CORREL(A1:A3, B1:B3) |
value |
1 |
covar-canonical |
COVAR |
=COVAR(A1:A5, B1:B5) |
value |
|
covar-small-set |
COVAR |
=COVAR(A1:A3, B1:B3) |
value |
|
covariance-p-canonical |
COVARIANCE.P |
=COVARIANCE.P(A1:A5, B1:B5) |
value |
|
covariance-p-linear |
COVARIANCE.P |
=COVARIANCE.P(A1:A3, B1:B3) |
value |
|
covariance-s-canonical |
COVARIANCE.S |
=COVARIANCE.S(A1:A5, B1:B5) |
value |
1 |
covariance-s-linear |
COVARIANCE.S |
=COVARIANCE.S(A1:A3, B1:B3) |
value |
1 |
forecast-linear-fit |
FORECAST |
=FORECAST(6, B1:B5, A1:A5) |
value |
|
forecast-exact-linear |
FORECAST |
=FORECAST(4, B1:B3, A1:A3) |
value |
1 |
forecast-linear-canonical |
FORECAST.LINEAR |
=FORECAST.LINEAR(6, B1:B5, A1:A5) |
value |
|
forecast-linear-exact-linear |
FORECAST.LINEAR |
=FORECAST.LINEAR(4, B1:B3, A1:A3) |
value |
1 |
intercept-canonical |
INTERCEPT |
=INTERCEPT(B1:B5, A1:A5) |
value |
|
intercept-exact-linear |
INTERCEPT |
=INTERCEPT(B1:B3, A1:A3) |
value |
2 |
pearson-canonical |
PEARSON |
=PEARSON(A1:A5, B1:B5) |
value |
|
pearson-perfect-positive |
PEARSON |
=PEARSON(A1:A3, B1:B3) |
value |
1 |
rsq-canonical |
RSQ |
=RSQ(B1:B5, A1:A5) |
value |
|
rsq-perfect-fit |
RSQ |
=RSQ(B1:B3, A1:A3) |
value |
1 |
slope-linear-fit |
SLOPE |
=SLOPE(B1:B5, A1:A5) |
value |
|
slope-exact-integer |
SLOPE |
=SLOPE(B1:B3, A1:A3) |
value |
1 |
steyx-canonical |
STEYX |
=STEYX(B1:B5, A1:A5) |
value |
|
steyx-perfect-fit |
STEYX |
=STEYX(B1:B4, A1:A4) |
value |
1 |
confidence-normal-95 |
CONFIDENCE |
=CONFIDENCE(0.05, 1, 100) |
value |
|
confidence-normal-99 |
CONFIDENCE |
=CONFIDENCE(0.01, 2.5, 50) |
value |
|
confidence-t-small-sample |
CONFIDENCE.T |
=CONFIDENCE.T(0.05, 1, 25) |
value |
|
confidence-t-medium-sample |
CONFIDENCE.T |
=CONFIDENCE.T(0.05, 2.5, 50) |
value |
|
f-test-similar-variance |
F.TEST |
=F.TEST(A1:A5, B1:B5) |
value |
|
f-test-different-variance |
F.TEST |
=F.TEST(A1:A4, B1:B4) |
value |
|
ftest-canonical |
FTEST |
=FTEST(A1:A5, B1:B5) |
value |
|
ftest-different-variance |
FTEST |
=FTEST(A1:A4, B1:B4) |
value |
|
kurt-canonical |
KURT |
=KURT(A1:A5) |
value |
|
kurt-peaked |
KURT |
=KURT(A1:A5) |
value |
|
kurt-inline |
KURT |
=KURT(3, 4, 5, 2, 3, 4, 5, 6, 4, 7) |
value |
|
marginoferror-basic |
MARGINOFERROR |
=MARGINOFERROR(A1:A5, 0.05) |
value |
|
marginoferror-wider-data |
MARGINOFERROR |
=MARGINOFERROR(A1:A5, 0.01) |
value |
|
prob-uniform-bound |
PROB |
=PROB(A1:A5, B1:B5, 2, 4) |
value |
2 |
prob-single-upper |
PROB |
=PROB(A1:A5, B1:B5, 3) |
value |
1 |
prob-full-range |
PROB |
=PROB(A1:A3, B1:B3, 1, 3) |
value |
1 |
skew-symmetric |
SKEW |
=SKEW(A1:A5) |
value |
1 |
skew-right-tail |
SKEW |
=SKEW(A1:A5) |
value |
|
skew-inline |
SKEW |
=SKEW(3, 4, 5, 2, 3, 4, 5, 6, 4, 7) |
value |
|
skew-p-symmetric |
SKEW.P |
=SKEW.P(A1:A5) |
value |
1 |
skew-p-right-tail |
SKEW.P |
=SKEW.P(A1:A5) |
value |
|
t-test-two-tail-paired |
T.TEST |
=T.TEST(A1:A5, B1:B5, 2, 1) |
value |
|
t-test-one-tail-equal-var |
T.TEST |
=T.TEST(A1:A5, B1:B5, 1, 2) |
value |
|
t-test-two-tail-unequal-var |
T.TEST |
=T.TEST(A1:A5, B1:B5, 2, 3) |
value |
|
ttest-two-tail-paired |
TTEST |
=TTEST(A1:A5, B1:B5, 2, 1) |
value |
|
ttest-one-tail-equal-var |
TTEST |
=TTEST(A1:A5, B1:B5, 1, 2) |
value |
|
z-test-canonical |
Z.TEST |
=Z.TEST(A1:A5, 3) |
value |
2 |
z-test-with-sigma |
Z.TEST |
=Z.TEST(A1:A5, 4, 1.5) |
value |
|
ztest-canonical |
ZTEST |
=ZTEST(A1:A5, 3) |
value |
1 |
ztest-with-sigma |
ZTEST |
=ZTEST(A1:A5, 4, 1.5) |
value |
|