Perform A Two-Sample F Test In Excel (Variance Test)

แชร์
ฝัง
  • เผยแพร่เมื่อ 25 ส.ค. 2024

ความคิดเห็น • 31

  • @StevenBradburn
    @StevenBradburn  3 ปีที่แล้ว +2

    ONLINE GUIDE
    toptipbio.com/two-sample-f-test-excel/

  • @javersongoulartfilho9439
    @javersongoulartfilho9439 ปีที่แล้ว +2

    Daaang! This was a neat tutorial! I've exams tomorrow and I'm really grateful for your video!

  • @lachusity
    @lachusity 10 หลายเดือนก่อน +1

    really simple, really practical thank you!

  • @user-te9qb8bc9v
    @user-te9qb8bc9v 7 หลายเดือนก่อน +1

    Thank you for your work! It is very interesting and helpful. Good channel!

  • @yousefgeorge3060
    @yousefgeorge3060 2 ปีที่แล้ว +2

    your set of videos are fantastic only thing thats helping me do stats in biomed

  • @dionisiodulobu7075
    @dionisiodulobu7075 2 หลายเดือนก่อน

    wonderful explanation

  • @erinfigueroa1446
    @erinfigueroa1446 6 หลายเดือนก่อน

    you saved my life thank you!!

  • @NK-iy6if
    @NK-iy6if 2 ปีที่แล้ว +3

    This has been very helpful! God bless you! Thank you!

  • @creativetejas4478
    @creativetejas4478 2 หลายเดือนก่อน

    thank you

  • @purnimaliyanage5774
    @purnimaliyanage5774 ปีที่แล้ว

    Thank you so much for this valuable video

  • @NavaneethaKrishnanA
    @NavaneethaKrishnanA 9 หลายเดือนก่อน

    Thank you. It was helpful

  • @AkshayKumar-vd5wn
    @AkshayKumar-vd5wn ปีที่แล้ว +1

    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.

  • @Jack-ve7ec
    @Jack-ve7ec 5 หลายเดือนก่อน

    You saved me thats a lot

  • @johnbezou1143
    @johnbezou1143 6 หลายเดือนก่อน

    Excellent tutorial. Do you have any tutorials on working with time?

  • @jongsukpark9212
    @jongsukpark9212 ปีที่แล้ว +1

    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

  • @loretohidalgo3533
    @loretohidalgo3533 3 ปีที่แล้ว

    thank you!!

  • @rouge_CiCada
    @rouge_CiCada หลายเดือนก่อน

    Is df 6 good for F-test and independent t-test

  • @mahmoudmohamedismail1758
    @mahmoudmohamedismail1758 7 หลายเดือนก่อน

    I hope I reach that level someday

  • @iris3357
    @iris3357 2 ปีที่แล้ว

    thanks a lot

  • @GPRCPProjectwork
    @GPRCPProjectwork หลายเดือนก่อน

    Can i use the test ?if i have the values of laboratory data on day-1 and day-5

  • @SpiritOfTrboule
    @SpiritOfTrboule 3 ปีที่แล้ว +5

    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?

    • @StevenBradburn
      @StevenBradburn  3 ปีที่แล้ว +4

      Sure, you can do that! :)
      I just demonstrated both ways for the purposes of the tutorial

    • @bigseekersb
      @bigseekersb 2 ปีที่แล้ว

      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.

  • @roxanne3956
    @roxanne3956 3 ปีที่แล้ว

    What's the difference between a one tail and a two tail? HOw do I know which one I need to do?

    • @bigseekersb
      @bigseekersb 2 ปีที่แล้ว

      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 '

  • @aliminhaz9909
    @aliminhaz9909 2 ปีที่แล้ว +1

    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

    • @dereckw4820
      @dereckw4820 ปีที่แล้ว

      same situation bro, did you solve this?

  • @fatemajeni4918
    @fatemajeni4918 2 ปีที่แล้ว +1

    There is a difference between variance of two populations. Then why alternative hypothesis is rejected??

    • @bigseekersb
      @bigseekersb 2 ปีที่แล้ว

      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.