Most analytical machines used in science can either measure absorbance of light, like the spectrophotometers used in BioZ 151 and 152 labs, or can measure change in electrical conductance. In order to convert things like absorbance values into concentration data. a linear regression is used. In order to determine nitrite concentration in water samples, nitrite is reacted with several chemicals to produce a purple color. The absorbance of the solution is measured from known amounts of nitrite to produce a standard curve to analyze samples. Use the data in the provided table, or from the linked spreadsheet Ego make a graph and perform a linear regression using treadline. mg/L NO3_ Absorbance 0 0 0.1 0.183 0.3 0.542 0.5 0.914 0.7 1.298 1 1.61 In order for this to work, samples must be diluted prior to measurement so that the concentration falls within the range of the standard curve. If a sample underwent a 80 dilution, and produce an absorbance value of 1.487, what is the resultant concentration of NOg' in mg per L? Report your answer to two decimal places. Tip: The regression equation will give you the final concentration. The dilution is equal to V1/V2. The question is asking for the initial concentration. A B C 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 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 22 23This linked dataset E>_ ists 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 ofa human of 53.48 kilograms is likely to be. Some hints and suggestions: 0 Remember that your variables have been transformed, so you will need to account for this as you find the base rate in Watts. 0 When answering, input only digits, with no spaces, and round to two decimal places