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

Structural Analysis

6th Edition

ISBN: 9781337630931

Author: KASSIMALI, Aslam.

Publisher: Cengage,

See similar textbooks

Concept explainers

Electronic Spreadsheet

Tabular listing has many advantages ranging from time management to efficient scheduling of tasks. Electronic spreadsheets allow the user to tabulate and analyze data, using its easy-to-use interface. An electronic spreadsheet is a staple application use…

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

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

See solution Check out a sample Q&A here

Step 1

Step 2

Step 3

Step 4

Step by stepSolved in 4 steps with 2 images

See solution

Check out a sample Q&A here

Knowledge Booster

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

how did you know k=2.3? where did th evalue of 2.3 come from?
What is the volume surface mean diameter in micrometers?
A person by the name of Huebscher developed a relationship between theequivalent size of round ducts and rectangular ducts according to D = diameter of equivalent circular duct (mm)a = dimension of one side of the rectangular duct (mm)b = the other dimension of the rectangular duct (mm)Using Excel, create a table that shows the relationship between the circular and the rectangular duct dimensions, similar to the one shown in the accompanying table.

Recommended textbooks for you

Structural Analysis
Civil Engineering
ISBN:9781337630931
Author:KASSIMALI, Aslam.
Publisher:Cengage,
Structural Analysis (10th Edition)
Civil Engineering
ISBN:9780134610672
Author:Russell C. Hibbeler
Publisher:PEARSON
Principles of Foundation Engineering (MindTap Cou...
Civil Engineering
ISBN:9781337705028
Author:Braja M. Das, Nagaratnam Sivakugan
Publisher:Cengage Learning
Fundamentals of Structural Analysis
Civil Engineering
ISBN:9780073398006
Author:Kenneth M. Leet Emeritus, Chia-Ming Uang, Joel Lanning
Publisher:McGraw-Hill Education
Sustainable Energy
Civil Engineering
ISBN:9781337551663
Author:DUNLAP, Richard A.
Publisher:Cengage,
Traffic and Highway Engineering
Civil Engineering
ISBN:9781305156241
Author:Garber, Nicholas J.
Publisher:Cengage Learning