How to perform singular value decomposition using MS Excel?

  • Calculators
  • Thread starter Adel Makram
  • Start date
  • #1
604
13
I have a matrix of data and I want to do SVD using excel, is it possible?
 

Answers and Replies

  • #2
34,959
11,145
You can write a macro in VBA, or look for existing macros. I don't see a practical way to do it with formulas alone.
 
  • #3
604
13
So how to write the code for SVD in excel for mn matrix?
 
  • #4
34,959
11,145
In the same way as in every other programming language. There are tutorials for writing macros in Excel, for VBA syntax, and there are examples of SVD code as well.
 
  • #5
jtbell
Mentor
15,660
3,731
Have you tried a Google search for something like "excel singular value decomposition"? That search turns up results that look promising, although I haven't investigated any of them myself.
 
  • Like
Likes S.G. Janssens
  • #6
604
13
In the same way as in every other programming language. There are tutorials for writing macros in Excel, for VBA syntax, and there are examples of SVD code as well.
I do not know the programming language but I can copy the code and use it according to the problem I have. That is why I created this thread.
 
  • #7
34,959
11,145
So what do you expect, that others do google searches for you when you can do that as well?
 
  • Like
Likes S.G. Janssens
  • #8
604
13
So what do you expect, that others do google searches for you when you can do that as well?
I expect a code. Searching in google is non-specific but asking questions here would be more helpful.
 
  • #9
S.G. Janssens
Science Advisor
Education Advisor
931
706
excel_svd.png


This is what I got. It looks promising. Why don't you try to reproduce the above by performing a similar Google search?
 
  • #10
604
13
View attachment 108457

This is what I got. It looks promising. Why don't you try to reproduce the above by performing a similar Google search?
I did but I didn't find a reproducible code. For example the first link discusses the theoretical background. There is however, a code in the second link but it is only for 3/2 matrix or something. I need the code that can fit for any matrix.
 
  • #11
S.G. Janssens
Science Advisor
Education Advisor
931
706
I did but I didn't find a reproducible code. For example the first link discusses the theoretical background. There is however, a code in the second link but it is only for 3/2 matrix or something. I need the code that can fit for any matrix.
What about the 4th link? It is to a journal article that received quite a few (114, apparently) citations. I checked and the article is available free of charge. Macros seem downloadable as well.

In general you will often have to adapt (research) code that you find online to suit your own specific needs. This is something that requires a bit of practice. I am quite sure that among those links you will find code that either works straight away or only requires minor modifications.
 
  • Like
Likes CalcNerd
  • #12
S.G. Janssens
Science Advisor
Education Advisor
931
706
Another option that I have applied successfully in the past, is to import the relevant Excel sheet in MATLAB and then do whatever linear algebra that you would like. (If you do not have MATLAB, you could try to export the Excel sheet to .CSV format and then use Octave instead.)
 
  • Like
Likes CalcNerd
  • #13
604
13
Another option that I have applied successfully in the past, is to import the relevant Excel sheet in MATLAB and then do whatever linear algebra that you would like. (If you do not have MATLAB, you could try to export the Excel sheet to .CSV format and then use Octave instead.)
What is CSV?
 

Related Threads on How to perform singular value decomposition using MS Excel?

  • Last Post
Replies
3
Views
3K
  • Last Post
Replies
4
Views
2K
  • Last Post
Replies
9
Views
5K
Replies
8
Views
1K
  • Last Post
Replies
10
Views
7K
  • Last Post
Replies
1
Views
2K
  • Last Post
Replies
9
Views
4K
  • Last Post
Replies
3
Views
92K
  • Last Post
Replies
2
Views
5K
Top