Using Visual Basics for Applications: Matrix A: 1 2 0 0 4 -1 2 2 0 Assume that t

Question

Using Visual Basics for Applications:

Matrix A:

1 2 0

0 4 -1

2 2 0

Assume that the above matrix A is in Excel with a11 in cell C2. Write a program that:

a. Reads A from Excel

b. Performs "Naive" Gauss elimination on A

c.  Calculates the determinant of A using the method of problem 3. Your code must be applicable to any size of the matrix, i.e., not be det = a(1,1)*a(2,2)*a(3,3) Hint: You can code a sum initializing it with 0 and using a loop. You can code a product by initializing it with 1 and using a loop.

d. Outputs the determinant in Excel cell F3  

Explanation / Answer

Make sure that all words are spelled correctly. Try different keywords. Try more general keywords. Try fewer keywords.

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.