hi i just want to know if i'm calculating the correlation correctly-- with the excel package.
can you please just try a few. It's column K and the rest.
ex. k and l
AutoSave OFF Copy of OPS304_Final Presentation_DATA Share Comments Home Insert Draw Page Layout Formulas Data Review View Acrobat ? Tell me Insert Calibri v 11 VA A ag v General Ex AP- O. PX Delete v Cell Create and Share BIUV E $ ~ % Conditional Format Sort & Find & Analyze Paste TV Av E Formatting as Table Styles Format v V Filter Select Data Adobe PDF A1 4 X V fx fielding_POS Q W AA G H Salary(w/Inflatic batting_G batting_AB batting_R batting_H batting_2B batting_3B batting_HR batting_RBI batting_SB batting_BB batting_SO batting_SH fielding_G fielding_PO fielding_A fielding birthYear birthCountry nameFirst nameLast bats throws yearID salary 10 2015 514500 545833.05 145 597 92 17 42 18 77 21 46 82 14 358 1992 USA Mooki Betts 13 26 49 80 157 346 14 158 672 122 214 42 1992 USA Mookie Betts 2016 566000 582980 176 327000 452644.4757 111 255 39 54 24 6 18 78 93 3 SONU 20 1980 USA Reggie Abercrombie 17 3 20 2006 151 497 68 29 74 19 84 133 146 272 155 1974 Venezuela Bobby Abreu 1998 180000 315631.0896 113 146 260 1999 400000 680973.2245 152 546 118 183 35 20 93 27 109 1974 Venezuel Bobby Abreu 2000 2933333 4848352.504 154 576 103 182 42 10 25 28 100 116 152 337 13 1974 Venezuela Bobby Abreu 162 308 11 Bobby 2001 4983000 7996252.186 162 137 588 118 170 48 110 36 106 1974 Venezuela Abreu 104 154 282 10 Bobby Abreu 2002 6333333 9867126.452 157 572 102 17 50 85 31 117 1974 Venezuela 158 577 99 173 35 20 101 22 109 126 158 304 1974 Venezuela Bobb Abreu 2003 9100000 13764566.5 158 311 13 574 118 173 47 105 40 127 116 1974 Venezuela Bobby 2004 10600000 15566457.36 159 Abreu 162 588 104 16 37 102 117 134 158 266 1974 Venezuela Bobby Abreu 2005 13100000 18677467.62 40 101 84 115 157 313 6 2007 15000000 20158745.69 158 605 123 171 1974 Venezuela Bobby Abreu 39 150 10 156 609 180 LOO 10 270 100 1974 Venezuela Bobby Abreu 2008 16000000 20876370.94 152 563 96 165 29 113 136 269 1974 Venezuela Bobby Abre 2009 5000000 6333850.407 41 132 134 242 146 16 1974 Venezuel Bobby Abreu 2010 9000000 11068864.79 154 573 88 29 54 127 30 113 28 17 1974 Venezuela Bobby Abreu 2011 9000000 10746470.67 142 502 59 18 134 40 97 18 1988 USA Dustin Ackley 2013 2700000 3038873.787 113 384 133 245 502 64 123 27 19 2014 1700000 143 1988 USA Dustin Ackley 1857635.9 18 80 121 20 Agbayani 200000 340486.6122 101 276 42 79 1971 USA Benny 1999 19 110 155 220000 363626.4791 350 59 101 - O P P O OOO OOO OOO WUH A HOO WAHOOOOOOOOOOOAPOW 1971 USA Benny gbayani 2000 119 8 1965 P.R. Luis Alicea 1993 160000 325247.057 115 362 50 101 19 UN 1 51 71 15 1965 P.R. Luis Alicea 1998 750000 1315129.54 101 259 133 1975 USA Allen 1999 200000 340486.6122 137 481 69 133 21 267 Chad 369 94 18 104 189 1972 USA 55 ermaine Allensworth 1997 160000 288977.7975 108 100 170 26 1966 USA Moises Alou 1992 110500 231362.4612 115 341 53 96 28 70 136 254 136 1966 USA Moises 1993 210000 426886.7624 482 138 27 Alou 106 201 81 143 28 1966 USA Moises Alou 1994 1415000 2792624.913 107 422 N OH NO O WHO W W W H H H NUI UI N UI O N N W W W H W A N H H W A U H HH 142 259 Alou 143 152 29 1966 USA 1996 3050000 5673898.444 540 87 Moises 150 248 1997 4500000 8127500.556 150 538 8 8 157 O H V A VOW NUWUV AM OUT A OAF O UDOHWNAHNVO 30 1966 USA Moises Alou 154 232 584 04 182 1966 USA Moises Alou 1998 5020000 8802600.386 159 82 121 192 Moises Alou 2000 5250000 8677450.069 126 454 161 1966 USA 205 Alou 2001 5250000 8424708.805 136 513 79 17 130 1966 USA Moises 124 203 132 484 50 133 34 1966 USA Moises Alou 2002 6000000 9347804.5 83 35 142 203 158 1966 USA Alou 2003 9500000 14369602.39 151 565 35 Moises 15 240 155 601 106 176 36 36 1966 USA Moises Alou 2004 9500000 13951070.28 11 222 1966 USA Moises Alou 2005 7250000 10336766.43 123 427 67 137 37 9 1 168 38 1962 USA Rich Amaral 1996 450000 837132.5573 118 312 69 91 113 232 39 1965 USA Ruben Amar 1992 109000 228221.7943 126 374 43 82 41 72 75 40 1965 USA Ruben Amaro 1997 275000 496680.5895 117 175 18 101 150 41 1964 USA Brad Anderson 1991 165000 355837.5591 113 256 40 59 10 158 382 42 1964 USA Brady Anderson 1992 365000 764228.9443 159 623 100 169 140 296 560 87 147 43 1964 USA 142 Brad Anderson 1993 1855000 3770833.067 453 119 1964 USA 78 109 247 Anderson 111 44 Brady 1994 3083333 6085224.418 100 213 1972 USA Anderson 1995 114000 218435.7886 106 374 50 120 45 Garret 268 143 554 108 145 33 111 142 46 1964 USA Brady Anderson 1995 3333333 6387010.724 106 143 341 Anderson 1996 3613333 6721863.766 149 579 117 172 47 1964 USA Brady players (1) Sheet1 + + 100% Ready
