Calculate the means, standard deviations, sample sizes, and standard errors for each temperature. Make a graph.

Remember to add custom error bars to your graph and delete the chart title and gridlines.

Then, please answer the following questions in a textbox in your spreadsheet next to your data/graph:

1. What is the average of coral growth at each of the four temperature categories?
2. Remember that the average water temperature of the coral's natural habitat is 28 C. What would happen if global climate change causes the average seawater temperature to increase to 30C?

C D E A B Treatment (*C) Initial (mg/cm2) Final (mg/cm2) Change (mg/cm2) 1 563 11 26 552 352 11 3 26 341 461 467 6 26 437 7 26 430 8 26 312 320 364 374 10 26 26 468 479 11 11 26 449 460 17 10 26 398 415 401 7 11 26 394 9 12 26 360 369 528 11 13 28 517 15 14 28 428 443 407 415 8 15 28 16 28 441 452 11 28 472 488 16 17 8 28 383 391 18 13 19 28 466 479 345 354 9 20 28 21 28 393 11 382 28 494 503 9 22 585 12 23 30 573 354 369 15 30 30 532 545 13 410 17 26 30 393 8 30 269 277 517 526 9 30 15 29 30 469 484 30 306 322 16 30 30 431 446 15 31 6 26-30 306 312 6 26-31 372 378 33 11 34 26-32 333 344 11 35 26-33 567 578 26-34 379 392 13 36 15 37 26-35 490 505 38 26-36 391 401 10 26-37 509 523 14 39 8 40 26-38 369 377 14 41 26-39 337 351 Co 42 26-40 365 373 43