Please help me complete this.

I have been struggling for quite some time, and mainly I need the answer.

Thank you!

A B D E F G H 1 WinterRain HarvestRain 160 Age 31 2 600 3 690 80 4. 502 130 Year 1952 1953 1955 1957 1958 1959 1960 5 420 110 187 30 28 26 25 24 23 6 7 582 485 763 830 8 9 1961 22 10 1962 697 21 20 11 12 1963 1964 608 402 19 13 602 18 Price 7.495 8.0393 7.6858 6.9845 6.7772 8.0757 6.5188 8.4937 7.388 6.7127 7.3094 6.2518 7.7443 6.8398 6.2435 6.3459 7.5883 7.1934 6.2049 6.6367 6.2941 7.292 7.1211 6.2587 7.186 1965 1966 1967 1968 AGST 17.1167 16.7333 17.15 16.1333 16.4167 17.4833 16.4167 17.3333 16.3 15.7167 17.2667 15.3667 16.5333 16.2333 16.2 16.55 16.6667 16.7667 14.9833 17.0667 16.3 16.95 17.65 15.5833 15.8167 14 15 16 France Pop 43183.569 43495.03 44217.857 45152.252 45653.805 46128.638 46583.995 47128.005 48088.673 48798.99 49356.943 49801.821 50254.966 50650.406 51034.413 51470.276 51918.389 52431.647 52894.183 53332.805 53689.61 53955.042 54159.049 54378.362 54602.193 187 290 38 52 155 96 267 86 118 292 244 89 112 158 123 184 819 714 610 575 622 551 17 16 15 14 1969 17 18 19 13 12 11 20 536 10 21 22 23 1970 1971 1972 1973 1974 1975 1976 1977 1978 376 574 9 572 418 171 247 8 7 24 6 821 763 87 51 5 25 26 27 28 29 30 31 Sheet 1 Sheet 2 + A B C D 1 Year Price 2 1952 3 4 1953 1955 1957 5 7.495 8.0393 7.6858 6.9845 6.7772 8.0757 6.5188 8.4937 6 7 1958 1959 1960 8 9 1961 10 1962 7.388 11 1963 12 1964 13 6.7127 7.3094 6.2518 7.7443 6.8398 6.2435 1965 1966 1967 14 15 16 1968 17 1969 1970 18 19 1971 6.3459 7.5883 7.1934 6.2049 6.6367 20 1972 21 22 23 1973 1974 1975 1976 1977 1978 24 6.2941 7.292 7.1211 6.2587 7.186 25 26 27 28 29 30 31 32 33 With this assignment, the goal is to predict the price in 1989. Let us see if the price of 1989 is substantially higher than that of 1961. The data you are given is until 1978. "By Professor Ashenfelter's calculations, the hottest growing season in memory, combined with a very dry harvest, all but guarantee that the 1989 Bordeaux will be stunningly good. Adjusted for age, he predicts, these wines will eventually sell for a substantial premium over the great 1961 vintage". - NY Times Question 1 2 pts We are predicting prices of wines, hence, that should be our dependent variable (if this concept is not clear to you, please go back to the videos). Conduct a correlation analysis to identify two variables with the strongest correlation with Prices. AGST: Average Growing Season Temperature AGST, Age AGST, Population Winter Rain, Age AGST, Harvest Rain Question 2 12 pts Use the variable selection process you have learnt to develop a multiple regression model. There are 5 possible independent variables. Do not consider Year as an independent variable. The Age variable already captures the Year variable. Start with the variable that has the strongest correlation with Price. This will be a simple linear regression. Add another independent variable to this model (now you will have 2 independent variables). If the variables are statistically significant for 95% confidence level (p-values are lower than 0.05), add a third independent variable. All this while, remember that Price continues to be your dependent variable. Perform the above variable selection process until you arrive at a regression model that has the highest R squared value possible with all the variables being statistically significant. Which independent variables does your model have? Hint: Your final model will have 4 independent variables AGST, France Pop, Winter Rain, Harvest Rain Age, Winter Rain, France Pop AGST, Age, Winter Rain, Harvest Rain O Age, France Pop, Winter Rain, Harvest Rain