Solution Found!
Finding the Best Model. Construct a
Chapter 10, Problem 13 BSC(choose chapter or problem)
Problem 13 BSC
Finding the Best Model. Construct a scatterplot and identify the mathematical model that best fits the given data. Assume that the model is to be used only for the scope of the given data, and consider only linear, quadratic, logarithmic, exponential, and power models.
Bacteria GrowthIn a carefully controlled experiment, bacteria are allowed to grow for a week. The number of bacteria are recorded at the end of each day with these results: 20, 40, 80, 160, 320, 640, 1280.
Questions & Answers
QUESTION:
Problem 13 BSC
Finding the Best Model. Construct a scatterplot and identify the mathematical model that best fits the given data. Assume that the model is to be used only for the scope of the given data, and consider only linear, quadratic, logarithmic, exponential, and power models.
Bacteria GrowthIn a carefully controlled experiment, bacteria are allowed to grow for a week. The number of bacteria are recorded at the end of each day with these results: 20, 40, 80, 160, 320, 640, 1280.
ANSWER:
Solution 13 BSC
A suitable model for the same is given and a suitable non linear regression can be obtained through excel add in excel stat as follows:
• In excel Stat choose –Modeling data-nonlinear regression
• Choose the dependent and the independent variable and define the function or choose a inbuilt function available in functions option of the diagonal box
• Click ok to obtain the result as follows: