Homework Help is Here – Start Your Trial Now!
Engineering
Civil Engineering
draw the particle size distribution curve for the given table using excel.

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

Structural Analysis
Structural Analysis
6th Edition
ISBN:9781337630931
Author:KASSIMALI, Aslam.
Publisher:KASSIMALI, Aslam.
Chapter2: Loads On Structures
Section: Chapter Questions
Problem 1P
See similar textbooks
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

SEE SOLUTIONCheck out a sample Q&A here
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.
Recommended textbooks for you
Structural Analysis
Structural Analysis
Civil Engineering
ISBN:
9781337630931
Author:
KASSIMALI, Aslam.
Publisher:
Cengage,
Structural Analysis (10th Edition)
Structural Analysis (10th Edition)
Civil Engineering
ISBN:
9780134610672
Author:
Russell C. Hibbeler
Publisher:
PEARSON
Principles of Foundation Engineering (MindTap Cou…
Principles of Foundation Engineering (MindTap Cou…
Civil Engineering
ISBN:
9781337705028
Author:
Braja M. Das, Nagaratnam Sivakugan
Publisher:
Cengage Learning
Fundamentals of Structural Analysis
Fundamentals of Structural Analysis
Civil Engineering
ISBN:
9780073398006
Author:
Kenneth M. Leet Emeritus, Chia-Ming Uang, Joel Lanning
Publisher:
McGraw-Hill Education
Sustainable Energy
Sustainable Energy
Civil Engineering
ISBN:
9781337551663
Author:
DUNLAP, Richard A.
Publisher:
Cengage,
Traffic and Highway Engineering
Traffic and Highway Engineering
Civil Engineering
ISBN:
9781305156241
Author:
Garber, Nicholas J.
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS