Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
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)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started