Shear Test Data $($psi$)$

Shear

Normal Stress at

Stress Failure

$20,23\mathrm{.}2$

The data at the left comes from a direct shear test of the kind we discussed in class. Plot

these data and find the best$-$fit line using the linear "Add Trendline" function. Use the

parameters of this line to find the Mohr$-$Coulomb failure parameters $C($Cohesion$)$ and $$

$($Angle of Internal Friction$)$

$($degrees$)$:

Note: Now use Excel! No hand plotting required.