Question

3. Analyze the data in the Excel file to produce a liquefaction susceptibility analysis graph like the one in Figure 24 of the course document. Do the analysis

for an expected peak ground acceleration of 0.1 g's. Plot the le profile and the liquefaction susceptibility (CSR's) profile. Use the appropriate formats for the

graphs. Align the graphs perfectly next to one another. Important: in Excel, use markers only (not lines) for the orange CSR curve.

Submit a single pdf file with one sheet containing two perfectly aligned plots: Ic vs. depth (in m) and CSR's vs. depth (in m).

Question image 1