Use Excel to complete the indicated taks: y2 =a2*x^b2 y1 = a1*e^(b1*x) a1 = 1 a2...

Transcribed Image Text:

Use Excel to complete the indicated taks: y2 =a2*x^b2 y1 = a1*e^(b1*x) a1 = 1 a2 = b1 = 2 b2 = y3 = a3*(x/(b3+x)) 1 a3 = 1 1.5 b3 = 2 X 0.5 0.75 1 a. Plot each function on a separate graph b. Linearize the functions and plot the linearizations 1.25 c. Use excel to find a regression line that fits each model (if possible) 1.5 1.75 2 2.25 2.5 2.75 3 Use Excel to complete the indicated taks: y2 =a2*x^b2 y1 = a1*e^(b1*x) a1 = 1 a2 = b1 = 2 b2 = y3 = a3*(x/(b3+x)) 1 a3 = 1 1.5 b3 = 2 X 0.5 0.75 1 a. Plot each function on a separate graph b. Linearize the functions and plot the linearizations 1.25 c. Use excel to find a regression line that fits each model (if possible) 1.5 1.75 2 2.25 2.5 2.75 3