STUDYING 6Statistical exercise: Corals and TemperatureScience often involves gathering data. The data may becounts or measurements or lists of species or may take manyother forms; however, it is very common that biological datacan be represented numerically. Raw data are often too repeti-tive and boring to be appreciated directly. They need to be sta-tistically summarized. The most ordinary way to get startedon summarizing data is to enter them in a spreadsheet, suchas Excel. Excel also allows one to graph data and do simpleanalyses. Today and in future labs, you will use Excel in thesestatistical exercise sections; today we will focus on how to cre-ate and use a spreadsheet.We will start with data gathered by Hollie Putnam, a stu-dent interested in understanding how water temperature af-fected the growth of coral. To determine this, Hollie took cor-als from their native habitat, where the average water tempera-456789101112361314151617181920212223Create an Excel file with the data in the lab manual for the four treatment temperatures: 26°C, 28°C, 30°C, and 26-30°C fluctuation. Proofread the data you enter to avoid typos. The screenshot on page 185 gives an example of whatthe data will look like in the spreadsheet.Calculate the means, standard deviations, sample sizes, and standard errors for each temperature. Make a graph.Then, please answer the following questions in a textbox in your spreadsheet next to your data/graph:1. What was the mean ± standard error of coral growth (= change mg/cm2) at each of the four temperaturecategories?2. Remember that the average water temperature of the coral's natural habitat was 28 °C. What would happen ifglobal climate change causes the average seawater temperature to increase to 30°C?24252627282930313233343536373839404142A1Treatment(°C)26262626262626262626262828282828282828282830303030303030303026-3026-3026-3026-3026-3026-3026-3026-3026-3026-3026-30InitialFinal(mg/cm2) (mg/cm2)552563341352461467430437312364468449398394360517428407441472383466345382494573354532393269517469306431306372333567379490391509369337365320374479460415401369528443415452488391479354393503585369545410430277526484322446312379344578392505401523377351373ture was 28 °C, and grew them in a lab. She measured coralgrowth in four temperature regimes: 26 °C, 28 °C, 30 °C, anda regime that fluctuated daily between a low of 26 °C and ahigh of 30 °C. She weighed the corals at the beginning of theexperiment and at the end. Growth is to be calculated as thefinal weight minus the initial weight.Change(mg/cm2)11.000Open a new Excel spreadsheet, and try to make it look likethe one to the right with the first number in cell A2. Al-though it is not necessary, you may want to make the head-ings in row 1 wrap inside the cells; to do this, select row 1 byclicking on the 1 in the gray margin, right click to format, goto alignment and click on the box in front of "wrap text."• Type in all the numbers from the data to the right. Whendone, carefully proofread them to be sure you have enteredthe data correctly.. In row 2, column D, type the formula -C2-B2 and press re-turn. This will give you the difference, in other words, theamount of growth. Now, copy that cell down to D42. If youhave done it right, the formula will change in each cell so asto maintain the same relative position. In D24, you will have-C24-B24, which comes to 15.• To calculate the mean for the 26 °C temperature regime,type =AVERAGE(D2:D12) into cell E2 then press return.The mean is the sum of all the growth amounts divided bythe number of replicate coral fragments. Now calculate theaverages for the other three treatments by using the samefunction in cells E13, E23, and E32 for the other treatmentgroups. Be sure the cell range in your equations is correct.Calculate the standard deviations, samples sizes, and stan-dard errors. Make a graph. Taking into account the standarderrors, think about what aspects of the results are believable.1. What was the mean ± SE (n) coral growth at:26 °C28 °C30 °C26-30 °C fluctuating daily2. Remember that the average water temperature of their natu-ral habitat was 28 "C. What would happen if climate change.were to cause the average water temperature to increase to 30°C?If you made a mistake, double check your data entry and thecell range in your equations. Data are often very expensive togather, so you need to get in the habit of proofreading yourdata to avoid typos.

Given Information: Consider the given data: Treatment Initial Final 26 552 563 26 341 352…

STUDYING 6 Statistical exercise: Corals and Temperature Science often involves gathering data. The data may be i counts or measurements or lists of species or may take many other forms; however, it is very common that biological data can be represented numerically. Raw data are often too repeti- tive and boring to be appreciated directly. They need to be sta- tistically summarized. The most ordinary way to get started. on summarizing data is to enter them in a spreadsheet, such as Excel. Excel also allows one to graph data and do simple analyses. Today and in future labs, you will use Excel in these statistical exercise sections; today we will focus on how to cre ate and use a spreadsheet. We will start with data gathered by Hollie Putnam, a stu- dent interested in understanding how water temperature af- fected the growth of coral. To determine this, Hollie took cor- als from their native habitat, where the average water tempera- 3 6 7 A 9 10 11 33 12 11 14 15 16 12 18 40 19 20 21 22 23 24 25 20 26 27 28 Create an Excel file with the data in the lab manual for the four treatment temperatures: 26°C, 28°C, 30°C, and 26- 30°C fluctuation. Proofread the data you enter to avoid typos. The screenshot on page 185 gives an example of what the data will look like in the spreadsheet. Calculate the means, standard deviations, sample sizes, and standard errors for each temperature. Make a graph. Then, please answer the following questions in a textbox in your spreadsheet next to your data/graph: 1. What was the mean ± standard error of coral growth (= change mg/cm2) at each of the four temperature categories? 2. Remember that the average water temperature of the coral's natural habitat was 28 °C. What would happen in global climate change causes the average seawater temperature to increase to 30°C? 30 31 32 33 34 35 36 24 37 38 39 40 41 42 8 Treatment Initial ("C) (mg/cm2) (mg/cm2) 26 V 26 26 26 26 26 26 26 26 40 26 26 28 26 28 28 20 28 28 28 28 28 30 30 30 30 30 30 M 30 30 30 26-30 26-30 26-30 26-30 26-30 26-30 26-30 26-30 26-30 26-30 26-30 552 341 461 430 312 364 468 449 390 W 394 360 517 420 407 441 472 383 466 345 382 494 573 354 532 C Final 393 269 517 440 469 306 431 306 372 333 567 379 490 391 509 369 337 365 563 352 467 437 320 374 479 460 415 401 369 528 443 415 452 488 391 479 354 393 503 585 369 545 410 277 526 484 322 446 312 370 344 528 ▬▬▬▬▬▬▬▬▬▬ Change (mg/cm2) 11.000 392 505 401 523 377 351 373 ture was 28 °C, and grew them in a lab. She measured coral growth in four temperature regimes: 26 °C, 28 °C, 30 °C, and a regime that fluctuated daily between a low of 26 "C and a high of 30 °C. She weighed the corals at the beginning of the experiment and at the end. Growth is to be calculated as the final weight minus the initial weight. Open a new Excel spreadsheet, and try to make it look like. the one to the right with the first number in cell A2. Al- though it is not necessary, you may want to make the head- ings in row 1 wrap inside the cells; to do this, select row 1 by clicking on the 1 in the gray margin, right click to format, go to alignment and click on the box in front of "wrap text." Type in all the numbers from the data to the right. When done, carefully proofread them to be sure you have entered the data correctly. In row 2, column D, type the formula -C2-B2 and press re- turn. This will give you the difference, in other words, the amount of growth. Now, copy that cell down to D42. If you have done it right, the formula will change in each cell so as to maintain the same relative position. In D24, you will have -C24-B24, which comes to 15. To calculate the mean for the 26 °C temperature regime, type "AVERAGE(D2:D12) into cell E2 then press return. The mean is the sum of all the growth amounts divided by the number of replicate coral fragments. Now calculate the averages for the other three treatments by using the same function in cells E13, E23, and E32 for the other treatment groups. Be sure the cell range in your equations is correct. Calculate the standard deviations, samples sizes, and stan- dard errors. Make a graph. Taking into account the standard errors, think about what aspects of the results are believable. 1. What was the mean a SE (n) coral growth at: 26 °C 28 °C 30 °C 26-30 °C fluctuating daily 2. Remember that the average water temperature of their natu- ral habitat was 28 "C. What would happen if climate change were to cause the average water temperature to increase to 30 "C? If you made a mistake, double check your data entry and the cell range in your equations. Data are often very expensive to gather, so you need to get in the habit of proofreading your data to avoid typos.