Retention is measured on a 5-point scale (5 categories). Test whether responses to retention variable is independent of gender. Use significance level of 10%. In the answers provide test statistics, p value and conclusion in excel.

How do I get t statistic and p-value in excel? Please break it down using excel.

The data is as follows:

Retention	Gender		For retention
1	2		1-Very likely to stay with this facility
2	1		2-Somewhat likely to stay with this facility
1	2		3-Neither likely nor unlikely
1	2		4-Somewhat unlikely to stay with this facility
3	1		5-Very unlikely to stay with this facility
4	2
3	2
3	1		For gender
3	1		1 = Male
3	2		2 = Female
4	1
5	2
3	1
5	2
3	1
4	1
2	1
3	1
3	1
3	1
4	1
4	2
4	1
3	1
3	1
4	1
4	1
1	1
5	1
3	1
2	2
3	1
3	1
3	1
3	1
3	2
3	1
2	1
3	1
5	1
3	2
2	1
3	1
3	1
3	1
4	1
3	1
3	2
2	1
3	2
3	1
2	2
1	1
3	2
3	2
5	1
3	1
1	2
3	1
3	1
3	2
1	1