I need assistance completing a t-test for specific course data provided by the program in Excel and using https://www.lock5stat.com/StatKey/

"Compare the different Gendersof subjects in the Psych_Data.xlsx data set to determine if there is a statistically significant difference in the mean Anxiety Scores (anx_score) between the different gender groups. Be sure to state the type of test, state the Ho and Ha, include all relevant Excel results and plots, and write final conclusions for the full results of the test in context. Be sure that your final conclusions are written in common terms for an average person to understand. Include descriptive statistics (mean, standard deviation, sample size) AND an appropriate graphical display that allows you to visually compare the Anxiety Scores for the two gender groups. Copy/paste the numerical summaries and graph here AND describe the similarities and differences in the Anxiety Scores of the two groups (address central tendency and variation of the two groups in your discussion)."

T-test on Excel, needs to be a "t-test: two sample assuming unequal variances" (unless I've assumed incorrectly that I am using an independent samples t-test). I keep getting a spit out from Excel that I am using a non-numeric value (gender). So I swapped male and female to 0 and 1. The results didn't seem correct.

I think I'm on the right track but I am making a serious error somewhere that is causing everything to be wrong.

See data below:

age	gender	ethnicity	dep_scale	anx_score	suicidal_inv	subs_abuse	therapy_pref	ses_level	pre_ther	post_ther	medic
21	Male	Asian	3.9	8.3	3.8	none	group	3	38	38	0
21	Female	AfrAm	2.7	4.4	2.3	narcotics	individual	2	65	64	1
21	Male	AfrAm	3.3	4.9	2.2	narcotics	individual	1	44	46	1
21	Male	Hisp	3.3	5.1	3.1	alcohol	individual	1	61	63	1
21	Female	Hisp	3.3	4.6	4.7	narcotics	individual	1	40	40	1
21	Female	Hisp	3.3	5.1	4.2	alcohol	mixed	1	49	47	0
21	Female	Hisp	3.9	5.3	3.8	both	mixed	3	59	57	1
21	Male	Cauc	3.4	5.1	3.4	narcotics	mixed	1	56	58	0
21	Male	Cauc	4.2	4.9	2.3	both	mixed	2	59	60	0
22	Female	Cauc	3.7	6.1	4.2	narcotics	group	1	46	44	1
22	Female	Asian	4.5	8.1	4.7	none	group	1	51	52	1
22	Female	Asian	3.3	5.7	3.9	alcohol	group	1	58	58	1
22	Male	AfrAm	2.5	5.3	3.3	both	group	1	59	58	1
22	Male	AfrAm	2.8	4.4	2.5	narcotics	group	1	61	62	0
22	Male	Cauc	4.2	6.7	4.3	both	group	3	49	50	0
22	Female	AfrAm	3.6	6.3	3.7	none	individual	2	47	48	0
22	Female	Cauc	4.1	6.9	4.5	both	individual	3	48	50	0
22	Male	Hisp	2.9	4.5	2.8	both	individual	1	63	63	1
22	Male	Asian	3.9	6.2	4.4	narcotics	individual	1	43	42	1
22	Male	Cauc	4.2	6.6	4.1	alcohol	individual	1	41	44	1
22	Female	Hisp	3.8	5.6	4.1	both	mixed	1	45	44	0
22	Female	AfrAm	2.6	5.1	3.1	narcotics	mixed	1	48	46	1
22	Female	Cauc	4.2	7.7	4.6	narcotics	mixed	1	52	51	1
23	Male	Hisp	2.5	4.4	2.5	alcohol	group	1	59	58	1
23	Female	Cauc	3.1	5.5	3.6	none	individual	1	63	66	0
23	Female	Cauc	3.4	5.2	3.8	narcotics	mixed	1	64	64	1
23	Female	Cauc	3.9	5.7	3.9	alcohol	mixed	2	53	55	1
23	Male	Asian	4.1	6.3	4.1	both	mixed	2	51	50	1
23	Male	AmInd	3.6	5.8	3.9	both	mixed	1	50	49	0
24	Female	AfrAm	2.9	4.8	3.3	alcohol	group	1	54	53	1
24	Female	AfrAm	2.6	4.9	2	none	group	1	61	62	1
24	Male	Hisp	3.5	5.4	3.8	both	group	1	55	54	0
24	Female	Cauc	4.3	7.2	4.6	alcohol	individual	3	41	41	0
24	Male	Asian	4.5	5.9	3.8	narcotics	individual	1	50	51	0
24	Male	Cauc	3.9	4.6	2.9	both	individual	2	63	65	0
24	Male	Hisp	2.8	4.2	2.6	narcotics	individual	1	54	52	0
24	Male	Cauc	3.2	5.4	3.2	both	mixed	3	57	60	0
25	Female	Hisp	3.7	5.2	4.5	narcotics	group	1	45	45	0
25	Male	AfrAm	3.1	5.2	3.1	narcotics	individual	1	62	62	0
25	Male	Asian	3.9	5.5	3.1	both	individual	2	60	59	1
25	Male	Hisp	3.1	5.6	3.8	narcotics	individual	1	52	52	1
25	Female	Asian	4.6	7.2	3.8	alcohol	mixed	2	44	44	0
25	Male	Hisp	3.5	4.8	2.7	both	mixed	1	63	61	1
26	Female	AfrAm	2.9	3.4	1.8	both	group	2	57	57	0
26	Female	AfrAm	2.8	3.8	2.7	alcohol	group	1	59	59	1
26	Female	Hisp	3.9	4.3	3.5	both	group	1	55	55	0
26	Male	AfrAm	2.7	4.5	2.6	both	group	1	57	55	0
26	Male	Hisp	3.5	4.9	2.6	narcotics	individual	1	58	57	0
26	Male	Cauc	3.5	6.1	4.3	both	individual	2	43	40	1
27	Female	Hisp	3.4	4.8	3.5	none	group	2	57	60	1
27	Female	Asian	4.2	7.3	4.9	both	group	2	51	53	0
27	Female	Asian	3.4	6.1	4.5	narcotics	group	2	44	42	0
27	Female	Cauc	4.1	6.3	4.3	narcotics	mixed	1	51	51	0
27	Female	Cauc	3.6	4.2	3.5	alcohol	mixed	2	47	46	0
27	Male	Cauc	2.9	4.5	2.9	alcohol	mixed	2	63	62	0
28	Female	Hisp	3.2	6.2	3.8	narcotics	individual	1	55	56	1
28	Male	Hisp	4.1	6.6	4.5	both	individual	1	41	42	0
28	Male	Asian	4.1	7.9	4.6	narcotics	mixed	2	47	47	0
28	Male	AfrAm	2.9	4.2	3.4	narcotics	mixed	3	61	60	0
29	Female	Hisp	3.6	4.8	1.5	narcotics	group	1	49	48	0
29	Male	Cauc	4.2	6.3	4.4	narcotics	group	1	56	55	0
29	Male	Asian	4.3	7.8	4.2	narcotics	group	1	47	46	1
29	Male	AfrAm	3.8	6.5	4.4	both	group	1	50	50	1
30	Female	Asian	4.2	6.6	4.3	both	individual	2	37	36	0
30	Male	AfrAm	2.6	5.1	3.9	none	individual	1	54	54	0
30	Female	Cauc	3.5	6.1	4.3	alcohol	mixed	2	37	39	1
30	Female	Hisp	3.4	6.3	4.2	alcohol	mixed	1	52	53	1
30	Male	Cauc	2.6	6.2	2.1	both	mixed	1	43	42	0
31	Male	Hisp	3.8	3.7	2.2	both	group	1	58	59	1
31	Male	AfrAm	3.1	3.7	1.6	both	group	2	62	62	0
31	Female	AfrAm	4.1	7.1	4.3	none	individual	2	52	52	0
31	Female	Hisp	3.6	5.8	3.7	alcohol	mixed	1	53	53	1
31	Male	AfrAm	3.1	3.7	1.9	narcotics	mixed	3	64	64	0
32	Male	Cauc	2.5	4.9	2.7	narcotics	group	2	41	40	0
32	Female	Cauc	4.5	5.1	4.2	alcohol	mixed	2	45	46	0
33	Female	AfrAm	3.3	5.9	3.5	narcotics	group	2	55	56	1
33	Female	AmInd	3.5	5.8	4.1	none	group	2	48	51	1
33	Female	Hisp	2.9	4.2	2.3	both	individual	3	46	46	1
33	Male	Hisp	3.3	4.5	2.2	narcotics	individual	1	51	52	1
33	Male	Hisp	2.8	4.6	2.4	both	mixed	2	69	69	1
34	Male	Cauc	3.1	4.8	3.7	none	individual	2	57	58	1
35	Male	AfrAm	3.7	5.3	3.7	both	mixed	1	61	60	0
36	Male	AfrAm	3.5	5.8	3.7	alcohol	individual	3	55	57	0
36	Female	AfrAm	3.9	5.2	3.6	alcohol	mixed	2	63	64	0
37	Male	Cauc	3.2	4.8	2.1	alcohol	group	2	68	69	0
37	Male	Cauc	3.2	5.6	3.8	narcotics	mixed	2	59	59	1
38	Female	Hisp	3.3	4.9	2.9	alcohol	group	2	61	62	1
38	Female	AfrAm	4.2	6.9	4.4	none	group	2	50	51	0
38	Male	AfrAm	3.7	5.5	3.6	narcotics	mixed	2	60	59	0
39	Female	AmInd	3.5	6.7	4.1	none	group	3	49	49	1
39	Male	Cauc	3.8	6.2	4.1	none	group	3	62	60	0
39	Male	AfrAm	3.7	5.1	2.9	narcotics	individual	2	65	65	1
40	Female	Asian	3.8	7.2	4.5	none	individual	3	49	51	0
40	Male	Asian	3.3	7.4	4.6	alcohol	individual	2	53	52	0
40	Male	AmInd	3.4	5.8	4.1	alcohol	mixed	3	45	45	0
41	Female	Cauc	2.4	4.9	3.2	both	individual	3	59	59	0
41	Male	AfrAm	3.6	4.5	3.1	alcohol	individual	3	42	42	1
41	Female	Cauc	3.8	5.7	3.9	none	mixed	3	53	53	1
41	Male	Hisp	3.4	4.6	2.4	none	mixed	2	55	55	1
42	Female	AmInd	3.3	5.4	3.9	none	group	3	62	64	1
42	Female	AfrAm	2.6	4.1	2.4	none	group	3	55	53	1
42	Male	Cauc	4.1	5.3	3.9	none	individual	3	43	45	0
42	Female	AfrAm	3.8	6.2	3.9	narcotics	mixed	3	58	58	0
42	Male	AfrAm	3.3	5.5	3.7	alcohol	mixed	3	53	53	1
43	Female	AfrAm	2.9	4.6	3.3	none	mixed	2	62	62	1
44	Male	AmInd	3.9	5.9	4.2	alcohol	individual	2	60	60	1
45	Female	Cauc	3.6	6.8	3.9	alcohol	group	3	53	51	0
45	Female	Cauc	3.6	7.2	4.4	none	mixed	3	34	35	1
46	Female	Hisp	3.7	4.4	2.8	none	individual	2	58	57	1
46	Female	Cauc	4.1	7.5	4.4	none	individual	3	42	45	1
48	Female	AmInd	3.7	7.5	4.3	alcohol	group	3	53	55	0
50	Male	Asian	3.8	7.2	4.5	none	individual	3	50	52	0
50	Female	Cauc	4.4	7.3	4.6	none	mixed	2	49	49	1
50	Male	AfrAm	2.8	3.2	1.6	none	mixed	1	53	52	1
51	Female	Cauc	2.9	5.8	3.5	alcohol	individual	2	50	51	0
51	Female	Hisp	3.1	5.8	2.9	alcohol	individual	2	57	55	0
53	Female	Hisp	3.4	4.6	2.2	alcohol	individual	2	50	51	0
54	Male	AmInd	3.1	4.9	2.3	alcohol	group	3	54	55	1
54	Male	Hisp	2.8	5.2	4.1	none	individual	2	62	63	0
54	Female	Cauc	3.7	5.9	4.3	alcohol	mixed	3	38	40	1
55	Male	Hisp	3.1	5.6	4.2	alcohol	individual	2	46	45	1
56	Female	Cauc	3.3	6.1	4.4	alcohol	individual	3	57	58	1
57	Male	Cauc	4.7	6.4	4.6	alcohol	group	3	36	35	0
57	Female	AfrAm	3.1	4.1	2.3	none	individual	3	63	63	1
58	Female	Cauc	3.9	7.2	4.5	alcohol	individual	3	55	54	0
59	Female	Cauc	2.5	4.3	3.2	alcohol	group	3	52	53	0
60	Male	AmInd	3.5	5.1	4.1	alcohol	individual	2	58	59	0
60	Female	Cauc	4.1	7.3	4.7	alcohol	mixed	2	58	60	0
62	Male	AfrAm	3.6	6.4	4.2	alcohol	mixed	3	50	52	1
69	Male	Asian	4.1	7.4	4.4	none	individual	3	40	42	1