L10_Matrices_Excel

# L10_Matrices_Excel - Challenge 2 Open up the...

This preview shows pages 1–9. Sign up to view the full content.

Click to edit Master subtitle style Challenge 2 Open up the Assignment/Word file “Challenge 2” on Bb and read the challenge statement. Generate Ideas: 1) What are your initial ideas about how this challenge can be accomplished? 2) What background knowledge is needed? 3) What do you know about statistics already?

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Multiple Perspectives Share ideas with the class
Click to edit Master subtitle style MATRICES

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Click to edit Master subtitle style MATRICES Definition A matrix is a set of numbers arranged in a rectangular grid of rows and columns. Basically, a matrix is an easy way of representing a large set of data. Am,n= m = # of rows n = # of columns
Matrices Can Help Us Solve Problems F = 10,000 kg/h 30% Methanol 40% Butanol 30% Ethylene Glycol V1 71.6% MeOH 26.8%BuOH 1.6% EG V2 53.3% MeOH 44.3%BuOH 2.4% EG L2 8.6% MeOH 38.8%BuOH 52.6% EG Find V1, V2, and L2 in kg/h.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Click to edit Master subtitle style Matrix Properties When the numbers of rows equals the number of columns, you have a square matrix: When all the elements of the matrix are zero, you have a zero matrix:
Click to edit Master subtitle style Matrix Properties When all the diagonal elements of a square matrix are 1, and all others are zero, you have the identity matrix , I: A magic square matrix consists of integers arranged so that the sum of each row is equal to the sum of each column. A magic matrix of order 3: I =

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Click to edit Master subtitle style MATRICES (cont’d) In Excel, the following matrix will be entered as shown here:
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 02/27/2009 for the course ES 140 taught by Professor Varies during the Spring '07 term at Vanderbilt.

### Page1 / 18

L10_Matrices_Excel - Challenge 2 Open up the...

This preview shows document pages 1 - 9. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online