Question

Year	Population in Millions	GDP in Trillions of US$
2014	318.86	16.29
2011	311.72	15.19
2010	309.35	14.94
2009	306.77	14.54
2008	304.09	14.58
2006	298.38	14.72
2004	292.81	13.95
2003	290.11	13.53
2002	287.63	12.96
2001	284.97	12.71
2000
1999	279.04	12.32
1998	275.85	11.77
1990	249.62	8.91
1989	246.82	8.85
1987	242.29	8.29
1986	240.13	7.94
1985	237.92	7.71
1984	235.82	7.4
1982	231.66	6.49
1981	229.47	6.59
1980		6.5
1979	225.06	6.5
1977	220.24	6.02
1976	218.04	5.73
1975	215.97	5.49
1973	211.91	5.46
1972	209.9	5.25
1964	191.89	3.78
1963	189.24	3.6
1962	186.54	3.42
1961	183.69	3.28
1959	177.83	3.06
1958	174.88	2.92
1957	171.98	2.85
1956	168.9	2.84
1954	163.03	2.61
1953	160.18	2.54
1952	157.55	2.53
1951	154.88	2.4
1950	152.27	2.27
1949	149.19	2
1948	146.63	2.04
1947	144.13	1.96

Above is a CSV file from the file do the following:

(a) Subset the data to include only those from 1947 to 1964.

(b) Fit a linear regression model, M1, to model population as a function of the year using this data from 1947 to 1964.
(c) Predict the population for the missing years 1955 and 1960.
(d) Plot the population versus Year including the predicted values for 1955 and 1960 in the range 1947 to 1964. The predicted values must be annotated (marke

Answer 1

A C C E F G K function of the yearusing this data from 1947 to 1964 (b) Fit a linear regression model, M1, to model population Predict the population for the missing years 1955 and 1960 (c) (d) Plot the population versus Year including the predicted values for 1955 and 1960 in the range 1947 to 1964. The predicted values must be annotated (marked) 2 as a 3 4 5 Year Population in Millions SUMMARY OUTPUT 7 X y 1947 144.13 Linear regression model: y 2.85x-5398.73 1948 146.63 Regression Statistics |Multiple R R Square Adjusted R Square 9 1949 149.19 0.9998 10 0.9997 1950 152.27 11 1951 154.88 0.9997 Year 1955 166.34 12 1952 157.55 Standard Erron 0.2879 Year 1960 180.57 13 160.18 1953 Observations 16 14 163.03 1954 15 1956 168.90 ANOVA 16 df 1957 171.98 SS MS Significance F 17 1958 174.88 Regression 3751.7 3751.7 45262.2 5.66229E-26 18 177,83 1959 Residual 14 1.16043 0.08289 19 15 3752.86 1961 183.69 Total 20 1962 186.54 21 P-value 1963 189.24 Coefficients Stad Error t Stat Lower 95% Upper 95% 22 1964 191.89 Intercept -5398.73 26.16 -206.36 8.7E-26 -5454.84 -5342.62 23 2.85 0.01 212.75 5.7E-26 2.82 2.88 24 X 25 26 Nm n co o

29 Population in Millions Year 30 31 X V Chart Title 1947 144.13 32 1948 146.63 33 220,00 1949 149,19 34 210.00 1950 152.27 35 200.00 1951 154.88 36 190.00 1952 157,55 37 166.34 160.18 1953 38 130.00 1954 163.03 39 170.00 180.57 1955 40 166.34 160.00 41 1956 168.90 150.00 1957 171.98 42 140.00 1958 174.88 43 44 1959 177.83 130.00 1960 180.57 45 120.00 1961 183.69 46 110.00 1962 186.54 47 100.00 48 1963 189.24 1946 1948 1950 1952 1954 1956 1958 1960 1962 1964 1966 191.89 1964 49 Year 50 51 52 Population in Millions