Do this problem using Excel. The following data were obtained in calibrating a calcium ion electrode for the determination of pCa. A linear relationship between the potential and pCa is known to exist. pCa = - log [Ca²*] E, mV 5.00 - 53.8 4.00 - 27.7 3.00 + 2.7 2.00 + 31.9 1.00 + 65.1 a. Plot the data and draw a line through the points by eye. b. Find the least-squares expression for the best straight line among the points. Plot this line. c. Do an ANOVA and report the statistics given in the ANOVA table. Comment on the meaning of the ANOVA statistics. d. Calculate the pCa of a serum solution in which the electrode potential was 15.3 mV. Find the absolute and relative standard deviations for pCa if the result was from a single voltage measurement.

Do this problem using Excel. The following data were obtained in calibrating a calcium ion electrode for the determination of pCa. A linear relationship between the potential and pCa is known to exist. pCa = - log [Ca²*] E, mV 5.00 - 53.8 4.00 - 27.7 3.00 + 2.7 2.00 + 31.9 1.00 + 65.1 a. Plot the data and draw a line through the points by eye. b. Find the least-squares expression for the best straight line among the points. Plot this line. c. Do an ANOVA and report the statistics given in the ANOVA table. Comment on the meaning of the ANOVA statistics. d. Calculate the pCa of a serum solution in which the electrode potential was 15.3 mV. Find the absolute and relative standard deviations for pCa if the result was from a single voltage measurement.

College Algebra

1st Edition

ISBN:9781938168383

Author:Jay Abramson

Publisher:Jay Abramson

Chapter6: Exponential And Logarithmic Functions

Section6.8: Fitting Exponential Models To Data

Problem 3TI: Table 6 shows the population, in thousands, of harbor seals in the Wadden Sea over the years 1997 to...

See similar textbooks

Similar questions

For the following exercises, refer to Table 9. Use the LOGarithm option of the REGression feature to find a logarithmic function of the form y=a+bln(x) that best fits the data in the table.
Enter the data from Table 2 into a graphing calculator and graph the ranking scatter plot. Determine whetherthe data from the table would likely represent a function that is linear, exponential, or logarithmic.
What type (s) of translation(s), if any, affect the range of a logarithmic function?
What is the y -intercept on the graph of the logistic model given in the previous exercise?
Table 4 gives the population of a town (in thousand) from 2000 to 2008. What was the average rate of change of population (a) between 2002 and 2004, and (b) between 2002 and 2006?
What type (s) of translation (s), if any, affect thedomain ofa logarithmic function?
What does the y -intercept on the graph of a logistic equation correspond to for a population modeled by that equation?
For the following exercises, refer to Table 12. Graph the logistic equation on the scatter diagram.
The population of a culture of bacteria is modeled by the logistic equation P(t)=14,2501+29e0.62t where t is in
To the nearest whole number, what is the initial value of a population modeled by the logistic equation P(t)=1751+6.995e0.68t ? What is the carrying capacity?
Is f(x)=0 in the range ofthe function f(x)=log(x) ?If so, for what value ofx? Verify the result.