Question: PLEASE SHOW WORK IN EXCEL Refer to the table below for results of a sieve analysis. Determine the percent finer than each sieve and plot

PLEASE SHOW WORK IN EXCEL
Refer to the table below for results of a sieve analysis. Determine the percent finer than each sieve and plot a grain-size distribution curve (Use Excel). Please show your work in a detailed manner.
\table[[U.S. Sieve no.,Mass of soil retained on each sieve (g)],[4,0],[6,0],[10,0],[20,9.1],[40,249.4],[60,179.8],[100,22.7],[200,15.5],[Pan,23.5]]
PLEASE SHOW WORK IN EXCEL Refer to the table

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Civil Engineering Questions!