answer this Q

User Generated

eb24eb

Business Finance

Description

answer Q

Unformatted Attachment Preview

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
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hi there!Attached are all the exercises you posted (E3.4 through E3.7). Two things:1) I'm not sure if the house file is the correct one; there are only 2 possible independent variables. Is the file you provided the correct one?2) None of the problems required the use of BMI or baseball spreadsheets. Let me know if there is anything more to be done :)Thanks again,Selenica

a)

Total
Covariance
Correlation Coefficient

b)

Total
Covariance
Correlation Coefficient

c)

Total
Covariance
Correlation Coefficient

x
1
2
3
5
6
7
8
8
40
6.75
0.895842

y
5
3
4
7
10
9
12
9
59

xy
5
6
12
35
60
63
96
72
349

x2
1
4
9
25
36
49
64
64
252

y2
25
9
16
49
100
81
144
81
505

x
3
4
6
9
9
10
11
12
64
-18.75
-0.79072

y
36
30
17
16
24
12
20
15
170

xy
108
120
102
144
216
120
220
180
1210

x2
9
16
36
81
81
100
121
144
588

y2
1296
900
289
256
576
144
400
225
4086

x
3
4
6
7
9
10
11
12
62
-0.0625
-0.03076

y
3
2
2
2
1
3
3
2
18

xy
9
8
12
14
9
30
33
24
139

x2
9
16
36
49
81
100
121
144
556

y2
9
4
4
4
1
9
9
4
44


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

Zip Code House Price
Square Feet
92101
2500000
3772
92101
680000
2157
92101
795000
792
92101
600000
1954
92102
235000
912
92102
683000
1620
92102
349000
918
92102
180000
1240
92103
1045000
1775
92103
1169000
3346
92103
1275000
2825
92103
549900
1106
92104
219000
1008
92104
519000
1500
92104
629000
1039
92104
499000
1065
92105
262000
1357
92105
325876
1200
92105
324900
792
92105
239000
1272
92106
514100
1618
92106
1475000
3152
92106
900000
2687
92106
1195000
2973
92107
1700000
2112
92107
749000
1840...


Anonymous
Goes above and beyond expectations!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags