Problem 3 An earthquake engineer derives a mathematical formula to predict the horizontal displacement of a building subject to an initial displacement of 3 cm. This horizontal displacement simulates a static force induced by an earthquake. The formula to calculate the horizontal displacement of the building ( x ) in centimeters over time (t) is: x = e-kit (k, cos(@t) + k, sin(@t)) where: kj,k,,kz and o are constants specific to each building and t is the time in seconds. The values of the constants k,k,kz and o are: 0.025,3.00, 0.238 and 0.315, respectively. a) Create a VBA function to estimate the horizontal displacement (x ) of the b uilding as a function of time (t ). b) Using the function created in part (a) calculate the building displacement for the first 100 seconds after the earthquake hits (from zero to 100 seconds every second). Display the values of displacement and time in two columns in the worksheet. c) Plot the displacement (x) as a function of time in the worksheet. Label the axes accordingly. d) Using the solution obtained in part (a) find the displacement of the building 60 seconds after the simulated earthquake strikes. Problem 3 An earthquake engineer derives a mathematical formula to predict the horizontal displacement of a building subject to an initial displacement of 3 cm. This horizontal displacement simulates a static force induced by an earthquake. The formula to calculate the horizontal displacement of the building ( x ) in centimeters over time (t) is: x = e-kit (k, cos(@t) + k, sin(@t)) where: kj,k,,kz and o are constants specific to each building and t is the time in seconds. The values of the constants k,k,kz and o are: 0.025,3.00, 0.238 and 0.315, respectively. a) Create a VBA function to estimate the horizontal displacement (x ) of the b uilding as a function of time (t ). b) Using the function created in part (a) calculate the building displacement for the first 100 seconds after the earthquake hits (from zero to 100 seconds every second). Display the values of displacement and time in two columns in the worksheet. c) Plot the displacement (x) as a function of time in the worksheet. Label the axes accordingly. d) Using the solution obtained in part (a) find the displacement of the building 60 seconds after the simulated earthquake strikes