Singular Value Decomposoition Code

Rasm

Well-known Member
Joined
Feb 9, 2011
Messages
505
I am looking for a piece of VBA code that does a SVD. I have searched the web - but not really found one I can use.
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
Can you explain what you're trying to do in more detail?
 
Upvote 0
I am trying to compute scores - I want to find the principal componet in a set of spectra. So for each observation I may have 700 absorbancies and several hundred observations. So I want to find the optimal number of componets to explain my variance. Later on I will build a prediction model using MLR or PLS. Typical Y values in my matrix when I build the model will be constituents like Moisure, Fat and so on. But initially I just want to focus on the X variables - the 700 absorbancies per observation or sample. I hope this is the type info you were looking for.
 
Last edited:
Upvote 0

Forum statistics

Threads
1,214,952
Messages
6,122,457
Members
449,083
Latest member
Ava19

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top