Calculators How to perform singular value decomposition using MS Excel?

[Adel Makram]

I have a matrix of data and I want to do SVD using excel, is it possible?

 

[mfb]

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.

 

[Adel Makram]

So how to write the code for SVD in excel for mn matrix?

 

[mfb]

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.

 

[jtbell]

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.

 

[Adel Makram]

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.

 

[mfb]

So what do you expect, that others do google searches for you when you can do that as well?

 

[Adel Makram]

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.

 

[S.G. Janssens]

This is what I got. It looks promising. Why don't you try to reproduce the above by performing a similar Google search?

 

[Adel Makram]

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.

 

[S.G. Janssens]

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.

 

[S.G. Janssens]

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.)

 

[Adel Makram]

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?

 

[jtbell]

What is CSV?

Comma-Separated Values, e.g.:

3.452, 4.693, 7.222, 1.928
4.683, 2.333, 8.123, 4.234

https://en.wikipedia.org/wiki/Comma-separated_values