Analysis of Coral Growth Lab Report

I’m stuck on a Biology question and need an explanation.

 

Read pages 184-185 in your lab manual.

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.

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. 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 30°C?

Please upload your assignment as an Excel file.