In: Statistics and Probability
mass | v1 | v2 | v3 |
1 | 1.1 | 1.24 | 0.98 |
2 | 1.53 | 1.46 | 1.57 |
3 | 1.96 | 1.83 | 1.79 |
4 | 2.14 | 2.16 | 2.35 |
5 | 2.4 | 2.52 | 2.5 |
Using excel, how do you find the t test and the chi-squared?
There are special function in excel for t test and chi squared tests. These are:
For getting the chi square value we have:
So here is an two tailed t test in excel: