# Carrying out a T-Test in Microsoft Excel

On this video I take advantage of Excel for Mac 2011 Model 14.2.3

First state a null speculation – which is at all times that there’s NO vital distinction between your two knowledge units.

Select the cell during which you want to calculate the p-value (the worth that Excel produces in a t-test). Choose the blue enigma signal on the prime of the display, then ‘extra features’ after which seek for t-test. Double click on.

Put the next within the choice containers:

Array 1 – Choose your knowledge set 1

Array 2 – Choose your knowledge set 2

Tails – kind in ‘2’ to characterize 2-tailed take a look at as described within the directions (until your teacher states in any other case)

Sort – kind in ‘2’ to characterize two-sample equal variance as described within the directions

Hit ‘enter’ and a p-value will probably be calculated by Excel.

If the P-value is larger than 0.05, we contemplate it to be excessive and in such a case there’s a excessive likelihood that your noticed outcomes are due merely to probability and never another variable. This might be the case if the calculated worth of t had been lower than the essential worth of t (had you calculated the worth of t your self as a substitute of in Excel). In such a case you’d settle for the null speculation and state that there isn’t a vital distinction between the 2 knowledge units on the 5% or 0.05 significance degree.

If the P-value is decrease than 0.05, we contemplate it to be low and in such a case there’s a low likelihood that your noticed outcomes are due merely to probability and a excessive likelihood that they’re on account of another variable. This might be the case if the calculated worth of t had been greater than the essential worth of t (had you calculated the worth of t your self as a substitute of in Excel). In such a case you may reject the null speculation and state that there’s a vital distinction between the 2 knowledge units on the 5% or 0.05 significance degree.

source

Thank you that was very clear and understandable

Brilliant! Thank you so much! Very clear!

What if we want our significance value to be .01 instead of .05?

Shouldn't you say "fail to reject the null hypothesis" instead of "accept the null hypothesis?"

Is this a 'paired samples t-test', or an 'independent samples t-test'? Thank you!

woh r u a gril

This is a great video, but it shows how to find p-values for data based on ranges which contain the data itself. How do I figure out p-values in excel if I already have n1, n2, mu1, mu2, and Sd1 Sd2 for my two sets that I am comparing?

Very helpful for me. Thank you so much for your contribution.

I heard on another tutorial that the TDIST.2T function must be used to calculate the exact p value in a two tailed test. I have been trying this but it seems to produce less significant results the more difference there is between the two data sets! Can anyone elaborate on this?

Thank you very much.

I love you :')

This really helped with the analysis of my data set, thanks so much!

we never accept the Ho. In this case we just reject the Ha

I have less than 10 values , what test can I use?

best video i have seen for explaining this thanks

Awesome! Thank you

This is a great video and shows how to use excel and what you need to do. The only thing wrong with it is your conclusion. You said that we accept the null hypothesis. WE NEVER ACCEPT THE NULL HYPOTHESIS. We can either reject the null hypothesis or fail to reject the null hypothesis. So make sure you don't accept it. But great video!

Very useful! Thanks!

omg, this was probably the best video i've seen explaining this matter

Short and simple. Thank you.

THANK YOU… for being clear, concise and using a mac!

Thank you!

Very, Very helpful, thank you

Thanks

Awesome! This helped me finish the last bit of my presentation due tomorrow

Cant get any simpler !

Thanks

Thanks 🙂

thanks!!

It was already installed and by my understanding has been a part of the MS Excel pack since Excel 2003 – have you indeed tried searching for the function as I demonstrate in the video?

I have the 2011 version, I just downloaded STAT PLUS, but it doesn't display it as well as it would have on windows (as an example). I don't get any t-test options when I search 't' or 't-test' at the functions page. I tried using the help system, however it was useless. Did you manually add that function or was it already installed?

Do you have the latest version of Excel? I assume you've tried searching for the function as the video shows.

how did you download the t-test function on excel on your mac? I've been trying for so long now and I just can't find it