I need some help with this problem.

Q R H O G A B Ver A Question 2: For the data set provided, use the generalized regression analysis to W N determine the two coefficients, A & B in the model. Include a measure of goodness of fit. The model equation, f(t)estimates is: t f(t) f(t) estimate f(t) estimate - f(t) (f(t) estimate - f(t))" (f(t)estimate-V)" A = f(t) = sin At * cos Bt 5 0.0 0.000 B = 6 0.1 0.049 Remember that the Wile E. Coyote example is a good one to model this solution after. 0.2 0.095 Also, Solver will be required to optimize the value of the constants. SSE = 0.3 0.135 f(t)estimate is calculated by making a Guess for A and B and referencing them in the model 0.4 0.164 y = equation. y is the average of the original f(t). SSE is what you are trying to minimize 10 0.5 0.181 SSTO = using Solver. 11 0.6 0.184 R2 = 12 0.7 0.171 Overlay the graph of your model on the original data plot and create a legend 13 0.8 0.141 14 0.9 0.095 Hint: Try initial guess A = 0.45 and B = 1.55 15 1.0 0.034 16 1.1 -0.041 17 1.2 -0.128 Data set 18 1.3 -0.224 1.000 19 1.4 -0.325 0.800 20 1.5 -0.428 0.600 21 1.6 -0.529 .. ... 0.400 22 1.7 -0.624 ....... . .. .. .. em....... 23 1.8 -0.708 0.200 0.000 24 1.9 -0.779 IN -0.200 0.0 . 30.0 25 2.0 0.833 .... .. .p 2.1 -0.867 -0.400 26 .. . . 27 2.2 -0.880 -0.600 28 2.3 0.870 -0.800 -1.000 29 2.4 -0.836 Time [t] 30 2.5 -0.779 31 2.6 -0.699 32 2.7 -0.600 33 2.8 -0.483 34 2.9 -0.352 35 3.0 -0.210 36 3.1 -0.062 37 3.2 0.087