[go: up one dir, main page]
Scribd
Upload
51 views3 pages

Lab 2

activity

Uploaded by

delosreyesjennylyn05
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
51 views3 pages

Lab 2

activity

Uploaded by

delosreyesjennylyn05
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

Republic of the Philippines

BATANGAS STATE UNIVERSITY


The National Engineering University
Alangilan Campus
Golden Country Homes, Alangilan Batangas City, Batangas, Philippines 4200
Tel Nos.: (+63 43) 425-0139 local 2121 / 2221
E-mail Address: coe.alangilan@g.batstate-u.edu.ph | Website Address: http://www.batstate-u.edu.ph

College of Engineering – Electrical Engineering Department

ENGG 415 NUMERICAL METHOD AND ANALYSIS


1st SEMESTER AY 2024-2025

LABORATORY ACTIVITY NO. 2


MATRICES AND COMPLEX NUMBERS USING MICROSOFT EXCEL

SUBMITTED BY:
Delos Reyes, Jennylyn
Ebreo, Mark Junoel
Hernandez, Nicole
Macatigbac, Grey Houndz
Pedrezuela, X-el Gabriel
Umali, Craig John

EE-3104

SUBMITTED TO:
Engr. Arvel A. Velasquez

Leading Innovations, Transforming Lives, Building the Nation


Republic of the Philippines
BATANGAS STATE UNIVERSITY
The National Engineering University
Alangilan Campus
Golden Country Homes, Alangilan Batangas City, Batangas, Philippines 4200
Tel Nos.: (+63 43) 425-0139 local 2121 / 2221
E-mail Address: coe.alangilan@g.batstate-u.edu.ph | Website Address: http://www.batstate-u.edu.ph

College of Engineering – Electrical Engineering Department

1. Using Kirchoff’s Law for the circuit shown below, find the value of I 1 , I 2 ,∧I 3 using:
a) Reduced Echelon Form/Gauss elimination(5pts)
b) Gauss-Jordan Elimination(5pts)
c) Jacobi Method(5pts)
d) Gauss-Seidel Method(5pts)
For Microsoft Excel solution of a and b, use the inverse matrix(10pts)
For c and d, perform 5 iterations and find each approximate percent relative error.

Fig.1
2. Using Mesh Analysis for the circuit shown below, find the value of I A , I B∧I C using:
a) Reduced Echelon Form/Gauss elimination(5pts)
b) Gauss-Jordan Elimination(5pts)
c) Jacobi Method(5pts)
d) Gauss-Seidel Method(5pts)
For Microsoft Excel solution of a and b, use the inverse matrix(10pts)
For c and d, perform 5 iterations and find each approximate percent relative error.

Fig. 2
3. Using Nodal Analysis for the circuit shown below, find the value of the current passing
through each resistor using Gaussian Method(10pts)
For Microsoft Excel solution of a and b, use the inverse matrix(10pts)

Leading Innovations, Transforming Lives, Building the Nation


Republic of the Philippines
BATANGAS STATE UNIVERSITY
The National Engineering University
Alangilan Campus
Golden Country Homes, Alangilan Batangas City, Batangas, Philippines 4200
Tel Nos.: (+63 43) 425-0139 local 2121 / 2221
E-mail Address: coe.alangilan@g.batstate-u.edu.ph | Website Address: http://www.batstate-u.edu.ph

College of Engineering – Electrical Engineering Department

Fig.3

Leading Innovations, Transforming Lives, Building the Nation

You might also like