You are a manager at a farm. You are considering adding soy beans to your crop portfolio. From

your research, you learnt that the yield is affected by water and temperature. You obtained the

data from neighboring farms. The data shows the yield per acre, inches of rainfall, and average

high temperature. The data was gathered from several years and locations.

The data is in Table named Problem 3 in the accompanying Excel file named Final Exam.

Regress crop yield on the other two variables and answer the following questions.

a. Coefficient of independent variables in the regression output.

b. If the rainfall is expected to be 17 inches and the expected average temperature is 87 degrees,

what is the expected yield per acre?

Rain Fall inches Fertilizer Lb/acre Yield Bushels/ acre

15 75 110

12 55 105

22 85 115

6 90 110

19 65 110

17 60 105

13 60 105

24 70 115

24 85 113

16 70 110

14 65 110

23 60 110

18 50 105

21 80 115