BMI id 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 Age 30.24 19.85 23.44 22.50 26.54 25.22 30.38 29.99 32.67 22.44 22.83 29.48 25.89 20.55 25.43 22.57 24.97 20.13 27.36 21.16 21.98 24.67 22.17 22.37 22.15 30.71 23.57 23.07 21.43 33.86 28.33 35.88 20.73 32.31 23.45 26.69 28.51 33.59 23.58 21.38 27.38 22.09 27.79 18.34 28.43 32.55 Work Out Work 44 42 33 26 38 39 55 41 51 43 53 48 37 28 39 33 33 36 41 41 33 43 38 38 43 45 34 48 40 51 49 46 32 45 36 44 43 45 39 37 38 29 37 38 45 53 5 5 0 0 3 7 0 6 7 4 8 14 4 3 10 4 9 5 4 12 8 11 7 7 10 2 12 0 9 0 8 0 8 3 7 8 5 2 10 4 0 4 8 15 4 0 Sick 55 35 40 46 34 39 48 42 43 34 39 42 33 31 38 41 38 28 50 22 31 33 25 41 28 45 35 32 16 50 51 52 28 51 42 49 38 41 43 21 42 15 36 19 52 49 2 5 3 6 8 10 15 17 15 4 3 14 5 2 12 -1 12 10 5 1 8 9 5 2 8 17 10 3 3 14 10 21 2 11 11 8 11 14 8 6 10 5 7 6 12 16 47 48 49 50 51 52 53 22.19 23.84 24.14 22.39 34.97 29.37 20.32 34 47 47 28 51 50 35 8 7 14 0 2 5 10 28 34 45 37 55 50 28 6 6 6 4 16 14 4 id 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 Player Tracy, Chad Buscher, Brian Bautista, Jose A. Roberts, Ryan Matsui, Hideki Kotsay, Mark Rasmus, Colby Chavez, Endy Cabrera, Asdrubal Rios, Alex Cust, Jack Young, Dmitri Lee, Carlos Flores, Jesus Jeter, Derek Ausmus, Brad Crawford, Carl Quintanilla, Omar Helms, Wes Scott, Luke Johnson, Reed Howard, Ryan Ellis, Mark Ojeda, Augie Suzuki, Kurt Kinsler, Ian Jacobs, Mike Drew, Stephen Votto, Joey Church, Ryan Punto, Nick Markakis, Nick Hairston, Scott Bruntlett, Eric Gardner, Brett Cabrera, Orlando Jackson, Conor Byrd, Marlon Ishikawa, Travis Teixeira, Mark Pagan, Angel Thurston , Joe Kendall, Jason Experience 4 0 3 0 6 11 0 4 1 4 2 12 10 2 12 15 6 0 8 3 5 3 6 3 1 3 3 2 1 3 7 3 2 4 0 10 3 4 0 6 2 1 13 Salary $5,000,000 $412,500 $2,400,000 $400,000 $13,000,000 $1,500,000 $400,000 $2,050,000 $416,700 $6,400,000 $2,800,000 $5,000,000 $19,000,000 $415,500 $21,600,000 $1,000,000 $8,250,000 $408,000 $950,000 $2,400,000 $3,000,000 $15,000,000 $5,000,000 $712,500 $410,000 $3,200,000 $3,275,000 $1,500,000 $437,500 $2,800,000 $4,000,000 $3,350,000 $1,250,000 $800,000 $414,000 $4,000,000 $3,050,000 $3,060,000 $401,000 $20,625,000 $575,000 $475,000 $5,000,000 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 Pierre, Juan Reyes, Jose Blanco, Henry Pedroia, Dustin Lind, Adam Francoeur, Jeff Polanco, Placido Larish, Jeff Ross, Cody McLouth, Nate Delgado, Carlos Lopez, Felipe Dellucci, David Anderson, Garret Berkman, Lance Young, Delmon Headley, Chase Smith, Seth Johnson, Nick Pena Jr., Tony (Francisco) Fields, Josh Cabrera, Miguel Giles, Brian Iannetta, Chris Hunter, Torii McDonald, Darnell Cabrera, Everth Cruz, Luis A. Tuiasosopo, Matt Duncan, Chris Granderson, Curtis Fowler, Dexter Baker, John D. Ethier, Andre Loney, James Cora, Alex Peralta, Jhonny Hudson, Orlando Fontenot, Mike Teagarden, Taylor Ramirez, Manny Bonifacio, Emilio Zaun, Gregg Scutaro, Marco 8 5 11 2 0 3 9 0 3 3 14 6 9 14 9 2 2 0 8 2 0 5 12 2 10 0 0 0 0 2 3 0 0 2 1 8 4 6 1 0 15 0 13 5 $10,000,000 $6,125,000 $750,000 $1,750,000 $411,800 $3,375,000 $4,600,000 $403,000 $2,225,000 $2,500,000 $12,000,000 $3,500,000 $4,000,000 $2,500,000 $14,500,000 $1,152,000 $411,500 $403,000 $5,500,000 $425,000 $410,000 $14,383,049 $9,000,000 $415,000 $18,000,000 $410,000 $400,000 $401,500 $400,000 $825,000 $3,500,000 $401,000 $400,000 $3,100,000 $465,000 $2,000,000 $3,650,000 $3,364,877 $430,000 $401,000 $23,854,494 $400,000 $1,500,000 $1,100,000 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 Bloomquist, Willie Abreu, Bobby Werth, Jayson Buck, Travis Olivo, Miguel Hermida, Jeremy Doumit, Ryan Butler, Billy Napoli, Mike Gonzalez, Alex Luis Janish, Paul Molina, Jose Matsui, Kazuo Gonzalez, Andy Maybin, Cameron Paulino, Ronny Bradley, Milton Ramirez, Aramis Wells, Vernon Wilson, Jack Fontenot, Mike Lee, Derrek Griffey Jr., Ken Sizemore, Grady Prado, Martin Miller, Corky Beltre, Adrian Greene, Khalil Milledge, Lastings Cabrera, Melky Carroll, Brett Hawpe, Brad Hundley, Nick Infante, Omar Hanigan, Ryan Ross, David Crowe, Trevor Lowell, Mike Gonzalez, Alberto Escobar, Yunel Michaels, Jason Thome, Jim Davis, Rajai Hafner, Travis 6 12 6 2 6 3 3 1 2 10 0 8 5 0 0 2 8 9 8 8 1 10 20 4 1 3 10 5 2 2 1 3 0 6 0 5 0 10 0 1 6 16 1 6 $1,400,000 $5,000,000 $2,500,000 $410,000 $2,700,000 $2,250,000 $2,150,000 $421,000 $2,000,000 $5,375,000 $400,000 $2,125,000 $5,500,000 $420,000 $400,000 $440,000 $7,000,000 $16,650,000 $4,687,500 $7,400,000 $430,000 $13,250,000 $2,000,000 $4,766,666 $415,000 $450,000 $13,400,000 $6,500,000 $452,000 $1,400,000 $400,000 $5,500,000 $404,400 $1,850,000 $400,000 $1,400,000 $400,000 $12,500,000 $400,000 $425,000 $750,000 $13,000,000 $410,000 $11,500,000 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 Boone, Aaron Anderson, Brian Nikoli Mathis, Jeff Uribe, Juan Molina, Yadier Coste, Chris Lewis, Fred Overbay, Lyle Bay, Jason Blalock, Hank Barfield, Josh Taveras, Willy Nix, Jayson Vazquez, Ramon Buck, John McCann, Brian Encarnacion, Edwin Rivera, Mike Crosby, Bobby Velez, Eugenio Pierzynski, A.J. Victorino, Shane Torrealba, Yorvit Soriano, Alfonso Wright, David Bruce, Jay Dickerson, Chris Utley, Chase Lillibridge, Brent Cedeno, Ronny Miles, Aaron Fukudome, Kosuke Morgan, Nyjer Quentin, Carlos 10 3 2 7 4 2 1 6 5 7 2 4 1 6 4 3 3 2 5 1 8 4 7 8 4 0 0 5 0 3 5 1 1 2 $750,000 $440,000 $450,000 $1,000,000 $3,312,500 $460,000 $440,000 $7,950,000 $7,800,000 $6,200,000 $416,100 $2,250,000 $400,000 $1,875,000 $2,900,000 $3,700,000 $2,425,000 $415,000 $5,300,000 $404,000 $6,250,000 $3,125,000 $3,750,000 $17,000,000 $7,750,000 $417,500 $400,000 $11,285,714 $402,500 $822,500 $2,200,000 $12,500,000 $411,500 $550,000 x1 y1 1 2 3 5 6 7 8 8 5 3 4 7 10 9 12 9 x2 y2 3 4 6 9 9 10 11 12 36 30 17 16 24 12 20 15 3.7 As a human resource manager for Comcel, you have been assigned the task of evaluating a new employee training program. You have the following production data (units during the month of January) for 25 employees who were participants in the program 910 950 960 990 1,030 1,050 1,070 1,080 1,090 1,170 1,180 1,190 1,280 1,290 1,300 1,380 1,390 760 1,110 850 1,130 870 1,140 890 1,160 25 25 25 Exi = 27,220, Xx} = 30,304,800, (x; – 5)2 = 667,664 i=1 i=1 i=1 a. Compute the summary statistic that best measures the central tendency or norm in these data. b. Compute the summary statistic(s) that best measures the variation in these data. c. Show whether there are any outliers in these data. E3.4 JOpen the file scatter.xls. For each of the four data sets listed, create and print a scatter plot. Then comment on the strength and direction of the linear relationship between the two variables. E3.5 Calculate the covariance and the correlation coefficient for the following sets of numbers. у Orb.x . x a. X X C. х 1 2 3 5 6 7 5 3 4. 7 10 9 12 9 3 4 6 9 9 10 11 12 у 36 30 17 16 24 12 20 15 3 4 6 7 9 10 11 12 y 3 2 2 2 1 3 3 2 E3.6 Consider the economic development data in the file P02_06.xls. a. Create a scatterplot for each variable versus the size of the household's monthly home mortgage or rent payment. Print the graphs. b. Which of the variables have a positive linear relationship with the size of the household's monthly home mortgage or rent payment? c. Which of the variables have a negative linear relationship with the size of the household's monthly home mortgage or rent payment? d. Which of the variables have essentially no linear relationship with the size of the household's monthly home mortgage or rent payment?
Purchase answer to see full attachment