Quantitative Analysis Assignment
jass
TemplateforQ2.xlsxtemplate
| 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! |
