Homework on CorrelationfRegression Upload the completed assignment to Canvas. Please type up your results and paste your graphs into a word document; when you paste your graphs, use the \"paste special\" option in the Edit menu and paste special as a metale. Use W (vassarstatsnet) to conduct the statistical tests. A) The following two data sets are from an experiment examining 02 consumption rates by clams that are exposed to one of three temperatures, 15C, 25C, and 35C. In the rst experiment, they got the following results (total sample size = 15 clams, meaning that each clam was tested only once - at one temperature; rates given as milliliters Oz/minute): IRE-\".15- . Find the mean and standard deviation for each temperature treatment. Excel will calculate these if you type into a cell =average0 or =5tdm) and within the parentheses you identify the cells you want to go into the calculation. B) The experiment was repeated, with better laboratory technique and different clams, yielding the following data (total sample size = 15 clams, data as ml Ozfmin): mm - Find the mean and standard deviation for each temperature treatment. 0 How do these means and SD's compare to the previous set of data? C) Is there a relationship between water temperature and 02 consumption? You could test this with a correlationfregression analysis, where each (X,Y) set of points is (W3 e. g., (15, 5.90), (15, 5.92), etc. Remember to put all 15 (X,Y) pairs from an experiment into the same columns to get all 15 data points on the same graph. 0 Organize the data for each experimental dataset independently. Each dataset should have two columns (one for temperature, one for 02 consmption) and fteen rows (one for each clam). Use these reorganized data to make scatterplots and transfer the data to 3535mm 0 Make a separate scatterplot for each experiment with temperatures on the X-axis; each temperature should have ve data points associated with it do not graph the means! Find and report the correlation coefcients (R2 values) and line equations for each data set. 0 Calculate the regression p-value for each data set using mm 0 Write summary sentences for each experiment that describe the results, using the proper statistical information. Also address: 0 How did the regression p-values compare? 0 What do you think the researcher could do to increase condence in the results