I NEED THE SOLUTIONS WITH EXCEL FORMULA,PLEASE!
Use this set of data if your studend ID last digit is 1 or 5 SOS 94 244 159 119 247 228 112 166 139 179 235 243 166 107 164 176 103 202 119 217 251 255 136 106 143 206 147 241 156 186 236 235 191 177 137 179 98 199 95 108 Wins 12 13 10 6 18 11 12 15 10 13 11 16 8 12 14 14 5 12 5 14 12 14 12 8 9 15 14 12 9 9 11 16 13 9 7 14 7 9 11 7
The accompanying table shows the number of wins and the number of strike-outs (SO) for 40 baseball pitchers in the major leagues in a certain year. Complete parts (a) through (d) below. a. Make a scatterplot of the data, and state the sign of the slope from the scatterplot. Use strike-outs to predict wins. b. Use linear regression to find the equation of the best-fit line. c. Interpret the slope. d. Interpret the intercept and comment on it.
I NEED THE SOLUTIONS WITH EXCEL FORMULA, PLEASE!
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am