Hello Sir! Your videos are really helpful. When you will upload the other episodes here?
@rossl5908Ай бұрын
What if I had two columns of consumer age and another row of the purchase amount, and I wanted to see if there was a correlation between the two, which t-test would I use
@JimGrange.Ай бұрын
You would use the =CORREL(range1, range2) function, where range1 is your ages and range2 is your purchase amount. This returns a pearson's r value (between -1 and 1)
@rossl5908Ай бұрын
@JimGrange. Thanks for that Jim, also how would I go about getting a sample of age ranges from my mass of data so I can do another T-test ? I can't seem to find the answer online
@JimGrange.Ай бұрын
@@rossl5908 Sorry I'm not sure what you mean?
@SumitSanyal-cf7liАй бұрын
Thank you so much Sir! I have an interview in 40 mins. I always gets confused while explaining t-test. best explanation. Thank you!!
@JimGrange.Ай бұрын
Good luck in the interview - let us know how it goes!
@ofirshorshy82812 ай бұрын
Thank you this is so much more clear than the mess my lecturer left me with!!
@redblock70812 ай бұрын
Thank you from the University of Cape Town!
@MatchaCocoaDog3 ай бұрын
Working on my data analysis now and I already calculated the mean for 2 groups I want to compare but excel tells me I can't just select the calculated mean. So we can only select a list of values from which it will calculate the mean?
@JimGrange.3 ай бұрын
Correct - You cannot do a t-test just between two mean values. You need the individual data points
@kyledunlap40423 ай бұрын
Very helpful video. Thank you for taking the time to post it and make it public.
@JimGrange.3 ай бұрын
My pleasure! Thanks for your feedback
@love145143 ай бұрын
Does the same explanation apply to a moderated regression analysis ? Let's say we get all coefficients as significant / moderator is dummy coded 1 for women and 0 for men. If we have a significant negative coefficient for the interaction term, we could say there is a decrease in Y as X increases, but this decrease is stronger for the women's group? How can we better explain the interaction effect when reporting results in a journal? The effect of X on Y is stronger in women? Do we report the difference in numbers? Could you provide an example of how to formally report a moderated regression with a dummy variable?
@JimGrange.3 ай бұрын
Yes, a moderated regression is the same as an interaction. ANOVA is basically regression in disguise.
@farookjahoor49773 ай бұрын
For a now retired but still active biomedical scientist this is the best explanation I've ever seen of main effects and interaction
@JimGrange.3 ай бұрын
High praise indeed! Thank you so much :)
@Merluza9994 ай бұрын
best video on the subject
@besongnyenti43354 ай бұрын
Thanks so much
@JimGrange.4 ай бұрын
Any time!
@nickgarnett41745 ай бұрын
This new series is awesome!! So helpful and easy to follow thanks Dr Grange
@kamilas77375 ай бұрын
Excellent video 🌟❤️
@JimGrange.5 ай бұрын
Ahhhh thanks so much, @kamilas7737! Is there anything else you'd like to see explained in a tutorial video?
@beginnersbachelorskitchen28025 ай бұрын
Thanks a million
@JimGrange.5 ай бұрын
My absolute pleasure. Drop a comment if there's something else you'd like to see a video on.
@cupcaketv56735 ай бұрын
Thank you so much for this! Just one thing regarding the interaction effect. When I saw a few graphs showing two variables that cross each other while both variables had the same level of gradient, I at first thought there was no interaction effect. Since yes, one variable rises while the other one falls, but both had the same level of gradient. But there is still an interaction effect, as I found out. So I personally find it easier to memorize that there's always an interaction effect as long as the two variables aren't parallel.
@JimGrange.5 ай бұрын
That's a great way of thinking about it!
@cupcaketv56735 ай бұрын
@@JimGrange. Thank you :) it's good to have this method confirmed by an expert haha
@JimGrange.5 ай бұрын
You can download the free worksheet to accompany the video here: osf.io/ym84w/. Enjoy!
@user-rn5ts3of2q5 ай бұрын
Thank you... that is useful
@JimGrange.5 ай бұрын
Glad it was helpful!
@nickgarnett41745 ай бұрын
Really helpful video! Thanks Dr Grange ✊
@JimGrange.5 ай бұрын
My pleasure!
@adrianlove89955 ай бұрын
fantastic - great help!
@JimGrange.5 ай бұрын
Glad you found it of use. Anything else you would like help with in Excel? I am making more videos!
@adrianlove89955 ай бұрын
@@JimGrange. perhaps the tests for the assumptions (Levenes etc). There are other videos on them, of course, but you explain things very clearly.
@lawsen37197 ай бұрын
Been stuck on this in 2 days, this video cleared everything up. Thank you Jim!
@JimGrange.6 ай бұрын
Absolute pleasure!
@cloudymatcha7 ай бұрын
this helped me so much!! thank you
@vatsk7 ай бұрын
Very well explained i would imagne the math across multiple dimensions might be a bit more complex
@rachaelberglund72219 ай бұрын
The easiest to understand explanation of all the different videos i have looked at. Perfect! Thank you!
@beccstah779 ай бұрын
why is there no sound?
@JimGrange.9 ай бұрын
There is sound.
@dougriley9710 ай бұрын
This is the best explanation I've found to describe a t test. Thank you!
@sorlos10 ай бұрын
SUPER USEFUL!!!
@laxmanegalitarian8581 Жыл бұрын
Just about 5k views on such an amazing content? Sad😢!! Well, Thank you so so much!!
@gazelleevemontalvo758 Жыл бұрын
How do i find the r and t value?
@aqsakhan1266 Жыл бұрын
Amazingly comprehendible
@ziyuyu3974 Жыл бұрын
My lecturer would not stop going on tangents and then pausing only to attempt three more times to explain what these effects are. My test is tomorrow, you are a life saver. Thank you!
@JimGrange.5 ай бұрын
How did the test go?
@user-wj9ef1kv4m Жыл бұрын
How can I order this product?
@user-xu4ln9be8r Жыл бұрын
best explanation on this topic .Thank you.
@linhnguyenthuy7055 Жыл бұрын
Thank you very much! Your instruction is straight forward thus understandable, that helps me to solve my problem.
@liulim3478 Жыл бұрын
Clear explanation. This helps me a lot! Thank you~~
@nazmulislamsumon9259 Жыл бұрын
Thank you so much
@ghostpokemon111 Жыл бұрын
This should count as humanitarian service. Thank you sir!
@bigsam7320 Жыл бұрын
still relevant and very helpful, thank you
@getnetyirga2721 Жыл бұрын
Wow great video. Thank You Dear!
@sabrinawilson6469 Жыл бұрын
I just wanted to say thank you so much. I was struggling with the university tutorials when it came to moving the variables across. They never said to make sure it was in the right order inline with the levels. You made it so simple! Thank you again.
@jahanbakhshgolzy2517 Жыл бұрын
Thank YOU for the VERY clear video!
@joefra5574 Жыл бұрын
great vid. thank you
@opeyemialabi4572 Жыл бұрын
Great explanation. Thank you.
@sjsphotog Жыл бұрын
Thank you. I hink you only forgot to mention that if they will eventually INTERSECT on one end of the lines ( which in this case yes they will intersect on the upper left) meaning if we used a different amount of caffeine in the pill or had them skeep deprived less than 1 hour. No intersection = no interaction.
@joanndaugherty8737 Жыл бұрын
Great tutorial--easy to follow, brief, and still relevant for later version of MS Word.
@tonypowell1167 Жыл бұрын
Nice examples. Thanks.
@leonardovalentino2334 Жыл бұрын
I got minus, i want it positive, how?
@JimGrange.5 ай бұрын
You can just ignore the sign. It's negative because one of your conditions is lower than the other, and you likely entered that lower condition as the first condition in the t-test. It doesn't change the interpretation of the t-test.
@hkfatimah8795 Жыл бұрын
How to say that it's significant at 0.05 level??
@texaspolygraph Жыл бұрын
Thank you so much Jim. That really made it clear. You have a superb way of explaining things.
@trnmanood8099 Жыл бұрын
Hi sir, like to ask about the problem I have. I have this 5 person having training records from day 1 and day 8 I would like to see what should I use?