Mod2 project
xlsx
keyboard_arrow_up
School
Middlesex Community College *
*We aren’t endorsed by this school
Course
106
Subject
Mathematics
Date
Apr 3, 2024
Type
xlsx
Pages
2
Uploaded by ChancellorDangerZebra31
MATH106 - Statistics 1
Mod2 Project
Page 1
Grade:
Year
1912
78.72
1914
82.47
Put your scatterplot here. 1916
84
1918
86.12
1920
88.62
1922
94.48
1924
98.23
1926
95.9
1928
99.48
1930
100.448
1932
104.144
1934
104.863
1936
109.069
1938
117.2
1940
114.277
1942
114.31
1) What is the equation for the line of best fit?
y= -2213.8 +1.1995x
1944
114.625
1946
114.82
2) What is the coefficient of determination? 0.96
1948
119.814
1950
124.002
3) What is the correlation coefficient? 0.98
1952
128.922
1954
130.84
157.61
1956
128.49
1958
133.791
1960
138.767
179.20
1962
140.293
1964
147.35
1966
144.317
193.59
1968
152.882
1970
155.749
1972
162.962
210.38
1974
158.589
1976
148.725
1978
161.363
215.18
1980
142.862
1982
162.029
1984
163.621
Note: Questions continue below.
1986
170.722
1988
144.809
1990
185.984
2000
191.09
Winning speed
The data provided is the winning speed for the given year. Use Excel to create a scatterplot of this data. Find the trendline and the coefficient of correlation (r) for this data. Finally answer the questions about the results.
4) Use the equation and predict the winning speed for 1977. 5) Use the equation and predict the winning speed for 1995.
6) Use the equation and predict the winning speed for 2007.
7) Use the equation and predict the winning speed for 2021.
8) Use the equaton and predict the winning speed for 2025. 1900
1920
1940
1960
1980
2000
2020
2040
0
50
100
150
200
250
f(x) = 1.19954542677043 x − 2213.84404689846
R² = 0.963546001828037
Winning speed
MATH106 - Statistics 1
Mod2 Project
Page 2
2010
191.188
2015
201.193
2020
221.6
9) What do you think about the predictions for 1977, 1995, 2007, 2021? Are they reasonable? Why or why not?
10) What do you think about the prediction for 2025? Is it reasonable? Why or why not?
11) Now consider the correlation coefficient? What is this number telling you (e.g. what does it mean)?
12) Now consider the coefficient of determination? What is this number telling you (e.g. what does it mean)?
I think the predictions for 1977, 1995, 2007 and 2021 are resonable. They are having a positive correlation to the other years and speeds in the data chart and flowing with the current data.
I think the prediction for 2025 is unreasonable as it does not correlate with the other variables and it should have a strong correlation as the r is greater than 0.70.
The correlation coefficient tells me that there is a strong positive linear relationship between the variables due to the correlation coeffcient being close to 1.
The coefficient of determination tells me that if it 0.96 then there is 96% of the variation in y is explained by the linear relationship with x.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help