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
=
AB
=
b
=
A*B
=
B*A
=
Inverse of
A
A
1
=
Solve
Ax = b
x
=
This preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentIn 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
This is the end of the preview.
Sign up
to
access the rest of the document.
 Fall '06
 Thompson
 Math, Linear Algebra, Invertible matrix, telephone equipment, office furniture

Click to edit the document details