1. Engineering
  2. Mechanical Engineering
  3. is this excel formula correct for the equation we are...

Question: is this excel formula correct for the equation we are...

Question details

Background In structural dynamics, it is critical to have a firm understanding of the behavior of single degree of freedom systems. A single degree of freedom system is a system whose motion is defined by just a single independent coordinate or function. Define The non-dimensional response of a single degree of freedom system is given by t,Zi Where zeta, 0.05,0.2,0.5) and 0く 12 , with increments of 0.5 You are required to create a graph of response vs. time (seconds).

STDEV × fz =1-(((EXPl-SGS5*A6))/[SQRT(1-POWER(SG$5,2)))*(COS(SQRT(1-POWER(SG$5,2))*A6)))) v 1 ENGR 1181 -CLASS 06 APPLICATION 2 NAME: INSTRUCTOR SEAT #: R(13) a: 1 0.05 0.20 0.50 RGI) (С2) ol)*A6)) ζ2 0.02062073-0.154700538 7 0.5 0.142720501 0.1851249410.183716873 0.5462644 1.5 0.93255353 0.92368714 0.853589457 2 1.374954837 1.259340685 1.068202907 11 2.5 1.706235151 1.47660072 1.185230743 3 1.85269921 1.548716549 1.220520193 1.7883828 1.485995253 1.199432994 41.538925528 1.326797031 1.148214854 15 4.5 1.172930949 1.123937585 1.088590434 5 0.783487637 0.930347543 1.035356187 17 5.5 0.464744093 0.787305878 0.996255313 6 0.289372975 0.717391854 0.973260986 1 0.484402885 0.534402765 Response of a Single 10 12 13 3.5 14 1.5 16 18

Is this Excel formula correct for the equation? We are required to verify it by hand but I am not getting the same numbers as calculated by Excel. Thank you!

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution