Converting Variables into T Scores in Excel

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

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

  • @777educated
    @777educated 6 лет назад

    Thank you, I couldn't have done my assignment without your video. You made it easy.

  • @cassieperoulis4881
    @cassieperoulis4881 8 лет назад

    It helps to go through step by step with this information provided in regards to T scores in Excel. I feel like when, or if we have an assignment that deals with finding T scores, I will utilize this video and go backs step-by-step.

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

    Before this course I have never even heard of t-scores and, to be honest, I thought that this was a typo in the title. Now that I know what a t-score is and what it does this video made calculating t-scores much simpiler to understand

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

    Using Excel to covert variables into T Scores makes this process much easier and quicker. The autofill option is great in saving time, which I can imagine is very helpful when calculating many different statistics. I like how Dr. Grande broke down the meaning of both the T scores and the Z scores because I get lost in the meaning of the terms sometimes.

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

    This is really helpful in calculating a series of t-scores. Of course, this can be done by hand but with the creation of the table with mean, SD and such it makes it much quicker and easier. It is interesting that z and t-scores have the same base which ultimately is the z-score.

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

      Alicia Zahn I guess I didn't even realize you could do this by hand. It is easy to do. Having the same base makes them both pretty easy to calculate and understand.

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

      Alicia Zahn I have been doing z-scores by hand and I thought I was going to have to calculate this by hand as well. This video made t-scores sooo much easier

  • @pademida0220
    @pademida0220 4 года назад +1

    Excellent video... very helpful!

  • @stevieporter3399
    @stevieporter3399 8 лет назад

    I'm glad to have this existing reference of how to do these calculations, because at this point it's not something I have memorized.

  • @cardinalgrad11
    @cardinalgrad11 8 лет назад

    I remember using t scores in my undergrad class. However, it has been a while so I'm sure I will be a great reference tool as I work through this course.
    Along with what many other people have noted, they do appear complex, but by following along on excel I feel I have a better grasp of what the score calculates and how to calculate.

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

    I like this video because it brings it back to the basics. Each part of the process was explained, and I need that in these videos. I can actually imagine myself running this test because it is simple, but is very helpful. I like all the shortcuts Excel has, but I would need a master key to remember them all. I would like a video for just that! I guess the one thing that confused me is why you need a z-score for all participants. I thought you would only need it for each test.

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

      Jessie Howard Yes, this was a very straightforward calculation and the tables created make it simple.

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

      Jessie Howard I agree with you. The more basic/broken down Dr. Grande makes concepts, the better I understand them. I think it would helpful to have a video on just the shortcuts as well. Some people may not use Excel as often as others. Therefore, it would be nice to have the shortcuts in a video too.

  • @katiependergast4145
    @katiependergast4145 8 лет назад

    I was able to follow along on my computer, but am definitely going to need to come back to watch the video again when trying to calculate T-scores.

  • @lllschreiber
    @lllschreiber 8 лет назад

    This is still an introduction for T scores for me. I am sure it will all become more clear as we go forward.

  • @sarahburrous7374
    @sarahburrous7374 8 лет назад

    I would like to watch this again while I follow along in Excel with some sample data. It is obvious that T scores are a great way to compare data from different instruments but to really understand, I think I need to do it.

    • @desireeyoung9203
      @desireeyoung9203 8 лет назад

      Sarah, following along by doing it ourselves would probably be very helpful to both of us. Calculating t scores seems a bit more difficult that z scores.

  • @aprilbrooks8672
    @aprilbrooks8672 8 лет назад

    Looking at the T scores can show what scores are more accurate among two studies with different instruments. I found it to be confusing at first but I assume T scores are used when z scores are also present.

  • @amandachaffin6636
    @amandachaffin6636 8 лет назад

    I think it was helpful to learn how to compare z scores and t scores right next to one another. I also do not have much experience with this so it will have to be something I reference back to.

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

    Hi Dr Todd, thanks for sharing the tutorial on the conversion of raw scores to t score for individual participant. If for example, i have 30 participants and each taken 5 different test with different total raw score per test. Is it possible to compare the total for each test using t score ?

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

    Sir I have 4 independent variables. I found the correlation with dependent variables and found the values of each independent variables. Now the hurdle is, I want to give them weightage and then normalize and compute in one score. How can I do it?

  • @tracymarshall-johnson1417
    @tracymarshall-johnson1417 8 лет назад

    I'm certain I will watch this tutorial at least another time. This was actually very complex to me.

  • @dawnzink1747
    @dawnzink1747 8 лет назад

    calculating the t-score seemed more complicated, especially since you need the z-score to get the t-score. I will definitely be reviewing this video again with excel to make sure I get how to do it.