- #1
Adel Makram
- 635
- 15
I have a matrix of data and I want to do SVD using excel, is it possible?
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 said: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 expect a code. Searching in google is non-specific but asking questions here would be more helpful.mfb said:So what do you expect, that others do google searches for you when you can do that as well?
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.Krylov said: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?
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.Adel Makram said: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 is CSV?Krylov said: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.)
Comma-Separated Values, e.g.:Adel Makram said:What is CSV?
To access the singular value decomposition function in MS Excel, you will need to enable the Analysis ToolPak add-in. This can be done by going to the File menu, selecting Options, then clicking on Add-Ins. From there, you can select Analysis ToolPak and click on the Go button to enable it.
Yes, you can perform singular value decomposition on a matrix in MS Excel. The SVD function in Excel allows you to input a range of cells containing the matrix data. However, the matrix must be a square matrix, with the same number of rows and columns.
Singular value decomposition is used to break down a matrix into its constituent parts in order to perform various calculations and analyses. It is commonly used in data analysis, signal processing, and image processing.
The result of the singular value decomposition in MS Excel is a set of three matrices: U, S, and V. The U matrix represents the left singular vectors, the S matrix contains the singular values, and the V matrix represents the right singular vectors. These matrices can be used for further calculations and analysis.
Yes, it is possible to perform singular value decomposition on large datasets in MS Excel. However, the size of the dataset may impact the performance and speed of the calculation. It is recommended to use specialized software or programming languages for large datasets.