Statistical analysis (t-test)

[Final_metroid]

okay, so in science research we are expected to do statistics to determine the validity of the alternate hypothesis, however statistics is a whole other course in itself and our teacher intentionally did not go over it in detail to force us to learn it for ourselves. I need help conducting a t-test in microsoft excel, and so far i dont know if the result im getting is correct

My experiment (gratuitous use of pronouns ahead)

Group 1 (10 subjects)

Group 2 (control, 10 subjects)

All 20 subjects were tested 20 times each and either received (for all intents and purposes)a "yes" or "no" each test.

So im putting it in excel like this

GROUP 1

||||||Subject 1 Subject 2 Subject 3...Subject 20

Yes (Insert numbers in here under each subject notation)

No

Group 2

(see above)

For the T-test funcion, i think I am putting in the correct data parameters (i am selecting the rows of "yes" in each group only) but I am selecting a one-tailed distribution and a homoscedastic type t-test.

When doing that, I recieve an incredibly small decimal (1.6969E-7 or so) i do not know if Im doing it right, does that mean I should include the "no" row as well when doing the test, or what?

Any help would be greatly appreciated