draw the particle size distribution curve for the given table using excel.

Fundamentals of Geotechnical Engineering (MindTap Course List)
5th Edition
ISBN:9781305635180
Author:Braja M. Das, Nagaratnam Sivakugan
Publisher:Braja M. Das, Nagaratnam Sivakugan
Chapter10: Shear Strength Of Soil
Section: Chapter Questions
Problem 10.24CTP
icon
Related questions
icon
Concept explainers
Question

draw the particle size distribution curve for the given table using excel.

ANALYSES FOR SOIL A
Sieve size
Mass retained
% Retained
Cumulative %
% Finer
(g)
0.00
retained
19.0 mm
0.00
0.00
100.00
13.2mm
18.8
1.23
1.23
98.77
9.50mm
6.70mm
71.2
4.68
5.91
94.09
221.0
14.55
20.46
79.54
4.75 mm
128.1
8.44
28.9
71.1
2.36 mm
165.7
10.91
39.81
60.19
1.18 mm
600 um
425 um
300 um
150 um
75 um
75.9
4.99
44.8
55.2
58.4
3.84
48.64
51.36
277.5
18.27
66.91
33.09
236.9
15.60
82.51
17.49
45.
17
.32
18.9
1.24
99.92
0.08
Pan
0.2
0.01
100
0.00
Total Mass Retained (g) = 1518.2
ANALYSES FOR SOIL B
Sieve size
Mass retained
% Retained
Cumulative %
retained
% Finer
(g)
9.1
19.0 mm
13.2mm
9.50 mm
0.60
0.60
99.4
51.2
3.38
3.98
96.02
84.1
5.55
9.53
90.47
6.70mm
220.9
14.58
24.11
75.89
4.75 mm
133.9
8.84
32.95
67.05
2.36 mm
202.9
13.39
46.34
53.66
1.18 mm
600 um
425 um
300 um
150 um
75 μη
Pan
Total Mass Retained (g) = 1514.4
57.0
3.76
50.1
49.9
81.4
5.37
55.47
44.53
151.4
9.99
65.46
34.54
159.5
10.53
75.99
24.01
329.1
21.73
97.72
2.28
32.5
2.14
99.86
0.14
1.4
0.09
100
0.00
Transcribed Image Text:ANALYSES FOR SOIL A Sieve size Mass retained % Retained Cumulative % % Finer (g) 0.00 retained 19.0 mm 0.00 0.00 100.00 13.2mm 18.8 1.23 1.23 98.77 9.50mm 6.70mm 71.2 4.68 5.91 94.09 221.0 14.55 20.46 79.54 4.75 mm 128.1 8.44 28.9 71.1 2.36 mm 165.7 10.91 39.81 60.19 1.18 mm 600 um 425 um 300 um 150 um 75 um 75.9 4.99 44.8 55.2 58.4 3.84 48.64 51.36 277.5 18.27 66.91 33.09 236.9 15.60 82.51 17.49 45. 17 .32 18.9 1.24 99.92 0.08 Pan 0.2 0.01 100 0.00 Total Mass Retained (g) = 1518.2 ANALYSES FOR SOIL B Sieve size Mass retained % Retained Cumulative % retained % Finer (g) 9.1 19.0 mm 13.2mm 9.50 mm 0.60 0.60 99.4 51.2 3.38 3.98 96.02 84.1 5.55 9.53 90.47 6.70mm 220.9 14.58 24.11 75.89 4.75 mm 133.9 8.84 32.95 67.05 2.36 mm 202.9 13.39 46.34 53.66 1.18 mm 600 um 425 um 300 um 150 um 75 μη Pan Total Mass Retained (g) = 1514.4 57.0 3.76 50.1 49.9 81.4 5.37 55.47 44.53 151.4 9.99 65.46 34.54 159.5 10.53 75.99 24.01 329.1 21.73 97.72 2.28 32.5 2.14 99.86 0.14 1.4 0.09 100 0.00
Expert Solution
steps

Step by step

Solved in 4 steps with 2 images

Blurred answer
Knowledge Booster
Electronic spreadsheet
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, civil-engineering and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Fundamentals of Geotechnical Engineering (MindTap…
Fundamentals of Geotechnical Engineering (MindTap…
Civil Engineering
ISBN:
9781305635180
Author:
Braja M. Das, Nagaratnam Sivakugan
Publisher:
Cengage Learning