Performing an independent samples t test in Excel

Поделиться
HTML-код
  • Опубликовано: 8 апр 2011

Комментарии • 29

  • @soapyroz4471
    @soapyroz4471 3 года назад +4

    Thank you so much! Answered everything that I didn’t know. Even answered when I couldn’t look for the data analysis tool and explained what the results mean. I wish you were my teacher 😭

  • @mukularora9128
    @mukularora9128 3 года назад +1

    Your last information of scientific notation really helped me i was stuck on the same thank you.

  • @connieekenwa3291
    @connieekenwa3291 11 месяцев назад

    Authentic! Thank you very much, Ken.

  • @juanmartinsantos5382
    @juanmartinsantos5382 3 года назад

    You really helped me solve my problem in excel, thank you so much

  • @AnemicChia
    @AnemicChia 9 лет назад

    THAT'S AWESOME~~~!!!

  • @sardineRN
    @sardineRN 9 лет назад +2

    Bloody helpful. Thanks!

  • @sandryl0109
    @sandryl0109 5 лет назад

    This is very helpful. Thank you!

  • @hjdc7422
    @hjdc7422 5 лет назад +1

    YOU SAVED OUR STUDY

  • @tidalaustralia
    @tidalaustralia 12 лет назад

    Excellent presentation

  • @radheymohan6968
    @radheymohan6968 5 месяцев назад +1

    Thanks ❤

  • @frankieroandMCR
    @frankieroandMCR 8 лет назад +1

    amazing, thank you

  • @baxterdifabrizio6418
    @baxterdifabrizio6418 10 лет назад

    Excellent, thank you.

  • @rebeccadegracia8778
    @rebeccadegracia8778 5 лет назад

    Thank you!! So helpful!

  • @michelleluu13
    @michelleluu13 10 лет назад

    Thank you very much!! :D

  • @RimmyTim
    @RimmyTim 11 лет назад

    I get it now, thanks so much.

  • @laxmanbisht2638
    @laxmanbisht2638 3 года назад

    what is the significance of hypothesized mean difference box?

  • @Chelley89
    @Chelley89 11 лет назад

    thank you sooooooooooooooo much!!!

  • @ghayamohammed1674
    @ghayamohammed1674 Год назад

    from where do we find the numbers for a and b?

  • @Lyn-eg3id
    @Lyn-eg3id 8 лет назад +5

    what if the sample sizes are unequal? How do you know when to assume unequal variances?

    • @tubeymoto
      @tubeymoto 6 лет назад +4

      You can generally use t-test independent assuming unequal variances
      But, in-case you want to be sure then;
      You will have to perform an F - Test to find out whether to choose equal or unequal variances.
      1.)Calculate variances for both samples
      2.) F = Larger Variance/Smaller Variance -----> THIS IS THE F-STAT or F-SCORE
      3.)DoF = count(obs)-1 [for column which gave larger variance] and DoF = count(obs)-1 [for column which gave smaller variance]
      4.) Check your alpha in the question, download F-Distribution table w.r.t. that alpha level
      5.) Larger Variance column DoF should be the DoF1. Check that in column of F-table
      Smaller Variance column DoF should be DoF2. Check that in row of F-table
      6.) You will get a F-Critical. If your F-Score is lesser than or equal to the F-Critical,
      then go for the Equal Variance t-test
      Note: If you are doing it by data analysis tool pack, make sure that in variable 1 you enter the samples column, which gave you a larger variance.

  • @lidiyaivannikova5464
    @lidiyaivannikova5464 5 лет назад

    Thanks!!!

  • @mingtipparat
    @mingtipparat 10 лет назад

    thanks

  • @eesa6463
    @eesa6463 3 года назад +1

    Sir plz tell me there are 60 total number of observations why df is 50 instead it should be 58.

  • @lidiyaivannikova5464
    @lidiyaivannikova5464 5 лет назад

    t stat is t obt, right?

  • @zaidoonibrahim8580
    @zaidoonibrahim8580 Год назад

    thank you so much.. my question is.. if my data not normal distribution, what statistical test can I use

    • @KenBlake
      @KenBlake  Год назад +1

      When nonnormality is a problem, you can use the nonparametric test described here: real-statistics.com/non-parametric-tests/wilcoxon-rank-sum-test/. I don’t have a video for this situation, I’m afraid.

  • @gyogalakshmi1704
    @gyogalakshmi1704 2 года назад

    Thank you sir

  • @marcdaniel208
    @marcdaniel208 3 года назад

    how to interpret?

  • @waynegreaves9070
    @waynegreaves9070 Год назад

    What quickly comes to my attention is that you have a total of 30 observation, yet you are doing a Student's t-test. For observation of n >= 30, why aren't you using the Normal Distribution? You have instead chosen to do a Student's t which is for n being a s
    mall number.