T-Test vs Chi-Squre in Excel PAQ

I am hoping someone can help me out. I want to run a TTEST in excel. And I am not sure how to do it. I understand where to get my Array 1 and 2, but I am unsure what to put in for tails and type. Does the array have to be numbers? I will give you an example of what I am trying to do. I have data on patients who are take either Drug 1 or Drug 2, some of these patients develop a reaction, and we want to see if there is a statistical significance between the number of patients taking Drug 1 who have a reation to the number of patients taking Drug 2 who have a reaction? What numbers would be included in the array, the total count of patients on Drug 1 & 2, or do I select all records (do these have to be numbers). As well, we want to calaculate the statistical significane of the the number of patients who were African-AMerican and Caucasian. ANy info or help will be greatly appreciated.

During that discussion it was evident that Tess required a more comprehensive solution to the problem. I personally felt that the type of analysis suggested may have been unsuitable - that of a Student's Distribution T-Test. Further, I was desirous of making the results available to others who were involved in the discussion.

To that end I state the following:

Tess communicated further details of the problem privately.
I then constructed a WorkBook that provided/included:
The data was set out in a contingency table
The relevant chi-square test applied
Along with several little 'tricks' to enable further analysis etc.

It is virtually impossible to detail how this was achieved in EE. Therefore, if any would like to obtain a copy of the outcome, which was accepted by Tess as meeting the requirements of the question, then please feel free to request a copy by emailing me:

d64471023a@hotmail.com

Also, so that this lot doesn't hang around in current questions I will have to accept an answer from someone - it will be graded A, but of course no points. The first to respond in any way will get the A.

There are several quick shortcuts that can make your life easier in Microsoft Programs. These simple tips and tricks will your work more productive and you faster at completing your tasks!
MS Word
(1) Creating Re-usable Scraps
You can create s…

Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…