country	year	rgdpl	POP	ki
Botswana	1960	984.3116	480	3.482408
Botswana	1961	1018.014	491.88	4.339257
Botswana	1962	1049.243	505	5.333317
Botswana	1963	1053.606	519.15	6.016065
Botswana	1964	1062.047	533.96	7.663121
Botswana	1965	1020.458	549.2	2.577237
Botswana	1966	973.5242	563.17	10.37753
Botswana	1967	1139.286	579.12	11.70728
Botswana	1968	1221.55	596.85	16.50332
Botswana	1969	1297.397	616.19	9.049344
Botswana	1970	1207.824	637	23.99697
Botswana	1971	1323.14	659.13	29.09086
Botswana	1972	1641.779	682.48	30.48924
Botswana	1973	1950.797	706.96	30.9638
Botswana	1974	2207.16	732.48	26.87997
Botswana	1975	2229.864	759	22.55982
Botswana	1976	2593.487	786.15	18.0493
Botswana	1977	2557.311	814.39	13.08657
Botswana	1978	2960.434	843.76	14.93359
Botswana	1979	3184.622	874.3	16.37459
Botswana	1980	3461.803	906	18.78125
Botswana	1981	3636.079	938.84	18.10183
Botswana	1982	3492.605	972.75	19.07573
Botswana	1983	3800.606	1007.73	14.37425
Botswana	1984	3924.752	1043.83	16.34493
Botswana	1985	4137.895	1081	14.1351
Cameroon	1960	1692.409	5296	2.956582
Cameroon	1961	1681.223	5403.23	2.996567
Cameroon	1962	1692.189	5515.16	3.071255
Cameroon	1963	1710.738	5632.07	3.124573
Cameroon	1964	1729.104	5754.26	3.297515
Cameroon	1965	1709.148	5882	4.518784
Cameroon	1966	1720.102	6015.59	5.296232
Cameroon	1967	1487.611	6155.3	5.374645
Cameroon	1968	1567.357	6301.42	5.037656
Cameroon	1969	1598.869	6454.23	4.594352
Cameroon	1970	1589.956	6614	5.965623
Cameroon	1971	1628.857	6780.14	6.937342
Cameroon	1972	1601.494	6954.19	7.381062
Cameroon	1973	1610.245	7136.52	7.624012
Cameroon	1974	1742.312	7327.4	6.29774
Cameroon	1975	1911.59	7527	6.540028
Cameroon	1976	1752.465	7735.55	6.436216
Cameroon	1977	1950.09	7953.3	7.71777
Cameroon	1978	2223.451	8179.7	9.733576
Cameroon	1979	2317.739	8413.8	8.689544
Cameroon	1980	2124.634	8655	10.19549
Cameroon	1981	2392.074	8903.44	12.86581
Cameroon	1982	2549.484	9159.19	11.27118
Cameroon	1983	2593.816	9422.19	11.72822
Cameroon	1984	2670.553	9692.44	12.04863
Cameroon	1985	2783.054	9970	12.5391
Japan	1960	4656.864	93530.4	22.62415
Japan	1961	5187.767	94374.32	25.69435
Japan	1962	5585.703	95257.99	25.21863
Japan	1963	6009.187	96232.12	26.10462
Japan	1964	6631.088	97240.05	27.31304
Japan	1965	6916.752	98290.72	26.72749
Japan	1966	7583.944	99192.28	27.40618
Japan	1967	8358.318	100121.7	29.89754
Japan	1968	9410.747	100455.7	32.01023
Japan	1969	10356.88	102554	33.29419
Japan	1970	11396.21	103720	35.94845
Japan	1971	11792.16	104750	34.65837
Japan	1972	12620.24	106180	35.1784
Japan	1973	13327.28	108660	36.21386
Japan	1974	12957.97	110160	34.50868
Japan	1975	13148.15	111520	31.71411
Japan	1976	13523.47	112770	31.70728
Japan	1977	13979.59	113880	31.40959
Japan	1978	14588.36	114920	31.94297
Japan	1979	15256.12	115880	32.12303
Japan	1980	15631.18	116800	31.23327
Japan	1981	15967.5	117650	31.06157
Japan	1982	16339.46	118450	30.07938
Japan	1983	16575.19	119260	28.80843
Japan	1984	17114.52	120020	29.13467
Japan	1985	17778.8	120750	29.63402
Korea, Republic of	1960	1570.89	25252.07	8.207804
Korea, Republic of	1961	1611.175	25981.72	9.843827
Korea, Republic of	1962	1606.535	26700.36	9.40888
Korea, Republic of	1963	1722.497	27410.38	17.81461
Korea, Republic of	1964	1820.333	28114.2	12.3595
Korea, Republic of	1965	1869.429	28814.2	12.1203
Korea, Republic of	1966	2060.516	29508.79	18.79753
Korea, Republic of	1967	2126.863	30196.36	20.25207
Korea, Republic of	1968	2328.69	30879.32	24.52575
Korea, Republic of	1969	2614.996	31560.06	22.3968
Korea, Republic of	1970	2776.947	32241	20.26637
Korea, Republic of	1971	2957.23	32883	20.8767
Korea, Republic of	1972	3033.921	33505	18.49161
Korea, Republic of	1973	3361.22	34103	22.14143
Korea, Republic of	1974	3558.874	34692	24.69092
Korea, Republic of	1975	3719.545	35281	23.49724
Korea, Republic of	1976	4076.701	35849	25.36351
Korea, Republic of	1977	4431.816	36412	28.94674
Korea, Republic of	1978	4769.685	36969	31.78224
Korea, Republic of	1979	5048.227	37534	34.15925
Korea, Republic of	1980	4829.523	38124	29.14444
Korea, Republic of	1981	5058.015	38723	28.88777
Korea, Republic of	1982	5351.029	39326	29.57866
Korea, Republic of	1983	5847.334	39910	30.7597
Korea, Republic of	1984	6263.962	40406	31.77293
Korea, Republic of	1985	6600.582	40806	31.03401
Austria	1984	16389.72	7552.2	24.64137
Austria	1985	16747.15	7559.2	24.71908
Belgium	1960	7758.738	9106.984	24.14861
Belgium	1961	8141.084	9153.922	26.17956
Belgium	1962	8538.044	9205.853	25.83223
Belgium	1963	8875.386	9270.768	24.79223
Belgium	1964	9452.898	9354.657	27.81196
Belgium	1965	9713.653	9435.55	27.21469
Belgium	1966	9981.582	9495.471	28.22797
Belgium	1967	10300.94	9544.407	27.40651
Belgium	1968	10671.94	9577.363	26.51815
Belgium	1969	11376.72	9600.333	27.31781
Belgium	1970	12051.26	9625.3	27.66675
Belgium	1971	12427.8	9660.3	26.2259
Belgium	1972	13006.74	9696.2	24.97084
Belgium	1973	13776.05	9725.2	25.81656
Belgium	1974	14339.05	9755.1	27.16805
Belgium	1975	14028.3	9782.1	24.03391
Belgium	1976	14813.78	9798.1	24.56279
Belgium	1977	14874.35	9809.1	24.28821
Belgium	1978	15259.47	9817	23.90687
Belgium	1979	15588.73	9824	23.24238
Belgium	1980	16302.76	9834	23.87735
Belgium	1981	16199.59	9841	20.80007
Belgium	1982	16224.88	9849	19.60081
Belgium	1983	16234.91	9854	18.17081
Belgium	1984	16669.59	9855	19.2838
Belgium	1985	16986.9	9857	19.04143
Denmark	1960	10917.12	4581	24.31299
Denmark	1961	11548.67	4610	23.88295
Denmark	1962	12139.6	4647	24.97784
Denmark	1963	12094.7	4684	22.38947
Denmark	1964	13170.39	4720	26.2348
Denmark	1965	13654.01	4758	27.11174
Denmark	1966	13936.68	4798	26.14528
Denmark	1967	14311.7	4839	25.80963
Denmark	1968	14750.57	4867	25.98807
Denmark	1969	15648.05	4891	27.95723
Denmark	1970	15910.64	4929	27.45022
Denmark	1971	16188.87	4963	26.90432
Denmark	1972	16859.51	4992	28.4106
Denmark	1973	17377.96	5022	29.36894
Denmark	1974	16984.93	5045	26.6698
Denmark	1975	16563.58	5060	23.33211
Denmark	1976	17666.78	5073	26.61351
Denmark	1977	17773.18	5088	25.14366
Denmark	1978	18000.31	5104	24.2139
Denmark	1979	18505.05	5117	23.99429
Denmark	1980	18281.66	5123	20.70529
Denmark	1981	17811.21	5122	16.971
Denmark	1982	18340.21	5118	18.07636
Denmark	1983	18685.78	5114	18.06532
Denmark	1984	19429.76	5112	20.45541
Denmark	1985	20162.86	5114	22.0588
Argentina	1960	7395.083	20616	19.44015
Argentina	1961	7582.229	20995.87	20.41894
Argentina	1962	7479.627	21341.9	18.56667
Argentina	1963	7066.403	21665.36	15.92432
Argentina	1964	7556.724	21976.2	18.85428
Argentina	1965	8239.236	22283	17.70531
Argentina	1966	8087.588	22592.99	17.13576
Argentina	1967	8217.758	22912.03	17.26429
Argentina	1968	8495.036	23244.67	17.91429
Argentina	1969	9132.553	23594.05	20.18845
Argentina	1970	9226.956	23962	20.11397
Argentina	1971	9580.01	24370.64	21.13018
Argentina	1972	9548.914	24787.78	21.05424
Argentina	1973	9700.149	25208.78	19.42197
Argentina	1974	10118.82	25630.04	18.51515
Argentina	1975	9895.843	26049	18.96163
Argentina	1976	9560.488	26462.55	20.66153
Argentina	1977	10008.49	26866.96	23.50176
Argentina	1978	9511.982	27267.76	20.48543
Argentina	1979	10316.14	27674.78	20.51122
Argentina	1980	10556.06	28094	21.34671
Argentina	1981	9897.95	28522.65	19.06573
Argentina	1982	8933.548	28959.03	16.65635
Argentina	1983	9113.786	29402.47	16.14495
Argentina	1984	9275.038	29851.73	14.97948
Argentina	1985	8655.427	30305	13.58154
Bolivia	1960	2324.248	3351	11.91708
Bolivia	1961	2374.22	3425.97	9.23677
Bolivia	1962	2346.461	3502.96	15.9724
Bolivia	1963	2479.988	3582.14	13.42265
Bolivia	1964	2532.677	3663.76	14.01398
Bolivia	1965	2670.596	3748	11.96347
Bolivia	1966	2772.379	3834.86	11.70919
Bolivia	1967	2901.142	3924.28	10.26365
Bolivia	1968	2491.994	4016.62	11.96347
Bolivia	1969	2519.891	4112.43	11.34931
Bolivia	1970	2481.942	4212	10.94718
Bolivia	1971	2532.01	4315.09	11.62589
Bolivia	1972	2584.576	4421.46	13.60585
Bolivia	1973	2739.448	4530.99	11.0938
Bolivia	1974	2832.671	4643.6	10.38584
Bolivia	1975	2891.045	4759	14.21677
Bolivia	1976	3033.339	4877.21	11.95319
Bolivia	1977	3089.495	4998.77	11.79453
Bolivia	1978	3128.05	5121.18	11.47918
Bolivia	1979	3126.165	5240.63	9.689591
Bolivia	1980	3045.875	5355	7.392879
Bolivia	1981	3012.434	5464.83	7.208559
Bolivia	1982	2869.104	5569.81	5.392063
Bolivia	1983	2684.234	5673.26	4.957829
Bolivia	1984	2648.556	5780.48	5.296774
Bolivia	1985	2541.741	5895	6.181451

W AutoSave @ Off Assignment Three . Saved to this PC Search (Alt+Q) jockey watkins JW X File Home Insert Draw Design Layout References Mailings Review View Help Comments Share G Times New Roman ( ~ 12 ~ A" A Aa~ A Find Normal No Spacing Heading 1 c Replace Paste B I U ~ ab x x A LA. EE Dictate Editor Select Undo Clipboard Font Paragraph Styles Editing Voice Editor Using Assignment III data set, answer the following using excel: 1. Generate and show the results for the best fit model (regression). (20 points) 2. Generate and show the specific regression form. (10 points) . Explain any dummy variables created. (15 points) 4. Explain any time variables created. (15 points) 5. Discuss the significance of all variables. (20 points) 6. Plot and briefly discuss the residual. (20 points Variables in the file are: RDPL= per capita income POP= population KI= capital formation (investment) Source: World Bank Development Indicators 2020. Instructions (failing to follow the instructions will cost you points): 1. Be concise, factual, and deliberate with your answers. 2. Just need the output table in word (no data) 3. 1 question per page and number the pages. 4. Write your name on all pages provided Good luck Dr. Fadi Fawaz Page 1 of 1 165 words DO Text Predictions: On Accessibility: Good to go [ Focus + 100% w X 10:29 PM () O 10/6/2022Using Assignment III data set, answer the following using excel: 1. Generate and show the results for the best fit model (regression). (20 points) 2. Generate and show the specific regression form. (10 points) 3. Explain any dummy variables created. (15 points) 4. Explain any time variables created. (15 points) 5. Discuss the significance of all variables. (20 points) 6. Plot and briefly discuss the residual. (20 points)