Constructing a Variance Covariance Matrix in Excel

Поділитися
Вставка
  • Опубліковано 2 жов 2024
  • This video shows you how to easily compute a sample variance/covariance matrix in Excel.
    More videos at facpub.stjohns...

КОМЕНТАРІ • 11

  • @richaghevarghese9974
    @richaghevarghese9974 2 роки тому +2

    thank you, Ronald!! great video explanation

  • @alderm.contreras5521
    @alderm.contreras5521 5 днів тому

    Thank you so much, sir.

  • @drew1298
    @drew1298 7 місяців тому

    Great video! It helped me remember material from class a few years ago. I just started my CFA 1 prep. Do you have any help on how to interpret the data itself; what is it really telling the analyst aside from which assets have more/less correlated movement?

  • @ryanyusyuen3147
    @ryanyusyuen3147 Рік тому

    Hi Ronald, thanks for the explanation. As from my understand we can actually compute the covariance using the formula = correlation(a,b) * std deviation A * std deviation B. But I realise that the output of covariance is significantly different from the covariance output of the data analysis in excel. Can I know which one should I refer to?

  • @zarpasuave
    @zarpasuave Рік тому

    Thank you so much for the video!!!!! Just a question, what is the reasoning behind the number for the sample? Amazing video

    • @RonaldMoy
      @RonaldMoy  Рік тому

      It's a statistics thing that you lose a degree of freedom when calculating the mean. For those of us who are not statisticians, it doesn't seem all that meaningful.

    • @zarpasuave
      @zarpasuave Рік тому

      @@RonaldMoy oh yeah degrees of freedom. It’s been a while since I did a task like this so I forgot. Thanks for the prompt reply! :D

  • @rushb3161
    @rushb3161 Рік тому

    thank you so much !

  • @samslauenwhite2498
    @samslauenwhite2498 Рік тому

    how did you calculate expected return

  • @fnine4202
    @fnine4202 2 роки тому

    Thank you!