Solution Found!

Finding the Best Model. Construct a

Chapter 10, Problem 13 BSC

(choose chapter or problem)

Get Unlimited 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.

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:

Add to cart


Study Tools You Might Need

Not The Solution You Need? Search for Your Answer Here:

×

Login

Login or Sign up for access to all of our study tools and educational content!

Forgot password?
Register Now

×

Register

Sign up for access to all content on our site!

Or login if you already have an account

×

Reset password

If you have an active account we’ll send you an e-mail for password recovery

Or login if you have your password back