0c0ed1 |
CORREL |
=CORREL(A1:A5, B1:B5) |
value |
|
8feecc |
CORREL |
=CORREL(A1:A3, B1:B3) |
value |
1 |
13052c |
CORREL |
=CORREL(A1:A3, B1:B3) |
value |
1 |
b28840 |
COVAR |
=COVAR(A1:A5, B1:B5) |
value |
|
44ceef |
COVAR |
=COVAR(A1:A3, B1:B3) |
value |
|
dc6333 |
COVARIANCE.P |
=COVARIANCE.P(A1:A5, B1:B5) |
value |
|
7a238e |
COVARIANCE.P |
=COVARIANCE.P(A1:A3, B1:B3) |
value |
|
97f567 |
COVARIANCE.S |
=COVARIANCE.S(A1:A5, B1:B5) |
value |
1 |
a2fe62 |
COVARIANCE.S |
=COVARIANCE.S(A1:A3, B1:B3) |
value |
1 |
b3e26d |
FORECAST |
=FORECAST(6, B1:B5, A1:A5) |
value |
|
a63a55 |
FORECAST |
=FORECAST(4, B1:B3, A1:A3) |
value |
1 |
e3329d |
FORECAST.LINEAR |
=FORECAST.LINEAR(6, B1:B5, A1:A5) |
value |
|
4437fe |
FORECAST.LINEAR |
=FORECAST.LINEAR(4, B1:B3, A1:A3) |
value |
1 |
615f0d |
INTERCEPT |
=INTERCEPT(B1:B5, A1:A5) |
value |
|
851aff |
INTERCEPT |
=INTERCEPT(B1:B3, A1:A3) |
value |
2 |
8ec8ea |
PEARSON |
=PEARSON(A1:A5, B1:B5) |
value |
|
46788b |
PEARSON |
=PEARSON(A1:A3, B1:B3) |
value |
1 |
c39769 |
RSQ |
=RSQ(B1:B5, A1:A5) |
value |
|
83b8c2 |
RSQ |
=RSQ(B1:B3, A1:A3) |
value |
1 |
a397d4 |
SLOPE |
=SLOPE(B1:B5, A1:A5) |
value |
|
78fc6c |
SLOPE |
=SLOPE(B1:B3, A1:A3) |
value |
1 |
194e1d |
STEYX |
=STEYX(B1:B5, A1:A5) |
value |
|
329591 |
STEYX |
=STEYX(B1:B4, A1:A4) |
value |
1 |
1c582d |
CONFIDENCE |
=CONFIDENCE(0.05, 1, 100) |
value |
|
8077b8 |
CONFIDENCE |
=CONFIDENCE(0.01, 2.5, 50) |
value |
|
81303d |
CONFIDENCE.T |
=CONFIDENCE.T(0.05, 1, 25) |
value |
|
247a0f |
CONFIDENCE.T |
=CONFIDENCE.T(0.05, 2.5, 50) |
value |
|
724570 |
F.TEST |
=F.TEST(A1:A5, B1:B5) |
value |
|
993d9c |
F.TEST |
=F.TEST(A1:A4, B1:B4) |
value |
|
91a763 |
FTEST |
=FTEST(A1:A5, B1:B5) |
value |
|
3e1a85 |
FTEST |
=FTEST(A1:A4, B1:B4) |
value |
|
12e440 |
KURT |
=KURT(A1:A5) |
value |
|
30f8e2 |
KURT |
=KURT(A1:A5) |
value |
|
383d62 |
KURT |
=KURT(3, 4, 5, 2, 3, 4, 5, 6, 4, 7) |
value |
|
803bea |
MARGINOFERROR |
=MARGINOFERROR(A1:A5, 0.05) |
value |
|
17c8e9 |
MARGINOFERROR |
=MARGINOFERROR(A1:A5, 0.01) |
value |
|
9ece5c |
PROB |
=PROB(A1:A5, B1:B5, 2, 4) |
value |
2 |
9f749c |
PROB |
=PROB(A1:A5, B1:B5, 3) |
value |
1 |
c2533b |
PROB |
=PROB(A1:A3, B1:B3, 1, 3) |
value |
1 |
98240f |
SKEW |
=SKEW(A1:A5) |
value |
1 |
040645 |
SKEW |
=SKEW(A1:A5) |
value |
|
b3a58c |
SKEW |
=SKEW(3, 4, 5, 2, 3, 4, 5, 6, 4, 7) |
value |
|
c939de |
SKEW.P |
=SKEW.P(A1:A5) |
value |
1 |
2c0434 |
SKEW.P |
=SKEW.P(A1:A5) |
value |
|
b20f22 |
T.TEST |
=T.TEST(A1:A5, B1:B5, 2, 1) |
value |
|
c40763 |
T.TEST |
=T.TEST(A1:A5, B1:B5, 1, 2) |
value |
|
4d88f6 |
T.TEST |
=T.TEST(A1:A5, B1:B5, 2, 3) |
value |
|
352c3f |
TTEST |
=TTEST(A1:A5, B1:B5, 2, 1) |
value |
|
567a19 |
TTEST |
=TTEST(A1:A5, B1:B5, 1, 2) |
value |
|
fe904d |
Z.TEST |
=Z.TEST(A1:A5, 3) |
value |
2 |
139b72 |
Z.TEST |
=Z.TEST(A1:A5, 4, 1.5) |
value |
|
f5dd88 |
ZTEST |
=ZTEST(A1:A5, 3) |
value |
1 |
52dbaa |
ZTEST |
=ZTEST(A1:A5, 4, 1.5) |
value |
|