Question: Given 0 . 3 0 . 3 0 . 4 P = 0 . 6 0 . 1 0 . 3 0 . 2 0

Given
0.30.30.4
P=0.60.10.3
0.20.70.1
Using the Excel, find the following. Hint: You may want to use the functions MMULT and
MINVERSE. (Alternatively, you can do this in Python. Provide a file with the code and
answers.)
a) P
2
b) P
16
c)(I-P) where I is a 3x3 identity matrix
d) Modify the answer above by making the last column all 1s. Call this matrix A.
e) Find A
-1
.
f) Let b be a (1x3) row vector [001]. Compute bA-1
.
g) Compare the answer to f) to last row of A
-1
. What do you notice?
h) Compare the answer to f) to any row in the answer to b). What do you notice?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!