QMTH 205 Statistics

Anonymous
timer Asked: Jan 30th, 2019
account_balance_wallet $45

Question Description

Excel Project 1

Download the csv file which contains your data. You can open it with Excel. Once you have it opened, be sure to save it with EP1_{yourname}.xlsx (as an Excel file type). Warning – if you leave it as a csv file type, it may not save your formulas.

Using the NBA data file provided,

1. Calculate the mean, variance, and standard deviation of weight, height, age of all NBA players.

2. Calculate quartiles and the IQR for all players

3. Create a frequency table (use a pivot table) showing players by position along with their weight, height, or age.

4. Develop a 5NS for each position.

5. Create a frequency table of position showing mean weight, height, and age for the positions (use a pivot table).

Player Pos Nate Robinson G Isaiah Thomas G Phil PresseyG Shane LarkinG Ty Lawson G John Lucas III G D.J. Augustin G Kyle Lowry G Sebastian Telfair G Will BynumG Jameer Nelson G Mickey McConnell G Aaron Brooks G Isaiah Canaan G Patty Mills G J.J. Barea G Darren Collison G Chris Paul G Ish Smith G Rajon Rondo G Raymond Felton G Brandon Jennings G Peyton SivaG Lou Williams G Jannero Pargo G Kemba Walker G Patrick Beverley G Mike ConleyG Brian Roberts G Derek FisherG Earl WatsonG Mo WilliamsG Trey Burke G Maalik Wayns G Eric BledsoeG Avery Bradley G Jason TerryG Chris SmithG Marquis Teague G Daniel Gibson G George Hill G C.J. WatsonG Luke Ridnour G Jeff TeagueG Dennis Schroeder G Mario Chalmers G Height 69 69 71 71 71 71 72 72 72 72 72 72 72 72 72 72 72 72 72 73 73 73 73 73 73 73 73 73 73 73 73 73 73 73 73 74 74 74 74 74 74 74 74 74 74 74 Weight Age 180 185 175 176 195 157 180 205 175 185 190 189 161 198 185 175 160 175 175 171 205 169 181 175 185 172 180 185 180 210 195 195 185 195 195 180 180 195 189 200 180 175 175 181 168 190 29 24 22 20 25 30 25 27 28 30 31 24 28 22 25 29 26 28 25 27 29 23 22 26 33 23 25 25 27 39 34 30 20 22 23 22 36 25 20 27 27 29 32 25 20 27 Norris Cole G Ronnie PriceG Tony ParkerG Andre MillerG Dee Bost G Nolan SmithG Toney Douglas G Seth Curry G Jordan Farmar G Jimmer Fredette G Deron Williams G Tyshawn Taylor G Beno UdrihG Pablo Prigioni G Charles Jenkins G Dwight Buycks G Derrick RoseG Jarrett Jack G Kyrie Irving G Chauncey Billups G Donald Sloan G Ben Hansbrough G Brandon Knight G Shelvin Mack G Ramon Sessions G Ben GordonG Eric MaynorG Jose Calderon G Monta Ellis G Devin HarrisG Jeremy Lin G B.J. Young G Jerryd Bayless G Keyon Dooling G Eric GordonG Cory JosephG Erick GreenG Russell Westbrook G Reggie Jackson G Damian Lillard G C.J. McCollum G Ian Clark G Jamaal Tinsley G Jerel McNeal G Nemanja Nedovic G Stephen Curry G Willie GreenG 74 74 74 74 74 74 74 74 74 74 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 170 187 180 200 170 185 185 185 180 195 209 185 205 180 220 190 190 197 191 202 205 203 189 215 190 200 175 211 185 190 200 180 200 195 215 185 185 187 208 195 197 175 185 196 191 185 201 24 30 31 37 23 25 27 23 26 24 29 23 31 36 24 24 24 29 21 36 25 25 21 24 27 30 26 31 27 30 25 20 25 33 24 21 22 24 23 23 22 22 35 26 22 25 32 Steve BlakeG Steve Nash G Goran Dragic G Ray McCallum G Jordan Crawford G Khalif WyattG Carlos Morais G Kirk HinrichG Matthew Dellavedova G Dion Waiters G O.J. Mayo G Nate Wolters G Gary Neal G Royal Ivey G Jared Cunningham G John JenkinsG Gerald Henderson G Dwyane Wade G Doron LambG E`Twaun Moore G John Wall G Bradley BealG Wayne Ellington G Gal Mekel G Tony Allen G Jrue HolidayG Austin Rivers G Randy FoyeG Ricky RubioG Terrel HarrisG J.J. Redick G Jodie MeeksG Diante Garrett G Kendall Marshall G Shannon Brown G Marcus Thornton G Keith Bogans G Courtney Lee G MarShon Brooks G Toure` Murry F Vander BlueG Daequan Cook G Rodney Stuckey G Ron HowardG Lance Stephenson G Orlando Johnson G Ray Allen G 75 75 75 75 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 77 77 77 77 77 77 77 77 77 77 77 172 178 190 190 195 210 190 190 185 215 210 190 210 215 185 220 215 220 210 191 195 207 200 200 213 180 200 213 180 190 190 208 190 195 210 205 215 200 200 200 197 210 205 200 210 220 205 33 39 27 22 24 22 27 32 23 21 25 22 28 31 22 22 25 31 21 24 23 20 25 25 31 23 21 29 22 26 29 26 24 22 27 26 33 27 24 23 21 26 27 30 23 24 38 Arron Afflalo G Victor Oladipo G James Harden G Jamaal Franklin G Anthony Morrow G Roger Mason G Jr. Marco Belinelli G Nando De Colo G Lorenzo Brown G Jeremy Lamb G Wesley Matthews G Elliot Williams G Kent Bazemore G Jamal Crawford G Dionte Christmas G Archie Goodwin G Malcolm Lee G P.J. Tucker F Trent Lockett G Ben McLemore G Alan Anderson F Jerry Stackhouse F Tim Hardaway G Jr. Iman Shumpert G James Anderson G Tony Wroten G Michael Carter-Williams G Jason Richardson G Julyan StoneG Mickael Pietrus F C.J. Miles G Carrick FelixG Alonzo GeeF Kentavious G Caldwell-Pope Corey Maggette F Sam Young F Carlos Delfino F Damien Wilkins G Glen Rice Jr.G Garrett Temple G D.J. Kennedy G Vince CarterF Reggie Williams G Nick Calathes G Quincy Pondexter F Tyreke Evans G Deshaun Thomas F 77 77 77 77 77 77 77 77 77 77 77 77 77 77 77 77 77 77 77 77 78 78 78 78 78 78 78 78 78 78 78 78 78 78 78 78 78 78 78 78 78 78 78 78 78 78 78 215 214 220 205 210 205 200 200 189 180 220 183 201 200 205 189 200 225 210 195 219 218 205 220 215 208 185 225 200 215 222 200 219 205 225 220 230 225 211 195 215 220 205 194 225 220 220 27 21 24 22 27 33 27 26 23 21 26 24 24 33 27 19 23 28 22 20 30 38 21 23 24 20 21 32 24 31 26 23 26 20 33 28 31 33 22 27 23 36 27 24 25 24 22 Danny Green G Manu Ginobili F Shabazz Muhammad G Alexey Shved G E.J. Singler F Will Barton G Allen Crabbe G Brandon Rush F Alec Burks G Andre Iguodala F Xavier Henry F Nick Young G Kobe BryantG John Salmons F Greivis Vasquez G Chuck HayesF Gerald Wallace F Joe JohnsonG Shaun Livingston G Paul Pierce F Metta World F Peace Evan TurnerF Arsalan Kazemi F Landry Fields F Quincy Acy F DeMar DeRozan G Terrence Ross F Tony Snell F Jimmy Butler F Sergey Karasev G Solomon HillF Caron ButlerF Khris Middleton F Kyle KorverG Jeff Adrien F Michael Kidd-Gilchrist F Jeff Taylor F James EnnisG Jason Maxiell F Martell Webster F Shawn Marion F Ricky Ledo G Jae CrowderF DeJuan BlairF Ronnie Brewer G Francisco Garcia F Kawhi Leonard F 78 78 78 78 78 78 78 78 78 78 78 78 78 78 78 78 79 79 79 79 79 79 79 79 79 79 79 79 79 79 79 79 79 79 79 79 79 79 79 79 79 79 79 79 79 79 79 210 205 225 190 215 174 200 210 195 207 220 200 205 207 211 238 220 240 185 235 260 205 226 214 233 217 197 200 220 197 220 228 215 212 243 232 225 201 260 230 228 197 240 270 235 195 225 26 36 20 24 23 22 21 28 22 29 22 28 35 33 26 30 31 32 28 35 33 24 23 25 22 24 22 21 24 19 22 33 22 32 27 19 24 23 30 26 35 21 23 24 28 31 22 Damion James F Jordan Hamilton F Evan Fournier G Kevin Martin G Chase Budinger G Mickael Gelabale F Thabo Sefolosha G Ryan GomesF Andre Roberson F Richard Howell F Richard Jefferson F Klay Thompson G Draymond Green F Jared Dudley F Matt BarnesF Reggie Bullock F Marcus Landry F Wesley Johnson G Brandon Bass F Reggie Evans F Mirza Teletovic F Carmelo Anthony F Royce WhiteF Thaddeus Young F Chris WrightF Linas KleizaF Rudy Gay F Luke WaltonF Anthony Bennett F Kyle SinglerF Paul GeorgeF Danny Granger F Paul MillsapF DeMarre Carroll F Mike Scott F James Southerland F Anthony Tolliver F Eric Griffin F LeBron James F James JonesG Shane Battier F Udonis Haslem F Tobias Harris F Moe Harkless F Romero Osby F Trevor ArizaG Chris Singleton F 79 79 79 79 79 79 79 79 79 79 79 79 79 79 79 79 79 79 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 220 220 206 185 218 215 215 245 206 250 230 205 230 225 226 200 230 215 250 245 235 230 260 220 218 248 230 235 240 230 210 228 253 212 237 221 240 190 250 215 220 235 226 218 232 210 230 25 22 20 30 25 30 29 31 21 22 33 23 23 28 33 22 27 26 28 33 28 29 22 25 24 28 27 33 20 25 23 30 28 27 25 23 28 23 28 32 35 33 21 20 23 28 23 Trevor Booker F Tony Gaffney F Mike MillerF Lance Thomas F Darius Miller G Boris Diaw C Wilson Chandler F Kenneth Faried F Derrick Williams F Dante Cunningham F Nicolas Batum F Gordon Hayward F Harrison Barnes F Elias Harris F Gerald Green F DeQuan Jones G Luc Mbah aFMoute Jared Sullinger F Jeff Green F Kris Humphries F Tornike Shengelia F Andrei Kirilenko F C.J. Leslie F Kenyon Martin F Furkan Aldemir F Lavoy AllenC Tyler Hansbrough F Amir Johnson F Carlos Boozer F Luol Deng F Taj Gibson F Mike Dunleavy F Tristan Thompson F Josh Smith F Tony Mitchell F Luigi Datome F Darnell Jackson F Luis Scola C David WestF Chris Copeland F Giannis Antetokounmpo F Elton BrandF Bismack Biyombo C Juwan Howard F Jarvis Varnado F Joel Anthony C Glen Davis F 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 240 205 218 225 235 235 225 228 241 230 200 207 210 239 200 221 230 260 235 235 217 235 209 240 220 225 250 237 266 220 225 230 227 225 236 210 253 245 240 235 205 254 229 250 230 245 289 25 28 33 25 23 31 26 23 22 26 24 23 21 24 27 23 27 21 27 28 21 32 22 35 22 24 27 26 31 28 28 33 22 27 21 25 27 33 33 29 18 34 21 40 15 31 27 Andrew Nicholson F Al Harrington F Kevin Seraphin C Otto PorterF Devin Ebanks F Terrence Jones F Omri CasspiF Chandler Parsons F Robert Covington F Willie ReedF Tayshaun Prince F Zach Randolph F Al-Farouq Aminu F Arinze Onuaku F Lou Amundson F Livio Jean-Charles F Jeff Ayres F Darrell Arthur C J.J. Hickson F Quincy Miller F Corey Brewer F Bojan Dubljevic F Kevin Durant F Dorell Wright F Victor Claver F Marvin Williams F Jeremy Evans F David Lee F Brandon Davies F Antawn Jamison F Shawne Williams F Alex OriakhiF Marcus Morris F Patrick Patterson F Carl Landry F Travis Outlaw F James Johnson F Chris WilcoxC Mason Plumlee C Jeremy TylerF Amare Stoudemire F Nerlens Noel C Steve NovakF Erik MurphyF Nazr Mohammed C Vladimir Radmanovic F Earl Clark F 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 82 82 82 82 82 82 82 82 82 82 250 250 275 200 215 252 225 200 204 207 215 260 215 261 225 217 240 235 242 210 188 240 230 205 235 240 196 240 235 235 230 255 235 235 248 207 248 235 235 260 240 228 240 230 250 235 225 23 33 23 20 23 21 25 24 22 23 33 32 22 26 30 19 26 25 25 20 27 21 24 27 25 27 25 30 22 37 27 23 24 24 30 29 26 31 23 22 30 19 30 22 36 32 25 Andre Drummond C Josh Harrellson C Jonas Jerebko F Ekpe Udoh C Ersan Ilyasova F Pero Antic F Gustavo Ayon F Al Horford F Al JeffersonC Josh McRoberts F Tyrus Thomas F Michael Beasley F Rashard Lewis F Chris Andersen C Kyle O`Quinn F Nikola Vucevic C Hedo Turkoglu F Emeka Okafor C Bernard James C Brandan Wright C Greg Smith F Jon Leuer F Ed Davis C Anthony Davis F Ryan Anderson F Matt Bonner F Aron BaynesF Danilo Gallinari F Ronny TuriafC Kevin Love F Nick CollisonF Kendrick Perkins C Serge IbakaF Daniel Orton C Grant Jerrett F Thomas Robinson F Derrick Favors F Marreese Speights C Lamar Odom F Blake GriffinF Jordan Hill F Miles Plumlee F Markieff Morris F Vitor Faverani C Andray Blatche C Kevin Garnett F Tim Ohlbrecht F 82 82 82 82 82 82 82 82 82 82 82 82 82 82 82 82 82 82 82 82 82 82 82 82 82 82 82 82 82 82 82 82 82 82 82 82 82 82 82 82 82 82 82 83 83 83 83 270 275 231 240 235 260 250 245 280 240 225 235 230 228 240 240 220 255 240 210 250 228 228 220 240 235 260 225 245 250 255 280 235 255 232 237 246 245 230 251 235 245 245 260 260 253 255 20 24 26 26 26 31 28 27 28 26 27 24 34 35 23 22 34 30 28 25 22 24 24 20 25 33 26 25 30 25 32 28 24 23 20 22 22 26 33 24 26 25 24 25 27 37 25 Arnett Moultrie F Kwame Brown C Austin DayeF Joakim Noah C Anderson Varejao C Greg Monroe C Charlie Villanueva F Ian MahinmiC Larry Sanders C Zaza Pachulia C John Henson C Chris Bosh C Jan Vesely F Nene F Samuel Dalembert C Dwight Howard C Marcus Camby C Jordan Henriquez C Greg Stiemsma C Tim DuncanC Tiago Splitter C Joffrey Lauvergne F Anthony Randolph F Gorgui Dieng C Nikola Pekovic C Chris Johnson C Perry JonesFIII Jared Jeffries F LaMarcus Aldridge F Joel Freeland C Enes KanterC Jermaine O`Neal C Festus EzeliC DeAndre Jordan C Ryan Kelly F Marcin Gortat C Channing Frye F DeMarcus Cousins C Jason Thompson F Cole AldrichC Colton Iverson C Kelly OlynykC Brook LopezC Andrea Bargnani C Earl Barron C Jonas Valanciunas C Aaron GrayC 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 84 84 84 84 84 84 84 230 270 200 232 260 250 232 230 235 275 220 235 240 250 250 265 235 250 260 255 240 235 225 245 290 210 235 240 240 225 267 255 255 265 230 240 245 270 250 245 255 238 265 255 250 257 270 22 31 25 28 30 23 29 26 24 29 22 29 23 31 32 27 39 24 27 37 28 21 24 23 27 28 21 31 28 26 21 34 23 25 22 29 30 23 27 24 24 22 25 27 32 21 28 Andrew Bynum C Tyler Zeller C Miroslav Raduljica C Johan PetroC Cody Zeller F DeSagana Diop C Brendan Haywood C Justin Hamilton C Greg Oden C Fab Melo C Dirk Nowitzki F Omer Asik C Donatas Motiejunas F Kosta Koufos C Jeff WitheyC Jason SmithF JaVale McGee C Steven Adams C Robin LopezC Andris Biedrins C Andrew Bogut C Byron Mullens C Ryan HollinsC Chris KamanC Pau Gasol F Robert Sacre C Viacheslav Kravtsov C Tyson Chandler C Spencer Hawes C Marc GasolC Timofey Mozgov C Meyers Leonard C Rudy GobertC Alex Len C Roy HibbertC Hasheem Thabeet C 84 84 84 84 84 84 84 84 84 84 84 84 84 84 84 84 84 84 84 84 84 84 84 84 84 84 84 85 85 85 85 85 85 85 86 87 285 250 240 247 230 280 263 260 285 255 245 255 222 265 235 240 252 250 255 240 260 275 240 265 250 263 260 235 245 265 250 250 235 255 278 263 25 23 25 27 20 31 33 23 25 23 35 27 23 24 23 27 25 20 25 27 28 24 28 31 33 24 26 30 25 28 27 21 21 20 26 26

Tutor Answer

Chucks574
School: New York University

Please in case...

flag Report DMCA
Review

Anonymous
Thanks, good work

Similar Questions
Hot Questions
Related Tags
Study Guides

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors