PLZ HELP MEMEME

Q1. Use the excel sheetprovided to calculate the migration from all Provinces in Canada to Ontario for the year 1990.You have to estimate Province to Province i.e. migration from all Provinces to Ontario using the data provided in the spreadsheet (data for Ex-1).

Province i =the abbreviation of Provinces in Canada |

Actual 25 00 0 20 00 0 15 00 0 1000 0 50 00 0 50 00 10 000 1500 0 20 00 0 25 00 0A B C D E F G Table-1 Provinces in Canada to Ontario 2 PROVINCE Pi dij Pi/dij Predicted Actual Residual% AB 2545553 1705 1492.99 1463.1331 6591 77.8 4 BC 3282051 2110 1555.47 1524.3649 8991 83.0 MB 1091942 941 1160.41 1137.1978 4029 71.8 6 NB 723900 661 1095.16 1073.2557 3963 72.9 NF 568474 1280 444.12 435.23791 4795 90.9 8 NT 85446 2650 32.24 31.598898 766 95.9 CO NS 899942 787 1143.51 1120.6393 5894 81.0 10 ON 10084885 0 0.00 0 0 #DIV/O! 11 PE 129765 809 160.40 157.1937 333 52.8 12 PQ 6895963 315 21891.95 21454.107 19814 -8.3 13 SK 988928 1341 737.46 722.70652 1898 61.9 14 15 Note: K= 0.98 16