Correlation matrix with significance levels in MS Excel

Sdílet
Vložit
  • čas přidán 11. 09. 2024
  • Hello Researchers,
    This video tells how to make a correlation matrix in MS Excel with significance levels or *** values. It is very important when we present the correlation matrix in our research paper.
    For similar updates to make your research better, visit my blog
    learningeconome...

Komentáře • 9

  • @clintret5591
    @clintret5591 Před 2 lety

    the last formula was a bit complicated but it worked in the end,very helpful video,thank you

  • @farzanashamim9994
    @farzanashamim9994 Před 4 lety +3

    why you take the degree of freedom as 24?

  • @drmrsnidhisharmavishwakarm7980

    Please teach, that how to calculate p value and significancy in simple steps ,,for a freshure research scholar.

  • @chendong2197
    @chendong2197 Před 4 lety

    How to calculate the false discovery rate?

  • @zoharism
    @zoharism Před 5 lety

    How many stars do .407 has ?

  • @zenapsgas
    @zenapsgas Před 5 lety

    When calculating the p-value I got on several occasions #NUM!. What should I do?

    • @zenapsgas
      @zenapsgas Před 5 lety

      I happens when I get a negative t-test value

    • @nsharkasi
      @nsharkasi Před 5 lety

      Yes, it happens with negative values, I suggest you use ABS function to get rid of negatives, anyway, the negative sign is just an indication of the direction of the relationship not its strength, good luck.

    • @zenapsgas
      @zenapsgas Před 5 lety

      @@nsharkasi Thank you