matrices

I have developed a formula which shows customer activity by cohort (each month a new customer "Cohort" comes on stream). The pattern is linear and in each month each customer who is active buys one item. As an example CUstomers in their first year will buy three times Month 1,5, and 9. In Month...

Hi all! Thanks for the help. Stuck with another problem here. Given I have some data points as shown, X, Y and Z. I am supposed to compute the result of matrices with all data points available. In this case, I should be able to generate 5 different sets of results since there are 5 sets of X, Y...

I have been trying for hours to create a function that will find the dot product of two independent columns. I have very limited knowledge in VBA and my professor is no help. This is what I have right now, which is heavily based on what I learned in class. Does anybody have suggestions of what...

I want to create a function in Excel VBA that can do matrices multiplication for multiple matrices (undefined numbers of augments). The following is my code (I use ParamArray in this function), but it returns an error. Could anyone help me debug it? Function MultMMult(ParamArray X() As Variant)...

Hi all, I'm trying to do, essentially, a triple lookup. I've got 14 Matrices, and I want to select one of the matrices, a vertical value from the selected matrix, and a horizontal value from the selected matrix, and get the intersecting value. I've already got down the VLOOKUP/MATCH pair for...

I'm dealing with this problem in the last couple of days. I have formatted with Conditional formatting two color matrices 52x24 cells in two different sheets and both sheets (matrix results) are linked to the first numerical data base sheet. What I want is to generate the third matrix which...

I'm dealing with this problem in the last couple of days. I have formatted with Conditional formatting two color matrices 52x24 cells in two different sheets and both sheets (matrix results) are linked to the first numerical data base sheet. What I want is to generate the third matrix which is a...

Hi All Struggling with an issue that I am sure someone must have faced before, but I can't find an answer when I searched the forum, so hoping someone can help me. Essentially I am trying to convert an OD matrix into another OD matrix, by which I mean I have OD matrices from two disparate...

I built a function that takes a matrix, performs simple linear algebra, and outputs a new matrix with 0's in the bottom left corner. This is great but I need the code to remember the value it multiplied by ("the factor") to get each 0 in the bottom left corner and output each factor later maybe...

Hello! I have to make an 18x18 matrix calculator using excel for my math project. It should be able to solve the determinant, the inverse, the answers if there were a given system of equations, and the L&U of the matrix. I know I could easily do those by using the built-in matrix functions, but...

I'm trying to run a mathematical simulation of an economic model. I'm wondering what is the best structure to solve this problem, or whether I should consider purchasing Matlab instead. (I'm very poor and buying a Matlab program may be out of my budget since I'm not a student or associated with...