Data Transformation for Skewed Variables Using the LOG10 Function in Excel

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

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

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

    Dear Dr. Grande, somehow I need to normalize skewed distribution and find your video. I thought I mistook you as a different person, the one who did psychological analysis. Finally, I find out that you are the same person. Wow, you are really talented. Also, thanks for this explanation, which is very digestible and absorbable.

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

    nice to know you this is a very brief description of data transformation(log transformation) method i really like it.

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

    After doing this and finding mean and standard deviation... should we find the exponential for both to go back to their original values?

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

    Thanks Dr. Grande!

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

    Thanks Dr. Todd Grande!! why do you add 1 to the difference in the log10? and how do you interprete logaritmic values when analysing relationship between data? thanks

    • @pipertripp
      @pipertripp 2 года назад +1

      He added one so that the minimum value in the data set after reflection would be one. Without adding one, the log10 of zero would blow things up. Note that you can add any constant, it doesn’t have to be one. In this case adding one is mathematically convenient.

  • @liubovpiano9573
    @liubovpiano9573 6 лет назад +1

    How to analyze log 10 scores?

  • @TimSter15
    @TimSter15 4 года назад

    what if u have a fair few 0s in your dataset?

  • @anandthaman
    @anandthaman 6 лет назад

    Sir suppose we ve three groups to compare. And scores of one group need to be transformed. If in that case we can use transformed score along with non transformed score for comparison??

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

    I'm wondering how the transformations under the Levene's test are different or is it just a preview to what will work. It was suggested in the Field book.

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

    wow! didn't know Excel had all these functions available

  • @ReverbProductions
    @ReverbProductions 6 лет назад +1

    Thanks helped a lot

  • @afixedmindset431
    @afixedmindset431 7 лет назад

    Just was I was looking for and thanks for covering the difference between positively and negatively skewed distributions.

    • @DrGrande
      @DrGrande  7 лет назад

      You are welcome - thank you for watching -

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

    what if half my dataset is in the negatives?

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

      In that case, instead of adding one to the max value you would add a constant that would make you smallest value after reflection equal to one. Then when you take the log, you min value will be zero.

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

    Hi,
    Do we need to transform the whole data set or just pick few that is not normally distributed

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

      You must transform the whole data set otherwise you couldn’t really interpret the results in any meaningful way.

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

    Makes a lot of sense, thanks.

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

    Thank you

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

    please next time speak loudly, so we can hear you … thanks