Geo Tech Solve 2-4 using MICROSOFT EXCEL ONLY DISCLAIMER: USE EXCEL ONLY The fol

Question

Geo Tech
Solve 2-4 using MICROSOFT EXCEL ONLY
DISCLAIMER: USE EXCEL ONLY

The following tables show results from sieve analysis, hydrometer, and Atterberg limits of six soil samples (S-1 to S-6) Table 1 - Sieve and Hydrometer Test Results. Sieve #10 | #40 | #200 | Hydrometer #4 0.425 0.075 0.002 Size (mm) 4.75 100 90 100 100 96 98 20 S-1 S-2 S-3 S-4 S-5 S-6 98 80 95 80 92 60 50 10 80 92 70 79 50 40 70 40 21 20 Table 2 - Atterberg Limit Test Results. Liquid Limit Soil Sample S-1 S-2 S-3 S-4 S-5 S-6 Plastic Limit 70 25 Non-Plastic 28 25 60 38 18 21 40 24 S standard sieve size, what are the screen openings for sieve #4, #10, #40, and ForU #200? Plot the grain size distribution or gradation curve for each sample. Follow instructions below: 1) 2) Use Microsoft Excel or semi-logarithmic graph paper. X-axis should be in log scale o o Plot three curves on the same plot and label each curve (i.e. one plot shows S-1, S-2 and S-3; the other shows S-4, S-5 and S-6). Show all data points and connect with straight lines. If you use Excel, graphs should be in the form of Scatter with Straight Line'. o According to UscS, classity each sample with the two-lettr ymbol (c.g. CH, SP. etc.) AND group name. Determine the percentage content of gravel, sand, silt, and clay sizes present in each soil sample 3) 4)

Explanation / Answer

Sieve Size (mm) s4 s5 s6 4.75 90 90.4 90.2 2 82 81.2 84.2 1 82 81.2 84.2 0.6 82 81.2 84.2 0.425 75 73.3 79.2 0.3 75 73.3 79.2 0.15 75 73.3 79.2 0.075 71 66.3 75.2 0.002 70.9 64.2 73.2 Sieve Size (mm) % Finer-S1 %Finer-s2 %finer-s3 4.75 90 91 90 2 80.2 83 80.5 1 80.2 83 80.5 0.6 80.2 83 80.5 0.425 72.2 77.5 71.3 0.3 72.2 77.5 71.3 0.15 72.2 77.5 71.3 0.075 67.2 76.5 70.8 0.002 65.2 76.4 70.7

Related Questions

Navigate

• Browse (All)
• Browse G
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.