assignment due tomorrow midnight need it presented on excel

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 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 and standard error of coral growth(change mg/cm2) at each of the four temperature categories? What do the standard errors of these means tell you about the reliability of this data? (A small standard error is an indication that the sample mean is a more accurate reflection of the actual population mean).
  2. Remember that the average water temperature of the coral’s natural habitat was 28 °C. What would happen if climate change were to cause the average water temperature to increase to 30°C?
 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.