College Distance Dist Ed 0.5 15 3.5 13 5 17 7 12 0.7 18 0.2 14 1.5 12 0 15 0.7 14 0.1 14 0.4 13 4 15 0.1 12 7 12 1.5 16 0.1 16 0.7 16 2.6 15 0.1 12 0.3 13 0.8 12 0.8 12 0.7 12 0.3 13 1.8 12 0.1 12 3.2 15 3.5 16 0 12 1.5 13 0.7 16 2 15 0.1 15 0.1 16 3.8 12 4 12 4 15 1.2 13 0.5 16 2.5 12 0.5 16 4 13 0.5 15 1.5 16 5 12 0.7 16 0.5 16 1.1 14 4 14 0.8 12 1 12 0.8 13 1.2 16 0 12 2 13 1 12 2 15 2 16 0.1 12 0.5 17 1.5 13 0.8 16 1.5 16 1 15 3 12 5 13 0.4 16 0.1 16 0.7 12 2.2 12 0.3 16 0 12 3.6 12 1 14 0.1 15 0.5 14 0.3 16 0.4 12 1 12 7.5 12 0.5 12 1.8 12 2.5 14 1.7 16 0.5 16 1 12 0.5 15 3 16 3.6 13 5 16 2 12 0.3 12 3 12 1.3 14 0.5 16 3.5 16 2 15 3.2 12 0.7 13 0.5 13

In this exercise, you will use these data to investigate the relationship between the number of completed years of education for young adults and the distance from each student's high school to the nearest four-year college. (Proximity lowers the cost of education, so that students who live closer to a four-year college should, on average. complete more years of higher education.) The following table contains data from a random sample of high school seniors interviewed in 1980 and re-interviewed in 1986. Download the data from the table by clicking the download table icon g . A detailed description of the variables used in the dataset is available here 0 . Use a statistical package of your choice to answer the following questions. Suppose you are interested in estimating the following model ED=0 +1Dist+u Run a regression of years of completed education (ED) on distance to the nearest college (Dist), where Dist is measured in tens of miles. (For example, Dist = 2 means that the distance is 20 miles). John's high school was 37 miles from the nearest college. Predict John's years of completed education using the estimated regression. John's predicted years of education completed is D. (Round your response to two decimal places)