Quantitative Analysis Assignment

jass
TemplateforQ2.xlsx

template

To
A B Total consumption
From A 20 30 50
B 10 15 25
Total expenditure 30 45
I M (I_M)
(I-M) 1 0 0.2 0.5 0.8 -0.5
0 1 0.3 0.4 -0.3 0.6
(I-M)^-1
Use the minverse function 1.8 1.5
0.9 2.4
(I-M)T^(-1)*D
1.8 1.5 5 12.1
0.9 2.4 2 9.4
**note all numbers are MADE UP!

Sheet2

Sheet3