data
year | y |
0 | 118 |
4 | 129 |
8 | 134 |
12 | 148 |
20 | 147 |
24 | 151 |
28 | 155 |
32 | 162 |
36 | 166 |
48 | 173 |
52 | 181 |
56 | 185 |
60 | 194 |
64 | 200 |
68 | 213 |
72 | 211 |
76 | 221 |
80 | 219 |
84 | 219 |
Excel regression output
SUMMARY OUTPUT | |||||
Regression Statistics | |||||
Multiple R | 0.98997529 | ||||
R Square | 0.980051075 | ||||
Adjusted R Square | 0.978877609 | ||||
Standard Error | 4.800587539 | ||||
Observations | 19 | ||||
ANOVA | |||||
df | SS | MS | F | Significance F | |
Regression | 1 | 19247.17148 | 19247.17148 | 835.176236 | 6.81647E-16 |
Residual | 17 | 391.7758923 | 23.04564072 | ||
Total | 18 | 19638.94737 | |||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | |
Intercept | 123.1700689 | 2.106172156 | 58.48053234 | 4.81521E-21 | 118.7264341 |
year | 1.196321227 | 0.041396035 | 28.89941584 | 6.81647E-16 | 1.108983228 |
y^= 123.17 + 1.20 year
b)
in year 2020 ,Year = 120
hence
y^= 123.17 + 1.20 *120
= 267.17
c)
280 = 123.17 + 1.20 *Year
Year = 130.692
hence in 2031
0 1 s71 11 12 11 The winning Olympic discus throw is recorded through the 1900's rounded to the n...
11. The discus throw is a sport in which competitors try to throw a metal disk as far as possible. Use the graph showing the winning discus throws from the Olympics to answer the questions that follow. (8 marks) Mens Olympic Discuss Results 60 Winning Distance (m) 40 20 1880 1890 1900 1910 1920 1930 1940 1950 1960 1970 1980 1990 2000 2010 2020 Year a) What general trend can be described from this graph? b) Does the relationship appear...