ANOVA with Excel

แชร์
ฝัง
  • เผยแพร่เมื่อ 8 ก.ย. 2024
  • Conducting a One Way ANOVA using Excel

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

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

    Your video was a HUGE help! Until now, I was clumsily trying to run ANOVA on website calculators, which took forever sometimes. This is so fast and easy.

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

    Really nice,mam.Thanks a lot from India.

  • @dcmissouri
    @dcmissouri 14 ปีที่แล้ว

    all of your excel statistical tutorials are excellent! you really make is very simple.

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

    Great video. I was able to help my daughter - a medicine student- with one of her lab reports because your explanation was pretty clear. Thank you very much and regards from Costa Rica. Keep up the good work !!!

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

    Thanks a lot! really helped me out for my system design exam :) !

  • @relttilhannah
    @relttilhannah 11 ปีที่แล้ว

    Thank you so much. Clearest explanation I've found.

  • @joelgibbs4038
    @joelgibbs4038 11 ปีที่แล้ว

    God bless and thank you for this wonderful explanation.. have been breaking my head manually for days.

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

    Great tutorial! Thank you.

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

    Saved my life, thanks!

  • @baharbassiri
    @baharbassiri 13 ปีที่แล้ว

    Thank you very much for posting this. It worked and that feels great!!!

  • @gseg25
    @gseg25 14 ปีที่แล้ว

    thank you thank you thank you!!!! my homework is done now thanks to you! really thank you very very much :D

  • @jibran241092
    @jibran241092 12 ปีที่แล้ว

    Brilliant tutorial. Thank you.

  • @alessandrofossi2666
    @alessandrofossi2666 5 ปีที่แล้ว

    Very well explained: simple and useful!

  • @Ibuification
    @Ibuification 10 ปีที่แล้ว

    Really awesome tutorial!
    Thank you

  • @AnotherH8er
    @AnotherH8er 10 ปีที่แล้ว

    Short and to the point. Great demonstration ^_^

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

    Very useful! Thank you.

  • @rebeccadegracia8778
    @rebeccadegracia8778 5 ปีที่แล้ว

    Thank you! So helpful!

  • @StlyDutch
    @StlyDutch 12 ปีที่แล้ว

    Thanks for uploading! I was a little stressed out because SPSS won't work on my laptop. I'll use good old Excel instead.

  • @jasonpaz
    @jasonpaz 13 ปีที่แล้ว

    Thank you so much! And by the way, I really like your voice. Its so relaxing.

  • @TheMojojojotang
    @TheMojojojotang 11 ปีที่แล้ว

    you are a lifesaver. if ever u come to taiwan, let me treat u to dinner!

  • @AceKing47
    @AceKing47 13 ปีที่แล้ว

    Oooooh yes! You have just saved a life!

  • @amdemekoya5953
    @amdemekoya5953 10 ปีที่แล้ว

    Excellent video keep doing what your doing, gave me everything i needed!!!!

  • @hloniphalisa4632
    @hloniphalisa4632 4 ปีที่แล้ว

    Thank you so much

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

    Thank you soo much mam ...

  • @crmaximo
    @crmaximo 11 ปีที่แล้ว

    Short and powerfull. Thanks!

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

    Perfect.Iranians are the best teachers :)

  • @zhilla
    @zhilla 13 ปีที่แล้ว

    wonderful, thanks for help

  • @AngelicaR891
    @AngelicaR891 12 ปีที่แล้ว

    I am also confused about if the F critical is higher etc...what it means etc...
    however what I can tell you is that null hypothesis for ANOVA is : the three groups are equal. When your p-value is smaller than 0.05 like in this case p

  • @ahmadmohamadi
    @ahmadmohamadi 13 ปีที่แล้ว

    Nice Persian Accent! And of course nice job!

  • @slinter
    @slinter 12 ปีที่แล้ว

    @Aelfredus26 reject H0 if significant (smaller 5%), this means there are treatment effects between the different groups. thats the same as: reject if you calculated F is bigger than the theoretical (F crit) at a alpha 5%. i dont know what p-value means, something with the confidence, so yea sort of the probability of you being wrong (not super duper sure if you can say it like that)

  • @robertobrittojr4541
    @robertobrittojr4541 11 ปีที่แล้ว

    Very good!

  • @ritikafanda3026
    @ritikafanda3026 9 ปีที่แล้ว

    very clear tutorial with a helpful explanation!

  • @erdmannditzel
    @erdmannditzel 13 ปีที่แล้ว

    @Aelfredus26 It's the probability, that the population mean of all three groups are equal.

  • @karrytababy
    @karrytababy 13 ปีที่แล้ว

    Good job, GMU!

  • @TheTomsy123
    @TheTomsy123 11 ปีที่แล้ว

    very very helpful

  • @LakshmananKannan
    @LakshmananKannan 6 ปีที่แล้ว

    Good information madam

  • @muokasina284
    @muokasina284 10 ปีที่แล้ว

    The lesson was really good

  • @zaksback123
    @zaksback123 13 ปีที่แล้ว

    u saved my lifeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee

  • @ketyin87
    @ketyin87 12 ปีที่แล้ว

    What is the further test that we can do to determine whether is there any significant difference between each group of data?

  • @mkpingpong
    @mkpingpong 13 ปีที่แล้ว

    thank you sooooooo much :)

  • @jithendravs
    @jithendravs 13 ปีที่แล้ว

    thank you so much !

  • @MayaKawaguchi
    @MayaKawaguchi 10 ปีที่แล้ว

    this was helpful :) thanks!

  • @itaipee
    @itaipee 12 ปีที่แล้ว

    thanks , that helps

  • @TheXcs03
    @TheXcs03 12 ปีที่แล้ว

    Hi there, thanks for the video I got most of it but got confused as well.. if F value is greater than f-critical, should we be ACCEPTING the null hypothesis or REJECTING it?? in the mean time if pvalue is greater than Alpha, what should we be doing??
    An answer would help towards my desertation.

  • @hungryyelly
    @hungryyelly 8 ปีที่แล้ว

    Thank you very much :D

  • @mylilcritic
    @mylilcritic 11 ปีที่แล้ว

    Thank you so much!

  • @namelessnelly
    @namelessnelly 12 ปีที่แล้ว

    Did you check if you accidentally included the label range also? Maybe that is why.

  • @coldflame333
    @coldflame333 11 ปีที่แล้ว

    Thank you. That was excellent! Continuing on from your teaching, you said that an ANOVA here simply tells you that there is 'something going on'.
    Following on, could one then do simple T-tests comparing the 3 groups?

    • @TheAgentSilver
      @TheAgentSilver 6 ปีที่แล้ว

      coldflame333 yes that are called post hoc tests

  • @NikolaCouling
    @NikolaCouling 10 ปีที่แล้ว

    Thanks!

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

    nice!

  • @kirannable21
    @kirannable21 11 ปีที่แล้ว

    thank u!!!

  • @ywloveskpop
    @ywloveskpop 12 ปีที่แล้ว

    if nid do further anlaysis to determine the diff, can we use t test?

  • @sdarby2222
    @sdarby2222 12 ปีที่แล้ว

    F0 > F-critical reject. if pvalue < level of significance reject. Else there is not enough evidence to reject H0.

  • @drhbeng
    @drhbeng 11 ปีที่แล้ว

    WONDERFUL...CAN U PROVIDE ME MULTI WAY ANOVA??

  • @Aelfraed26
    @Aelfraed26 13 ปีที่แล้ว

    Someone help me. So, when the P-value is smaller than the alpha it means that we accept H1 and reject H0, just like when F is bigger than F crit?
    Btw, what does the P-value means? It seems to be the probability of something.

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

    A quick and simple, but erroneously says difference in the means. Whereas, actually the ANOVA looks at the differences in the Variances of the groups under test. Secondly, you may like to give little more clear reason as why you selected 1-Way ANOVA? Overall, nice effort.

  • @1ALEXANDERKIM
    @1ALEXANDERKIM 11 ปีที่แล้ว

    Is it related to moderation analysis?

  • @ROCKSOLID36
    @ROCKSOLID36 13 ปีที่แล้ว

    thank u

  • @triggerako
    @triggerako 11 ปีที่แล้ว

    hi, how to put an output in the box??

  • @Hinkakan
    @Hinkakan 12 ปีที่แล้ว

    I am having problems with ANOVA in Excel. I'm getting the error "there are non-numeric entries in the data". I believe it is because the groups are not of the same size. Is this a problem in Excel? I know that other programs like SPSS can work around it

  • @ssabour417
    @ssabour417 11 ปีที่แล้ว

    Very Nice. Iranian are the best :)

  • @ronishemtov3826
    @ronishemtov3826 7 ปีที่แล้ว

    Hi! Can you conduct the same method if solely using 2 groups rather than 3?

    • @mandrewsf
      @mandrewsf 7 ปีที่แล้ว

      sure but it would be the same as conducting a t-test

  • @LakshmananKannan
    @LakshmananKannan 6 ปีที่แล้ว

    Madam kindly guide me regarding interpretation with results retrieved

  • @noxth
    @noxth 10 ปีที่แล้ว

    I have a question here... can we apply this on different number of population?
    for example
    group a) 100 people
    group b) 145 people
    do we need to equalize the population first?
    thank you it is a good video by the way!

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

      noxth i just tried with 3 groups (4078 people, 4149 people and 4219 people) and my variance within groups was immensely larger than the variance between groups -.-

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

      +noxth
      Yes. You can.

    • @noxth
      @noxth 8 ปีที่แล้ว

      thanks guys!

  • @MultiEzaz
    @MultiEzaz 11 ปีที่แล้ว

    just block my stress but i want to apply anova on ms-excel 2007

  • @jpromdiph
    @jpromdiph 14 ปีที่แล้ว

    Hi, this is in Excel 97 right????

  • @StlyDutch
    @StlyDutch 12 ปีที่แล้ว

    Select labels next time.

  • @tuanlong9238
    @tuanlong9238 6 ปีที่แล้ว

    Thanks for sharing, but I don't think your video is good enough. You just tell us the result, that we can see it but still not explain it yet. What F, what F critical? What conclusion do we have if F > F critical... etc?

  • @BradyDowling
    @BradyDowling 11 ปีที่แล้ว

    Easy on the mic, my ears hurt