Perform A Two-Sample F Test In Excel (Variance Test)
HTML-код
- Опубликовано: 15 июл 2024
- In this video, I’m going to show you how to perform a two-sample F-test for variances in Microsoft Excel. I’ll show you how to generate the results, including a P value, and will also clearly interpret each output to explain what they mean.
ONLINE GUIDE
toptipbio.com/two-sample-f-te...
VIDEO CHAPTERS
00:00 Intro
00:49 My example data
01:07 Installing the Analysis ToolPak
01:43 Performing the F test
04:14 Interpreting the results
06:59 Using the F.TEST function
08:26 Wrapping up
HOW I CREATED THIS TUTORIAL (AFFILIATE LINKS)
Screen recorder & editor techsmith.z6rjha.net/c/198849...
RUclips SEO www.tubebuddy.com/SHTeach
Software (Microsoft Excel 365 ProPlus)
FOLLOW US
Website toptipbio.com/
Facebook / toptipbio
Twitter / toptipbio
AFFILIATE DISCLAIMER
Some of the above links are affiliate links, meaning I will earn a commission if a sale is made after clicking on the link 
Хобби
ONLINE GUIDE
toptipbio.com/two-sample-f-test-excel/
This has been very helpful! God bless you! Thank you!
your set of videos are fantastic only thing thats helping me do stats in biomed
really simple, really practical thank you!
Thank you so much for this valuable video
you saved my life thank you!!
Thank you. It was helpful
wonderful explanation
thank you!!
thank you
thanks a lot
Thank you for your work! It is very interesting and helpful. Good channel!
Glad you enjoy it!
Daaang! This was a neat tutorial! I've exams tomorrow and I'm really grateful for your video!
Good luck mate!
You saved me thats a lot
Excellent tutorial. Do you have any tutorials on working with time?
Thank you for your tutorial video.
It was very helpful to me.
I have a one question for F-test.
I know that F-test is performed to know the two groups having same variance or not. And this information could be used for performing a Student's t-test or Welch's t-test.
If only the p-value is utilized in an F-test to determine whether the variance is homogeneity or heterogeneity, which p-value is correct for this purpose?
(one-tailed p-value or two-tailed p-value < 0.05?)
I will wait your reply.
Thank you
Good video.
How do we know which hypothesis is right?
It would be also right to say that the null hypothesis has unequal variance.
Is there something to determine the formulation of the hypothesis?
I could say that in first case the male has more variance than female and in the second case there is a difference in the variance.
I hope I reach that level someday
So I could just skip the one tail procedure, do the two tail with one command and divide by two to get the P value for one tail F? Or am I missing something here?
Sure, you can do that! :)
I just demonstrated both ways for the purposes of the tutorial
Suppose you could if you only wanted a p-value. But you would get no information for the f-test value or the f-critical-value.
What's the difference between a one tail and a two tail? HOw do I know which one I need to do?
If the alternate hypothesis has a 'does not equal' sign, then it is a 2-tail test. If the the alternate hypothesis has a '>' or an '
Can you please interpret this?
And what should I do with the exponents?
Mean 1371955.979
Variance 3.43924E+12
Observations 48
df 47
F 7.424245218
P(F
same situation bro, did you solve this?
There is a difference between variance of two populations. Then why alternative hypothesis is rejected??
These two particular sample variances are different, but they are not different enough to prove to us that the variances for the POPULATIONS are different, based on the small sample size and the level of significance (alpha = 0.05) that we are using for the test.