Finding Determinant of a Matrix Using Excel

Поделиться
HTML-код
  • Опубликовано: 15 сен 2024
  • This video shows how to find the determinant of a matrix using microsoft excel.

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

  • @saskiatabrett4464
    @saskiatabrett4464 3 года назад +1

    Very helpful video! I'm looking to find the determinant to calculate eigenvalues so how do you use excel to do this when you have unknowns (lambda) in your matrix.

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

      I would use wxmaxima for that. Excel wouldn’t be good for that.

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

    Hi Sir, how about determinants with unknown one variable in excel. Thanks

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

    Thank u so much sir

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

    very useful

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

    But what if I dont have the same amount of columns and rows ? I have four columns and three rows, but it says #VALUE!

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

      You can only take the determinant of a matrix with the same number of rows and columns. It has to be a square matrix.

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

      @@crowsmathclass Yeah, I realised, but my professor has it like rectangle 6 rows and 7 columns and it works for him and he wants us to do it too, but it doesnt work for me. Could it be because he is using old excel ? I think it is 2007

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

      @@stefanozorak3909 I just tried it in Excel 2007. It did not work. I also pulled up the help file and it says it has to be a square matrix. I don't know what he is doing. If you find out please reply and let me know. I'm curious.

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

      @@crowsmathclass Okay, Ill let you know. But it isnt like 100% that he is using excel 2007, but it is one of older excels

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

      @@crowsmathclass It was alright, I am just dumb, I had the wrong number there, so everything is okay except me 😃😃