who really know about statistics
trillone79
i4samplet-testgodfathervinyardsmegastat.xlsxSheet1
| FIELD # 1 | FIELD # 2 | Descriptive statistics | ||||
| 24.00 | 22.00 | |||||
| 25.00 | 23.00 | FIELD # 1 | FIELD # 2 | |||
| 22.00 | 20.00 | count | 10 | 10 | ||
| 25.00 | 19.00 | mean | 24.0000 | 21.8000 | ||
| 24.00 | 21.00 | sample standard deviation | 1.0541 | 1.9322 | ||
| 25.00 | 24.00 | sample variance | 1.1111 | 3.7333 | ||
| 23.00 | 23.00 | minimum | 22.0 | 19.0 | ||
| 24.00 | 24.00 | maximum | 25.0 | 24.0 | ||
| 25.00 | 19.00 | range | 3.0 | 5.0 | ||
| 23.00 | 23.00 | |||||
| standard error of the mean | 0.3333 | 0.6110 | ||||
| confidence interval 95.% lower | 23.3467 | 20.6024 | ||||
| confidence interval 95.% upper | 24.6533 | 22.9976 | ||||
| margin of error | 0.6533 | 1.1976 | ||||
| z | 1.96 | 1.96 | ||||
| skewness | -0.7115 | -0.4575 | ||||
| kurtosis | -0.4500 | -1.4124 | ||||
| coefficient of variation (CV) | 4.39% | 8.86% | ||||
| normal curve GOF | ||||||
| p-value | .0578 | .1573 | ||||
| chi-square(df=1) | 3.600 | 2.000 | ||||
| E | 2.500 | 2.500 | ||||
| O(-0.67) | 3 | 3 | ||||
| O(+0.00) | 3 | 1 | ||||
| O(+0.67) | 0 | 4 | ||||
| O(inf.) | 4 | 2 | ||||
| Hypothesis Test: Independent Groups (t-test, pooled variance) | ||||||
| FIELD # 1 | FIELD # 2 | |||||
| 24.0000 | 21.8000 | mean | ||||
| 1.0541 | 1.9322 | std. dev. | ||||
| 10 | 10 | n | ||||
| 18 | df | |||||
| 2.20000 | difference (FIELD # 1 - FIELD # 2) | |||||
| 2.42222 | pooled variance | |||||
| 1.55635 | pooled std. dev. | |||||
| 0.69602 | standard error of difference | |||||
| 0 | hypothesized difference | |||||
| 3.161 | t | |||||
| .0054 | p-value (two-tailed) | |||||
Runs Plot
24 25 22 25 24 25 23 24 25 23Time
FIELD # 1
Runs Plot
22 23 20 19 21 24 23 24 19 23Time
FIELD # 2
