This linked dataset Links to an external site. Lists body masses in kilograms for 20 mammal species, and their corresponding base metabolic rate in Watts. Copy the data into your preferred spreadsheet program, perform a natural log transform of both the base metabolic rates and the body masses of the mammals to improve the linear relationship, and then perform a linear regression on the data using the trendline feature. Use the linear regression equation to estimate (based on these data) what the base metabolic rate of a human of 40.57 kilograms is likely to be.
Some hints and suggestions: • Remember that your variables have been transformed, so you will need to account for this as you find the base rate in Watts. • When answering, input only digits, with no spaces, and round to two decimal places. 1 Mammal Size (kg) Base Metabolism (Watts) 2 4.67 11.57 3 1.02 2.56 4 0.206 0.73 5 0.19 0.86 6 0.105 0.55 7 0.3 1.1 8 61.235 61.16 9 0.2615 1.2 10 1.039 2.93 11 0.061 0.42 12 0.2615 1.2 13 127.006 105.34 14 70 82.78 15 2.33 4.2 16 1.3 1.73 17 9.5 16.05 18 1.011 2.07 19 0.225 1.3 20 0.8 4.39 21 102.058 89.55