Yield Fetilizer Water 201 100 1000 325 200 1000 124 300 1000 129 400 1000 344 500 1000 193 100 2000 369 200 2000 210 300 2000 306 400 2000 297 500 2000 339 100 3000 334 200 3000 273 300 3000 347 400...

Yield	Fetilizer	Water
201	100	1000
325	200	1000
124	300	1000
129	400	1000
344	500	1000
193	100	2000
369	200	2000
210	300	2000
306	400	2000
297	500	2000
339	100	3000
334	200	3000
273	300	3000
347	400	3000
331	500	3000
221	100	4000
396	200	4000
304	300	4000
381	400	4000
316	500	4000
286	100	5000
293	200	5000
355	300	5000
441	400	5000
321	500	5000
377	100	6000
392	200	6000
361	300	6000
432	400	6000
464	500	6000

above is the excel data. please solve the excel part with formulas and explanation, thanks

Extracted text: The agronomist believed that the amount of rainfall as well as the amount of fertilizer used would affect the crop yield. She did the experiment in the following way. Thirty greenhouses were rented. In each, the amount of fertilizer and the amount of water were varied. At the end of the growing season, the amount of corn was recorded. Use a = 0.05 a) Determine the sample regression line and interpret the coefficients. b) Do these data allow us to infer that there is a linear relationship between the amount of fertilizer and the crop yield? c) Do these data allow us to infer that there is a linear relationship between the amount of water and the crop yield? d) What can you say about the fit of the multiple regression model? e) Is it reasonable to believe that the error variable is normally distributed with constant variance (Support your answer)?