?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 Growth?In 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.
Solution 13 BSC Step 1 : Given, In an experiment bacteria are allowed to grow for a week. The results are recorded by the end of the day: 20, 40, 80, 160, 320, 640, 1280. We have to fit the suitable model for the given data By using Excel > choose modeling nonlinear regression > choose dependent and independent variables and define function or choose a inbuilt function variable in functions option of the diagonal box. > OK Step 2 : The chart is The exponential model is 4.070 B = 0.460*D Here, B = number of bacteria and D = days of the week