How to perform matrix LU De-composition on Excel?

More Amro Mohamed Elfeki's questions See All

A problem with Excel vba code?

I have a problem with simple Excel vba code below, I just need to perform goal seek for many cell in one sheet (tsheet) and put the answer in another sheet (asheet). Sub compute()...

31 December 2016 3,373 1 View

Is there an explicit expression for the inversion of Pearson CDF or Log-Pearson CDF?

Inversion of CDF

10 November 2013 9,896 3 View

What is a simple way to model 2d flow in an arid urbanized area due to flash floods?

I would like to find out a simple model for solving Saint Vanint equation in 2d. Is there a free software can do this?

31 December 2012 8,875 0 View

How to compare two groups with only two measurements?

Hiiiii everyone! I have an enquiry on statistical analysis. I was looking for many forum and it's still cannot solve my problem. I want to compare means of two groups of data but only with two...

03 March 2021 8,796 3 View

Enhanced Yellow Fluorescent Protein (Aequorea victoria) DNA sequence?

I am on the lookout for the Enhanced Yellow Fluorescent Protein (Aequorea victoria) DNA sequence. Does anyone know where I can find it? Thank you in advance

03 March 2021 3,568 1 View

What kind of fluid could I use for a pitfall trap that also does not invalidate molecular testing?

Hi, I want to start testing pitfall trap to obtain ants samples, but I need to conduct molecular analysis on those insects. So, what kind of fluid can I use? Ethanol expires too early and I need...

03 March 2021 5,978 5 View

What's the best way to measure growth rates in House sparrow chicks from day 2 to day 10?

What's the best way to measure growth rates in House sparrow chicks from day 2 to day 10? Since, the growth curve from day 2 to 10 won't be like the "Logistic curve" it might not follow logistic...

03 March 2021 1,401 3 View

Do we need to write protocol for a second study of a systematic review that has been registered and published?

I have conducted and published a systematic review and meta-analysis research with the topic related to public health and health pomotion (protocol was registed in PROSPERO). Now we want to...

03 March 2021 8,920 3 View

How to increase a model accuracy ?

dear community, my model is based feature extraction from non stationary signals using discrete Wavelet Transform and then using statistical features then machine learning classifiers in order to...

03 March 2021 6,994 5 View

1. What is the impact of having different scales in a survey? and how can we solve this problem before and after data collection (Literature)?

1. What is the impact of having different scales in a survey? and how can we solve this problem before and after data collection (Literature-based reflection)? Thank you for your time and for...

03 March 2021 2,870 3 View

What degree of missing data in a particular case/participant results in Expectation-Maximisation no longer working?

I'm dealing with a mediation model and am using the PROCESS module in SPSS. Due to SPSS and PROCESS being limited in the imputation methods - being unable to handle multiple imputation - the other...

02 March 2021 4,362 1 View

Do I need to do linear regression before running mediation analysis using PROCESS MACRO by Hayes ?

I just wanted to check if I need to run a linear regression separately if I am using PROCESS MACRO to run mediation analysis. Thank you.

02 March 2021 4,359 3 View

Sample dilution for quantitative analysis using ELISA?

If the detection range is in ng/ml but the reference range is in ug/ml for a molecule or protein in serum or plasma .how to dilute and what is the initial volume to be taken for quantitative analysis

02 March 2021 7,670 3 View

Mehdi Heidari

You can find the answer in any of files below:

http://www.aae.wisc.edu/aae526/HMWKS-LABS/MatrixOperations-Excel2007%20(2).pdf

http://educ.jmu.edu/~drakepp/spreadsheet/howto/matrices.pdf

http://www.maths.unp.ac.za/coursework/math134/Math134_info_files/Linear%20Algebra/MatricesInExcel.pdf

Good Luck

Amro Mohamed Elfeki

Thank you very much Mehdi. The files are helpful. However, the L-U Decomposition is not there. Thanks any way , Amro

Peter Slezak

http://digilander.libero.it/foxes/SoftwareDownload.htm

If it is still actual and if you are familiar with excel macros. In above link you can find excel VBA functions/subs which should perform LU decomposition and many others matrix operations in excel.

Hi Peter

This is an interesting site. Very useful for excel users. However, I wounder about the sentence in the beginning:

"Warning for Vista-Excel 2007 users.

This site contains programs for Windows 2000/XP, Excel 2003/XP and VB6.

Sorry, but other systems/versions are not supported."

Does this mean, that the programs does not work on Excel 2007?

Hi Amro,

I'm working with MS Office 2010 (Windows 7) and the functions I was interested in works fine. However I have only experience with Matrix Lite package, which should work also for MACs. Functions/subs from this particular package was not tested, therefore in my VBA project I have to made in few cases some minor modifications of the source code. It seems that many functions in this package are translations from fortran code (from Press et al. Numerical Recipes 2nd ed.), so you can find useful information there.

If you have basic about Excel VBA you will manage that. I have no experience with other packages from this page, so you have to try then.

Thanks Peter, I shall try.

Raoof Mostafazadeh

@Mohamed, @Avneesh,

May you find some useful comments (see the links).

https://www.researchgate.net/post/How_to_perform_matrix_LU_De-composition_on_Excel

https://www.researchgate.net/post/How_to_perform_matrix_LU_De-composition_on_Excel2

Stephen Kirkup

There's a code on the link below

http://www.numerica-methods.com/Excel_VBA/LU.xlsm