What is the IQR for home runs in the data? 80% of batters in this data hit fewer

Question

What is the IQR for home runs in the data?

80% of batters in this data hit fewer than _______ home runs. (fill in the blank in the sentence using Excel's Percentile.exc command)

player team avg hr Altuve, J HOU 0.341 7 Martinez, V DET 0.335 32 Brantley, M CLE 0.327 20 Beltre, A TEX 0.324 19 Morneau, J COL 0.319 17 Abreu, J CWS 0.317 36 Harrison, J PIT 0.315 13 Cano, R SEA 0.314 14 McCutchen, A PIT 0.314 25 Cabrera, M DET 0.313 25 Posey, B SF 0.311 22 Revere, B PHI 0.306 2 Span, D WSH 0.302 5 Cain, L KC 0.301 5 Cabrera, M TOR 0.301 16 Lucroy, J MIL 0.301 13 Eaton, A CWS 0.3 1 Puig, Y LAD 0.296 16 Kendrick, H LAA 0.293 7 Werth, J WSH 0.292 16 Castro, S CHC 0.292 14 Marte, S PIT 0.291 13 Loney, J TB 0.29 9 Gordon, D LAD 0.289 2 Murphy, D NYM 0.289 9 Adams, M STL 0.288 15 Blackmon, C COL 0.288 19 Freeman, F ATL 0.288 18 Suzuki, K MIN 0.288 3 Stanton, G MIA 0.288 37 Trout, M LAA 0.287 36 McGehee, C MIA 0.287 4 Rendon, A WSH 0.287 21 Reyes, J TOR 0.287 9 Kemp, M LAD 0.287 25 Rizzo, A CHC 0.286 32 Hunter, T DET 0.286 17 Bautista, J TOR 0.286 35 Ramirez, A MIL 0.285 15 Aoki, N KC 0.285 1 Escobar, A KC 0.285 3 Gomez, C MIL 0.284 23 Yelich, C MIA 0.284 9 Ramirez, H LAD 0.283 13 Gillaspie, C CWS 0.282 7 Prado, M NYY 0.282 12 Jones, A BAL 0.281 29 Chisenhall, L CLE 0.28 13 Sandoval, P SF 0.279 16 Aybar, E LAA 0.278 7 Gomes, Y CLE 0.278 21 Pedroia, D BOS 0.278 7 Mauer, J MIN 0.277 4 Pence, H SF 0.277 20 Fowler, D HOU 0.276 8 Hechavarria, A MIA 0.276 1 Gonzalez, A LAD 0.276 27 Markakis, N BAL 0.276 14 Kinsler, I DET 0.275 17 Navarro, D TOR 0.274 12 Martin, L TEX 0.274 7 Ramirez, A CWS 0.273 15 Frazier, T CIN 0.273 29 Carpenter, M STL 0.272 8 Zobrist, B TB 0.272 10 Calhoun, K LAA 0.272 17 Holliday, M STL 0.272 20 Pujols, A LAA 0.272 28 Walker, N PIT 0.271 23 Butler, B KC 0.271 9 Ellsbury, J NYY 0.271 16 Cruz, N BAL 0.271 40 Heyward, J ATL 0.271 11 Hosmer, E KC 0.27 9 Upton, J ATL 0.27 29 Utley, C PHI 0.27 11 Wright, D NYM 0.269 8 Ozuna, M MIA 0.269 23 Hardy, J BAL 0.268 9 Encarnacion, E TOR 0.268 34 Seager, K SEA 0.268 25 LeMahieu, D COL 0.267 5 Gordon, A KC 0.266 19 Smith, S SD 0.266 12 Braun, R MIL 0.266 19 Byrd, M PHI 0.264 25 Andrus, E TEX 0.263 2 Johnson, C ATL 0.263 10 Ortiz, D BOS 0.263 35 Peralta, J STL 0.263 21 Parra, G MIL 0.261 9 Solarte, Y SD 0.26 10 Cespedes, Y BOS 0.26 22 Freese, D LAA 0.26 10 Perez, S KC 0.26 17 LaRoche, A WSH 0.259 26 Castellanos, N DET 0.259 11 Escobar, Y TB 0.258 7 Plouffe, T MIN 0.258 14 Jeter, D NYY 0.256 4 Jackson, A SEA 0.256 4 Gardner, B NYY 0.256 17 Mercer, J PIT 0.255 12 Donaldson, J OAK 0.255 29 Desmond, I WSH 0.255 24 Longoria, E TB 0.253 22 Duda, L NYM 0.253 30 Infante, O KC 0.252 6 De Aza, A BAL 0.252 8 Hamilton, B CIN 0.25 6 Lowrie, J OAK 0.249 6 Valbuena, L CHC 0.249 16 Crawford, B SF 0.246 10 Crisp, C OAK 0.246 9 Jones, G MIA 0.246 15 Segura, J MIL 0.246 5 Ackley, D SEA 0.245 14 Simmons, A ATL 0.244 7 Jennings, D TB 0.244 10 Davis, K MIL 0.244 22 Hill, A ARI 0.244 10 Rollins, J PHI 0.243 17 Montero, M ARI 0.243 13 Headley, C NYY 0.243 13 Dozier, B MIN 0.242 23 Choo, S TEX 0.242 13 Cabrera, A WSH 0.241 14 Kipnis, J CLE 0.24 6 Bogaerts, X BOS 0.24 12 Brown, D PHI 0.235 10 Moss, B OAK 0.234 25 McCann, B NYY 0.232 23 Viciedo, D CWS 0.231 21 Santana, C CLE 0.231 27 Granderson, C NYM 0.227 20 Carter, C HOU 0.227 37 Howard, R PHI 0.223 23 Castro, J HOU 0.222 14 Cozart, Z CIN 0.221 4 Dunn, A OAK 0.219 22 Bruce, J CIN 0.217 18 Teixeira, M NYY 0.216 22 Craig, A BOS 0.215 8 Dominguez, M HOU 0.215 16 Upton, B ATL 0.208 12 Davis, C BAL 0.196 26

Explanation / Answer

from above given data with using percentile.exc(array, k) and putting hr column in array and k=0.8;

80% of batters in this data hit fewer than 23 home runs.

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.