Here is a link to a data set that contains the body masses (in grams) and basal metabolic rates for 17 species of primates. Input numeric answers to four decimal places. Scientists want to know if body mass is an acceptable predictor of metabolic rate for primates. Use this information and the provided data set to answer the following questions. Which, body mass or basal metabolic rate, is the control variable? Which, body mass or basal metabolic rate, is the response variable? Using Excel, graph the data as a scatter plot, then right click the data set to add a trendline. Format the trendline so that it includes the equation and the R2 value. What is the slope of the trendline for the data? What is the y-intercept of the trendline for the data? What is the R2 value of the data set? Is the linear model a good fit for this data, yes or no? Using the Analysis ToolPac Add-In for Excel, perform a regression analysis on the data set. What is the P value for the t-test that the slope of the line is not equal to zero? Report the P value in scientific notation just as you see it in Excel. o e.g. 0.000000012345 would be 1.12345E-8 o Report your answer to four decimal places. Is the slope of the line significant, yes or no? Based on the equation of the line, what would the basal metabolic rate of a primate weighing 70 kg be? • Report your answer to four decimal places Primate Mass Metabolic Rate 4670 11.57 1020 2.56 206 0.73 190 0.86 105 0.55 300 1.1 261.5 1.2 1039 2.93 61 0.42 261.5 1.2 70000 82.78 2330 4.2 1300 1.73 9500 16.05 1011 2.07 225 1.3 800 4.39