Saporito vineyards of Mirandola Italy have been making wine for two hundred years. In 1969 a young wine

maker took over the vineyards and began recording the rainfall (in inches), days of sunlight and grape yields in

hundreds of bushels of grapes produced per year. This wine maker now has 33 years of data and would like to

be able to predict his crop yields based on the previous years weather.

A) Perform a regression analysis of the data in the picture below to determine which variable rainfall or a sunny day is the best predictor of yield. Include both regression lines as your answer.

B) Based off of the data in the picture below, which variable has the greatest influence (slope) on crop yield?

C) Using the data in the picture below, plot the exact regression line over scatter plots of the data for rainfall against crop yield and attach it as an image.

D) Using the data in the picture below, plot the exact regression line over scatter plots of the data for sunny days against crop yield and attach it as an image.

E) Using the data in the picture below, calculate and report the correlation and coefficient of determination. Use these statistics to determine whether we should be use either rainfall or number of sunny days to predict crop yield.

Year Rainfall Sunny Days Grape Harvest 19696.359153906 1970 6.137335482 1971 6.48584309 19726.01923867 19736.064837084 974 5.979711889 1975 6.173532094 1976 6.101562358 977 6.23401839 1978 5.968835422 19795.8553677 9806.038146117 1981 6.272027325 1982 6.220325772 1983 5.817747667 1984 5.976802495 1985 6.099617263 1986 5.806988474 19875.775208512 1988 5.815617284 19895.736820225 1990 5.905222035 19915.708498637 1992 5.599824642 1993 5.669429031 19945.808042073 1995 5.572329697 1996 5.906265896 1997 5.969628145 9985.728200047 19995.530321051 2000 5.860774448 200 5.979431867 300 299 300 297 298 298 297 295 294 294 292 290 290 291 288 287 288 285 283 284 281 280 278 278 277 276 276 276 275 274 272 274 275 480 462 480 451 456 447 458 457 472 446 433 453 472 467 438 447 457 433 427 433 428 445 421 418 428 440 439 445 425 416 435 443