1. Draw a scatterplot of your data set. Page 5 2. Calculate the coefficients of a linear equation to predict the yield Y as a function of X. 3. Calculate the correlation coefficient for the paired data values. 4. Set up the framework for an appropriate statistical test to establish if there is a correlation between the amount of the trace element and the yield. Explain how having the scatterplot referred to above and having the value of r in advance will influence the structure of your statistical test. 5. Carry out and state the conclusion of your test on the correlation. 6. Comment on how well the regression equation will perform based on the results above Additive Yield 61 118.35 61.56 118.45 62.11 118.49 62.67 118.59 63.22 118.68 63.78 118.73 64.33 118.82 64.89 118.92 65.44 118.96 66 119.06 66.56 119.15 67.11 119.25 67.67 119.29 68.22 119.39
A study was carried out to determine the influence of a trace element
found in soil on the yield of potato plants grown in that soil, defined as
the weight of potatoes produced at the end of the season. A large field
was divided up into 14 smaller sections for this experiment. For each
section, the experimenter recorded the amount of the trace element
found (in milligrams per metre squared) and the corresponding weight
of the potatoes produced (in kilograms). This information is presented
in the worksheet ‘Dataset5’ in the Excel document. Define X as the
trace element amount and Y as the yield.
1. Draw a scatterplot of your data set.
Page 5
2. Calculate the coefficients of a linear equation to predict the yield
Y as a
3. Calculate the
4. Set up the framework for an appropriate statistical test to establish if there is a correlation between the amount of the trace element and the yield. Explain how having the scatterplot referred
to above and having the value of r in advance will influence the
structure of your statistical test.
5. Carry out and state the conclusion of your test on the correlation.
6. Comment on how well the regression equation will perform based
on the results above
| Additive | Yield |
| 61 | 118.35 |
| 61.56 | 118.45 |
| 62.11 | 118.49 |
| 62.67 | 118.59 |
| 63.22 | 118.68 |
| 63.78 | 118.73 |
| 64.33 | 118.82 |
| 64.89 | 118.92 |
| 65.44 | 118.96 |
| 66 | 119.06 |
| 66.56 | 119.15 |
| 67.11 | 119.25 |
| 67.67 | 119.29 |
| 68.22 | 119.39 |
Step by step
Solved in 7 steps with 7 images
