Year	GDP	% Change
1975	4084.4
1976	4311.7	5.57
1977	4511.8	4.64
1978	4760.6	5.51
1979	4912.1	3.18
1980	4900.9	-0.23
1981	5021	2.45
1982	4919.3	-2.03
1983	5132.3	4.33
1984	5505.2	7.27
1985	5717.1	3.85
1986	5912.4	3.42
1987	6113.3	3.4
1988	6368.4	4.17
1989	6591.8	3.51
1990	6707.9	1.76
1991	6676.4	-0.47
1992	6880	3.05
1993	7062.6	2.65
1994	7347.7	4.04
1995	7543.8	2.67
1996	7813.2	3.57
1997	8159.5	4.43
1998	8515.7	4.37
1999	8875.8	4.23

1. A) Compute a 95% confidence interval for the population average of the %Change in GDP. (The data set can be copied and pasted into Excel.)

B) Complete this sentence based on your result for the first question: We are 95% confident that .

C) Many users of statistics will confuse this interval with something else. What mistaken interpretation might they make? Develop an argument from the data to demonstrate they are wrong. D) To use this interval, we assumed that the population distribution of %Change in GDP follows a Normal distribution and that the %Change was stable over this time period. Form a Histogram of the %Change and a Time Series Plot of %Change to test those assumptions. What conclusions do you reach?

E) It would seem natural to do the same steps with GDP values, themselves, in order to estimate an underlying population average of GDP. Show evidence that this will not work.

PLZ Show how this is done on excel