ENGINEERING 2304 Computer Programming for Engineers ENGR 2304

ENGINEERING 2304 Computer Programming for Engineers ENGR 2304 -51191 Spring 2015 Week 9

Class Outline • Quiz • Review Homework • Matrix Inverses to Solve Systems of Equations • If command • Practice Exercises • Introduction to Math. CAD

Week 9 Quiz •

“We especially need imagination in science. It is not all mathematics, nor all logic, but it is somewhat beauty and poetry. ” –Maria Montessori

Quotes of the D “Logic is the beginning of wisdom, not the end. ”–Leonard Nimoy

Homework 5 Review

Matrix Inverses • Product of a matrix and its inverse is the identity matrix. • Can be used to solve systems of linear equations. • Find inverse matrices using the MINVERSE Command • =MINVERSE(array)

Excel If Function • A simple logical statement to output values, functions, or printed outputs. • =IF(Logical Test, Value if True, Value if False)

Example 1: Matrix Inverses Solve the following system of equations with matrix inverses in Excel:

Example 2: Matrix Inverses • Solve the following system of equations with matrix inverses in Excel

Example 3: Excel If Statements Create an Excel sheet that will tell if an arbitrary point is above or below the line y=3 x-7.

Example 4: Excel If Statements Create a spreadsheet that will output a letter grade for a series of test scores.

Introduction to Math. CAD https: //www. youtube. com/watch? v=r. Q 6 mz. ENRCb 4 https: //www. youtube. com/watch? v=0 VTlmran. E 8 c