Independent Ttest
The Student’s ttest is a statistical test that compares the mean and standard deviation of two samples to see if there is a significant difference between them. In an experiment, a ttest might be used to calculate whether or not differences seen between the control and each experimental group are a factor of the manipulated variable or simply the result of chance.
The Ttest is a test of a statistical significant difference between two groups. A "significant difference" means that the results that are seen are most likely not due to chance or sampling error. In any experiment or observation that involves sampling from a population, there is always the possibility that an observed effect would have occurred due to sampling error alone. But if result is "significant," then the investigator may conclude that the observed effect actually reflects the characteristics of the population rather than just sampling error or chance.
In any significance test, there are two possible hypothesis:
In any significance test, there are two possible hypothesis:
Null Hypothesis:
"There is not a significant difference between the two groups; any observed differences may be due to chance and sampling error." For example:

Alternative Hypothesis:
"There is a significant difference between the two groups; the observed differences are most likely not due to chance or sampling error." For example:

How to Calculate T:
 Calculate the mean (X) of each sample
 Find the absolute value of the difference between the means
 Calculate the standard deviation for each sample
 Square the standard deviation for each sample
 Divide each squared standard deviations by the sample size of that group.
 Add these two values
 Take the square root of the number to find the "standard error of the difference.
 Divide the difference in the means (step 2) by the standard error of the difference (step 7). The answer is your "calculated Tvalue."
 Determine the degrees of freedom (df) for the test. In the ttest, the degrees of freedom is the sum of the sample sizes of both groups minus 2.
 Determine the “Critical Tvalue” in a table by triangulating your DF and the “p value” of 0.05.
A pvalue s the probability of concluding there is a significant difference between the groups result when the null hypothesis is true (meaning, the probability of making the WRONG conclusion). In biology, we use a standard “pvalue” of 0.05. This means that five times out of a hundred you would find a statistically significant difference between the means even if there was none.

11. Draw your conclusion:
Sometimes it is nice to check your answers to make sure you are doing the calculations right. Use this website to check your results.
 If your calculated t value is greater than the critical Tvalue from the table, you can conclude that the difference between the means for the two groups is significantly different. We reject the null hypothesis and conclude that the alternative hypothesis is correct.
 If your calculated t value is lower than the critical Tvalue from the table, you can conclude that the difference between the means for the two groups is NOT significantly different. We accept the null hypothesis.
Sometimes it is nice to check your answers to make sure you are doing the calculations right. Use this website to check your results.
Performing a Ttest with the TI83/84
 Hit the STAT button on the calculator
 Select option 4 to clear any past lists of data.
 Select option 1 to EDIT your lists.
 Enter your data for each group as List 1 and List 2
 Hit STAT button and use the arrow key to move over to the TESTS option
 Scroll down to option 4, the 2sample T test and hit ENTER
 Scroll to the bottom of the screen and hit ENTER over the CALCULATE option
 Your results are given.
Performing a Ttest in Google Sheets
 In our class, the formula we'll want to use is =TTEST(A1:A4, B1:B4, 2, 3). Replace A1:A4 with your data from the first sample and B1:B4 with your data from the second sample.
 Calculating the Standard Deviation in Google Sheets (website)
 Performing a Ttest in Google Sheets (video)
 Changing the number of digits displayed in your Google Sheet (website)
Performing a ttest with Excel
Excel calculates a Ttest in a slightly different way. Rather than giving you the t value and comparing it to a table, Excel simply tells you the probability that the means are different simply due to chance, the “P value.” Follow these steps to calculate a P value using a ttest with Excel:
 Create two columns, side by side, for the data of interest. Each sample’s data should be in separate columns
 Click on another blank cell where you wish the P value to appear.
 Then click “fx” on the Excel Formulas toolbar.
 In the box, search for the "T test" function and choose “T.TEST" from the list. Hit OK. You will need to set the ttest parameters:
 For “Array1” highlight the data from one sample; for “Array2”, highlight the data in the second sample.
 Enter “2” in the box for “Tails.”
 Lastly, you will have to select the “Type” of ttest. For our purposes, we will mostly use type “2.” Although, if you are measuring the same sample at two points in time (for example before and after treatment) then you would have a type "1."
5. After answering these questions click “OK” and the P value will appear. The P value will fall between zero and one.
What does my P value mean? Excel gives the chance that the differences between the two samples are due to random chance alone. If Excel calculates a P value of 0.22, it means that there is a 22% likelihood that the difference in the means of your two data sets is due to random chance. Normally will say that a P value of .05 or less is significant in which case we reject the null hypothesis (accept the alternative hypothesis). If the P value is greater than 0.05, we accept the null hypothesis and conclude that there is no significant difference between the two groups.