Question: Exercise 4 Use Excel to complete the indicated taks: y1 = a1*e^(b1*x) a1 = b1 = 1 y2 = a 2*x^b2 a2 = b2 =

Exercise 4 Use Excel to complete the indicated taks: y1 = a1*e^(b1*x) a1 = b1 = 1 y2 = a 2*x^b2 a2 = b2 = 1 1.5 y3 = a3*(x/(b3+x)) a3 = 1 b3 = 2 2 0.5 0.75 a. Plot each function on a separate graph b. Linearize the functions and plot the linearizations c. Use excel to find a regression line that fits each model (if possible) 1 1.25 1.5 1.75 2 2.25 2.5 2.75 3 Exercise 4 Use Excel to complete the indicated taks: y1 = a1*e^(b1*x) a1 = b1 = 1 y2 = a 2*x^b2 a2 = b2 = 1 1.5 y3 = a3*(x/(b3+x)) a3 = 1 b3 = 2 2 0.5 0.75 a. Plot each function on a separate graph b. Linearize the functions and plot the linearizations c. Use excel to find a regression line that fits each model (if possible) 1 1.25 1.5 1.75 2 2.25 2.5 2.75 3
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
