Question: A student from SCU obtained some data relating crop yield to the amount of fertiliser used from his father's farm records. The data are given

A student from SCU obtained some data relating crop yield to the amount of fertiliser used from his father's farm records. The data are given in the table below:

Fertiliser (kg/ha)	220	450	250	320	500	250	330	430	240	280	370	400	410	450
Crop Yield (1,000 kg/ha)	36	72	48	51	80	40	55	72	39	45	62	71	79	75

Using EXCEL, estimate the relationship between crop yield and the amount of fertilised used.

(a) Report the regression results and write out the estimated regression line.

(b) Interpret the estimated fertiliser coefficient.

(d) Does fertiliser significantly influence crop yield? Explain.

(e) Find the predicted crop yield if the fertiliser is 550 kg/ha.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

A student from SCU obtained some data relating crop yield to the amount of fertiliser used from his father's farm records. The data are given in the table below: Fertiliser (kg/ha) 220 450 250 320...

A student from UQ obtained some data relating crop yield to the amount of fertiliser used from his father's farm records. The data are given in the table below: Fertiliser (kg/ha) 220 450 250 320 500...

A student obtained some data relating crop yield to the amount of fertiliser used from his father's farm records. The data are given in the table below: Fertiliser 220 450 250 320 500 250 330 430 240...

UNITED GRAIN GROWERS: ENTERPRISE RISK MANAGEMENT AND WEATHER RISK Scott Harrington Greg Niehaus ABSTRACT In August of 1999, Mike McAndless, the risk manager of United Grain Growers (UGG), was...

The Ploughman family owns and operates a 640-acre farm that has been in the family for several generations. The Ploughmans always have had to work hard to make a decent living from the farm and have...

To provide much of the feed for the livestock, John wants to plant at least one acre of corn for each cow in the coming year's herd and at least 0.05 acre of wheat for each hen in the coming year's...

Hello Sir, Could you please assist this project urgently. I have to submit it by sunday. UNITED STATES SECURITIES AND EXCHANGE COMMISSION WASHINGTON, D.C. 20549 FORM 10-K x Annual Report Pursuant to...

For information systems projects and initiatives, what would you expect your involvement to be as a business professional?

17. In your words, describe an example scenario on a project where it would benefit the project manager to apply the concept of emotional intelligence (EQ). Explain why EQ would be beneficial in your...

LIBOR stands for: Multiple Choice London Interest Basis Offered Rate. London International Offered Rate. London Interbank Offered Rate.

A concert promoter is analyzing attendance at the last five years of concerts in a particular city. Below are the actual attendance levels by year. Year Five years ago Four years ago Three years ago...

1. I try to create an image of the message

4. I try to make them feel what I really mean (1 is related to the visionary, 2 to the logical, 3 to action and 4 to the emotional).

4. What is the goal of the others in the network?