How to perform t-test in Excel

The Student's t-test or simply t-test tells you how significant the differences between groups are. It can either be paired or unpaired t-test depending on whether the data is paired or unpaired. The ultimate goal for you is to find the p value and if it is less than 0.05 then there is significant difference between the two groups. If it is more than 0.05 then there is no significant difference between the two groups.

[sr.peter-paulnakitende]

I am very impressed on how you are able to explain a complicated matter and simplified it for me. I have managed to compute my assignment that was so hard for me following your explanation. Be blessed.

[FFMvideos]

Thank you so much 😢😢😢, I'm about to fail the subject that using excel😢😢, but thank you for your brilliant explanation and tutorial❤

[waynegreaves]

Clarifications please:

On both the Paired and Unpaired t-test, we are doing a 95% Confidence Level which leaves us with 0.05 to be divided by two and distributed in the two tails as our Critical Value and Rejection Region to the right of the Critical Value.

First t-test, the paired t-test yields a P-Value of Positive (+) 0.029 in the Right Tail, and Negative (-) 0.029 in the Left Tail. This gives us a comparison of Alpha < P-Value or 0.025 < 0.029. Because this P-Value falls to the right of the Critical Value (into the Rejection Region), it is considered significant and we must reject the Null (Mu1 = Mu2).

Second t-test, the Unpaired t-test yields a P-Value = +0.024 in the Right Tail and -0.024 in the Left Tail. In this second t-test we have the following:

Alpha > P-Value:

Right Tail: 0.025 > 0.024. This P-Value is NOT Significant. It does NOT fall in the Rejection Region. Therefore, we FAIL TO REJECT THE NULL at the 95% Confidence Level.

Left Tail: -0.05 > -0.024. The P-Value is NOT significant. It does NOT fall in the Rejection Region. We, therefore, FAIL TO REJECT THE NULL.

CLARIFICATION:

As it relates to the second Unpaired t-test, I heard you said it is significant, meaning that we must reject the NULLL. Please update.

[farahqureshi]

Thsnk u today is my viva in excel 😢 thsnk u for guiding

[daveang]

the video is great but would prefer if you can speak louder.

[dulumanidas]

The number of entries doesn't matter is it? Like in your example only 10 values, more than 10 values also will it give correct result?

[alicjamoodynska]

brilliant explanation, you explained a difficult topic in a simple way, thank you!

[asmaashbat]

Thank you so much for this video. and I am looking for a video to test the validity for each question.
Could you please make this video.

[julia]

Спасибо большое! Вы на не родном мне языке объясняете понятнее, чем русские "знатоки"

[mazam]

Display is a slightly small in view, can it becom enlarge

[Miss_smiling_brunette]

Turned out very helpful to analyse my data 😁 god bless you ☺️

[letodavid]

Thank you very much for the simplified lecture

[ritubharti]

If the data is mixed, means subjective and numeric data, then how can we apply the t test please explain?

[princetakyitabiri]

For the unpaired is the option you choose going to have an effect on the p-value ?

[adriancorreces]

Nice, this helped me a lot... Thank you

[barbararapaport]

Can anyone please tell how to do a t-test when you have 50 rows and 50 columns in excel spreadsheet?

[nadinetaylor]

Great video, but please turn the volume down on your clicking

[sum.medartist]

P value with 3 or more variables??ps tell

[issamelidrissi]

Hello would u plz help me to calculate p value for the work of my thesis
I really watched your video several times but i couldn't manage to calculate it at my own

[idehngozi]

Please can I use it for effect of cashless policy in an economy