project2_f06

project2_f06 - Math 150 Fall 2006 Excel Assignment 2 due...

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

View Full Document Right Arrow Icon
Math 150 Name(s): Fall 2006 Excel Assignment 2 due Oct 13, 2006 Instructions: 1. Before you start, read the instructions on the Week 7 web page and then work through Excel tutorial 2 2. Fill your answers in the yellow areas, and upload the completed 3. All the answers (except for A,B,C,D,I in question 2 and A,D,I in q need to be Excel formulas. Having the correct numbers there is n we want to see how you calculate those numbers using Excel. 4. We won't start grading assignments until after the grace period h If you submitted your assignment in time (you can check under th you don't need to worry if it shows up as overdue for a couple of By submitting this assignment you confirm that this represents your own work. Submitting someone else's spreadsheet as your own will be treated as cheating. 1. Matrix Operations (12 points) Compute the requested matrix products and inverse 3 1 4 Matrix Sum 5 1 9 5 9 2 6 5 3 2 7 1 Matrix Difference 1 8 8 2 -7 1 8 2 1 2 -1 Matrix Product 18 4 79 57 Matrix Product 15 36 15 7.5 2.5 -6 -56.5 -20.5 48 2. Group Activity 2, Chapter 4 (11 points) A = A+B = B = A-B = b = A*B = B*A = Inverse of A A -1 = Solve Ax = b x =
Background image of page 1

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

View Full DocumentRight Arrow Icon
In this problem, only the last three matrices need to be formulas. For the others, you can just enter numbers. An electronics firm has three production departments that produce three different finished products: copiers, printers and fax machines. The company also has four other departments, payroll, advertising, research, and maintenance, that provide services for the production departments. Some of the service departments also provide services for the other
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This lab report was uploaded on 03/26/2008 for the course MATH 150 taught by Professor Thompson during the Fall '06 term at Iowa State.

Page1 / 12

project2_f06 - Math 150 Fall 2006 Excel Assignment 2 due...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online