L10_Matrices_Excel

L10_Matrices_Excel - Challenge 2 Open up the...

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

View Full Document Right Arrow Icon
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?
Background image of page 1

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

View Full DocumentRight Arrow Icon
Multiple Perspectives Share ideas with the class
Background image of page 2
Click to edit Master subtitle style MATRICES
Background image of page 3

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

View Full DocumentRight Arrow Icon
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
Background image of page 4
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.
Background image of page 5

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

View Full DocumentRight Arrow Icon
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:
Background image of page 6
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 =
Background image of page 7

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

View Full DocumentRight Arrow Icon
Click to edit Master subtitle style MATRICES (cont’d) In Excel, the following matrix will be entered as shown here:
Background image of page 8
Image of page 9
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 Right Arrow Icon
Ask a homework question - tutors are online