draw the particle size distribution curve for the given table using excel. ANALYSES FOR SOIL ASieve sizeMass retained% RetainedCumulative %% Finer(g)0.00retained19.0 mm0.000.00100.0013.2mm18.81.231.2398.779.50mm6.70mm71.24.685.9194.09221.014.5520.4679.544.75 mm128.18.4428.971.12.36 mm165.710.9139.8160.191.18 mm600 um425 um300 um150 um75 um75.94.9944.855.258.43.8448.6451.36277.518.2766.9133.09236.915.6082.5117.4945.17.3218.91.2499.920.08Pan0.20.011000.00Total Mass Retained (g) = 1518.2ANALYSES FOR SOIL BSieve sizeMass retained% RetainedCumulative %retained% Finer(g)9.119.0 mm13.2mm9.50 mm0.600.6099.451.23.383.9896.0284.15.559.5390.476.70mm220.914.5824.1175.894.75 mm133.98.8432.9567.052.36 mm202.913.3946.3453.661.18 mm600 um425 um300 um150 um75 μηPanTotal Mass Retained (g) = 1514.457.03.7650.149.981.45.3755.4744.53151.49.9965.4634.54159.510.5375.9924.01329.121.7397.722.2832.52.1499.860.141.40.091000.00

Answered: draw the particle size distribution…

Engineering

Civil Engineering

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

Structural Analysis

6th Edition

ISBN:9781337630931

Author:KASSIMALI, Aslam.

Publisher:KASSIMALI, Aslam.

Chapter2: Loads On Structures

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Q: What is the area of the below figure if you know x=32.7? (use Simpson's rule) 32 33 28 30 X X- X-…

A: X=32.7

Q: 100 90 80 70 60 50 40 30 20 10 0.5 0.05 Grain size (mm)-log scale From the graph D60 = 0.997 mm; D30…

Q: = P -b- B

A: Given The total length of beam = L Concentrated load P is applied at a "a " distance from A and…

Q: how'd you get the value of q/kH based on the diagram?

A: Data Given: bT' = 0.5sT' = 0.5xB = 0.8 Asked: The value of qkH

Q: A Mohr's circle is shown for a point in a physical object that is subjected to plane stress. If 1…

Q: Determine the amount of force (parallel to the inclination) required to prevent a 250 lb box from…

A: Given data Weight Angle Coefficient of friction

Q: The thin plate shown in the figure below has densityp and thickness t. Calculate product of inertia…

A: let horizontal direction is Z and vertical is Ydevide this section in two area for area 1…

Q: The error in measuring the radius of a 5 cm circular rod was 0.2%. If the cross- sectional area of…

A: A ) Given data : Radius of circular road = 5 cm Error = 0.2 % To Find ;The resulting absolute…

Q: If D10- D30 and D60 represent particle sizes in millimetre, then the correct expression for…

A: Introduction : The question is related with geotechnical engineering . In this question we have to…

Q: What is the equation for Performance (p) based on the given figure? Functions Tie Constraints…

A: Objective is to minimize the mass. Hence the performance Is finally affected by the mass. Based on…

Q: 1. Locate the center of mass of the figure. The base has a mass of 45 kg/m2 and the vertical face…

A: Answer We know that the co-ordinate of centre of mass with reference to y axis is given by y =…

Q: A baseline was measured using a 100m tape which is standardized at 15°C with a standar pull of 10kg.…

Q: Part A Determine the mass moment of inertia of the thin plate about an axis perpendicular to the…

Q: Table 1. (For Groups 1 and 8) Percent Experimental, Values, N Computed Values, N Trials Error 6.533…

A: To find : Values of web in the computed values

Q: Using the data below, compute for the most probable value, individual residual, probable error of…

A: “Since you have posted a question with multiple sub-parts, we will solve the first three subparts…

Q: In the figure below, the weights of the top, middle, and bottom blocks are are follows: • top block…

Q: Using the node method, analyze the following armature (analysis path A-> C -> D ->E ->F) Pc=800lb,…

A: Using the node method, we have to analyze the following armature.Analysis path A-> C -> D…

Q: a- 6.1 m, b- 4.1 m, c - 14.1 kN/m, d- 24 kN. d kN d kN c kN/m "b" m "b" m m FIGURE 3

Q: From the figure shown, Determine: The plastic section modulus about the horizontal axis. x10^6 mm^3…

Q: 1. Consider the data below in the range 0.4< x < 1.2. Calculate P3(0.9) using last four point

A: Note-Since we answer one question at a time so we will answer the first one. Please resubmit…

Q: A particles moves in a straight line with the acceleration shown in the motion curve given. Knowing…

A: Given data: vo=-18 ft/sec

Q: For computing the variance this number is called as the value that is added or subtracted from the…

Q: iven, graph and box the final an

A: Buoyancy force is FB=Vsubmerged×ρwater=30×1×3.25×1gmcc=97.5gWeight of…

Q: omn ample-2 For measuring the area of a figure using planimeter, the as placed outside and the…

Q: From a particle size distribution curve, it is found that 60% of particles are finer than 4.5 mm and…

Q: Discuss the results in the following graph?

Q: A tape 100m long, it's cross sectional area in 0.0585 cm', the apparent length of which was found to…

A: Given that: Nominal length of tape, l = 100mArea of cross section, A = 0.0585…

Q: Give the graph please solve the following. 1. What are the elasticity moduli of Materials A and B,…

A: Given:- The stress-strain graph for the two materials is given For material A, the equation for the…

Q: The equation for the deflected shape of a b follows deflection (0.016x^6 +0.014x^4 +0.01x…

Q: Sieve No. Opening (mm) Mas Retained (grams) 4 4.75 0.0 10 2.00 21.6 20 0.85 49.5 40 0.425 102.6 89.1…

A: To Determine Plot particle size distribution curve D10 D30 D60 Cu Cc

Q: 1. Locate the center of mass of the figure shown below. Where the vertical face has of 30 kg/m^2,…

A: This problem is related to solid mechanics. In this problem given about mass and dimensions of…

Q: QUESTION 2 The sides of a closed figure have been measured and found to have a total lenght of…

Q: The arrow on each of the following diagrams indicates the changes in pressure and temperature…

A: Geological Process: Geological process is a natural process due to which geological features are…

Q: A throat plate is a component that can be found in sewing machines. Shown in the figure is a…

Q: using tape standardiz ull of 10kg. The recorded distance was found out to be 430.60 meters. At the…

Q: Define the Values of factor f for Baguelin et al (1978) ?

A: The flow of fluid includes movement of an unbalanced fluid. As long as unequalled forces are in…

Q: Q2/ Measure the area of given plot in a dimension paper given. All dimensions are in mm. (2 Marks)…

A: First divide the given area into four possible parts, find the individual area of four parts and sum…

Q: 28.30mm 28.20mm чомра 6-A 20mm by 20mm square is etched onto a metal bar prior to loading. Upon…

A: To find Poisson ratio and Young's modulus

Q: Reading sequence 1 2 3 4 5 6 7 8 9 10 11 12 13 Reading the ruler 1.35 1.72 1.98 2.05 2.17 2.76 2.98…

Q: Given data: Coefficient of friction=D0.5 Normal force%3D50 N Find friction force

A: We have to determine the value of friction force as per the given data just like coefficient of…

Q: What is the total length of extra bars at the midspan as shown below, 300 mm 200 mm 300 mm 200 mm 40…

A: GIVEN Continuous beam sketch with reinforcement, Dimensions of beam column and bars. To Determine…

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 used among accountants, management staff, and IT professionals. It is used in various sectors worldwide for data management. An electronic spreadsheet is a system and computer software that could be used to do numerical computations automatically. Spreadsheet application programs are often organized as a table with rows and columns. Each row and column intersect to form a cell, which may be used to store data. These data can take the form of a written label, a number, or a formula that combines information from other cells.

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 step

Solved 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

600 mm 300 mm 300 mm 100 mm * 400 200 mm Figure 2. Determine i, ỹ and z
Identical bricks are used in the construction of a wall as seen in the figure. While the ones standing next to each other are attached to each other, no mortar is used between the rows. What can be the maximum value of x? a 1st row a 2nd row 3rd row 4th row
Question 21 Precision is a term which indicates the degree of conformity of a. repeated measurements of the same quantity to each other b. measured value to its mean value c. measured value to its weighted mean value d. measured value to its true value
A square block, a rectangular block, a triangular block, and a quarter circle block are arranged as shown below. A smaller square chunk was cut from the square block, leaving a hole in the figure. Find the center of mass of the composite figure. Use the axes provided as reference for the origin (0, 0). Square: L units x L units, mass = m Rectangle: (L/2) units x 2L units, mass = 3.5 m Quarter circle: radius = (L/2) units, mass = 5 m Triangle: height = L units, base = (L/2) units, mass = 0.75 m Square hole: L/2 units x L/2 units %3D
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?
tb = (16.67 - 11.11)9.81(0.15 + 0.05) how did the answer became 2.83? when multiplied the following the answer is 10.32?
Please consider te given choices
IV. CALCULATION 1. Calculate the absolute viscosity (u) as follows: 1 [d2 - (p. – p1) · g] 18 = diameter of sphere P. = density of sphere pr = density of fluid Where: d gravitational acceleration, 9.81 m/s? terminal velocity, D/t VT =
NOTE: HANDWRITTEN SOLUTION IS A MUST. SHOW A STEP BY STEP AND DETAILED SOLUTION.Write the following:GIVEN:DERIVATIVE OF THE FORMULA:SOLUTION:ANSWER:
Using the data below, compute for the most probable value, individual residual, probable error of any single measurement, and the relative precision of the mean. Look for: most probable value individual residual probable error of any single measurement relative precision of the mean
1. Solve for the centroidal distances of the figure shown. 20 80 20 20 60 Dimensions in mm