MAT 114 QUANTITATIVE REASONING SPRING 2017 PROJECT TWO The objective of this project is to use a spreadsheet program to test correlation strength and to create and utilize mathematical functions which model relationships between pairs of quantities, especially relationships which demonstrate linear or exponential growth/decay. Important definitions and helpful examples related to this project are provided in the following Modules in the e-text: Module 8 - independent/dependent variables, positive/negative correlation, correlation coefficient Module 9 - comparing linear and exponential growth/decay Module 9 - implementing functions using Microsoft Excel (video example) A spreadsheet file containing the data sets required for this project must be downloaded from your course's BbLearn Shell. All required charts/graphs must be created within a spreadsheet program. Handwritten or hand-drawn charts/graphs will not be accepted. Answers to the following questions must be compiled into a single word-processing document (Microsoft Word, etc.), including necessary explanatory text and supporting charts/graphs. Explanations and discussions of answers must be in complete, grammatically correct sentences. The final document must be neat and organized, with answers to individual problems clearly labeled. The method of submission of the final document (i.e. printed out, submitted electronically, etc.) will be determined by individual instructors. This project must be submitted at the start of your Class Meeting during Week 10 of this semester. EAGLES A study was conducted on Admiralty Island in southeast Alaska using time-lapse photography to document Bald Eagle incubation, brooding (sitting on eggs to hatch them), prey deliveries and feeding. It provides a number of insights into male/female role differentiation including how roles and behaviors change based on environmental factors. While both male and female Bald Eagles brood, for example, the percentage of time the female broods during a given day appears to depend on several aspects of that day's weather. 1. Data in the accompanying spreadsheet documents 19 days during the above study. For each day, the percentage of that day which was considered by scientists to be \"sunny\" was measured along with the percentage of that day during which the female Bald Eagle brooded (that is, sat on her eggs). a) Does it appear these quantities are positively related or negatively related? Why, do you think, these quantities would be related in this way? b) Create a scatterplot of the data. (This is accomplished in Microsoft Excel by highlighting all of the data, clicking the \"Insert\" tab, and selecting \"Scatter\".) c) Have your spreadsheet program create a linear regression trendline for the data, displaying the equation and the coefficient of determination (R2) on the graph. (This is accomplished in Microsoft Excel by right-clicking on a data point in your scatterplot, selecting \"Add Trendline...\Percent of Day Sunny Percent Female Brooding Time 0.2 81.1 1.3 68.5 1.6 59.8 6.8 70.1 8.1 69.3 11.2 57.0 17.4 64.4 18.6 62.2 37.2 67.4 38.1 51.5 40.2 68.2 44.2 45.8 44.3 39.1 46.1 60.8 52.9 59.7 54.6 57.9 55.1 42.6 70.9 37.0 80.4 44.1 2016 Major League Baseball Statistics Batting Team ARI ATL BAL BOS CHC CHW CIN CLE COL DET HOU KCR LAA LAD MIA MIL MIN NYM NYY OAK PHI PIT SDP SEA SFG STL TBR TEX TOR WSN R/G 4.64 4.03 4.59 5.42 4.99 4.23 4.42 4.83 5.22 4.66 4.47 4.17 4.43 4.48 4.07 4.14 4.46 4.14 4.2 4.03 3.77 4.5 4.23 4.74 4.41 4.81 4.15 4.72 4.69 4.71 H 1479 1404 1413 1598 1409 1428 1403 1435 1544 1476 1367 1450 1410 1376 1460 1299 1409 1342 1378 1352 1305 1426 1275 1446 1437 1415 1333 1446 1358 1403 Pitching BA 0.261 0.255 0.256 0.282 0.256 0.257 0.256 0.262 0.275 0.267 0.247 0.261 0.26 0.249 0.263 0.244 0.251 0.246 0.252 0.246 0.24 0.257 0.235 0.259 0.258 0.255 0.243 0.262 0.248 0.256 SO 1427 1240 1324 1160 1339 1285 1284 1246 1330 1303 1452 1224 991 1321 1213 1543 1426 1302 1188 1145 1376 1334 1500 1288 1107 1318 1482 1220 1362 1252 RA/G 5.49 4.84 4.41 4.28 3.43 4.41 5.27 4.2 5.31 4.48 4.33 4.4 4.49 3.94 4.24 4.52 5.49 3.81 4.33 4.7 4.91 4.68 4.75 4.36 3.9 4.4 4.4 4.67 4.11 3.78 ERA 5.09 4.51 4.22 4 3.15 4.1 4.91 3.84 4.91 4.24 4.06 4.21 4.28 3.7 4.05 4.08 5.08 3.57 4.16 4.51 4.63 4.21 4.43 4 3.65 4.08 4.2 4.37 3.78 3.51 Fielding ERA+ 87 92 105 114 128 98 87 122 100 98 98 103 93 106 98 105 82 115 105 88 90 100 92 102 111 101 97 103 114 119 H 1563 1414 1408 1342 1125 1422 1457 1330 1532 1417 1441 1433 1480 1266 1358 1450 1617 1397 1358 1459 1468 1490 1425 1410 1334 1432 1395 1441 1340 1272 HR 202 177 183 176 163 185 258 186 181 182 181 206 208 165 152 178 221 152 214 185 213 180 183 213 158 159 210 201 183 155 tSho 7 9 9 5 15 10 8 11 9 8 8 7 12 15 12 7 3 13 10 7 12 5 9 8 11 10 8 6 10 12 SO 1318 1227 1248 1362 1441 1270 1241 1398 1223 1232 1396 1287 1136 1510 1379 1175 1191 1396 1393 1188 1299 1232 1222 1318 1309 1290 1357 1154 1314 1476 DefEf 0.665 0.692 0.688 0.695 0.728 0.687 0.694 0.696 0.667 0.689 0.681 0.687 0.685 0.699 0.683 0.68 0.663 0.678 0.694 0.685 0.681 0.676 0.687 0.694 0.702 0.679 0.687 0.692 0.703 0.7 E 101 101 80 75 101 95 102 89 110 75 77 94 97 80 86 136 126 90 86 97 97 111 109 89 72 107 94 97 88 73 2015 Other Attend/G 25138 24950 26819 36487 39906 21559 23384 19650 32130 31173 28477 31577 37236 45720 21405 28575 24246 34440 37820 18784 23644 27768 29030 27999 41546 42525 15879 33462 41878 30641 BatAge 26.7 28.9 28.4 28.6 27.5 28.3 27.8 29 27.8 29.9 26.6 28.6 28.5 28.9 28.3 27.5 27 29.5 30 28.7 26.9 28.9 28.1 30.4 29.1 28.5 27.7 28.4 30.1 28.8 PAge 26.4 26.4 27.9 29 29.9 28.6 27.1 28.1 27.7 29 28.9 29.9 28.4 28.9 28 28.1 28.3 28.4 27.9 27.9 26.3 28.6 28.1 28.8 30 28 26.9 28.8 29.8 29.1 Est. Payroll $78,399,500 $74,999,750 $153,744,833 $218,682,750 $176,097,333 $111,749,000 $77,329,561 $94,511,067 $89,707,000 $199,902,000 $87,598,000 $126,307,675 $139,712,000 $231,342,096 $72,472,000 $52,077,500 $93,333,700 $155,221,282 $193,229,350 $54,969,067 $84,846,666 $81,187,933 $50,656,166 $137,169,100 $177,021,333 $150,353,500 $48,223,791 $212,536,950 $182,690,767 $152,967,400 W 69 68 89 93 103 78 68 94 75 86 84 81 74 91 79 73 59 87 84 69 71 78 68 86 87 86 68 95 89 95 L 93 93 73 69 58 84 94 67 87 75 78 81 88 71 82 89 103 75 78 93 91 83 94 76 75 76 94 67 73 67 W 79 67 81 78 97 76 64 81 68 74 86 95 85 92 71 68 83 90 87 68 63 98 74 76 84 100 80 88 93 83 L 83 95 81 84 65 86 98 80 94 87 76 67 77 70 91 94 79 72 75 94 99 64 88 86 78 62 82 74 69 79