1. You are to determine the optimum water content and the corresponding maximum dry unit weight of the soil at a location through testing five soil samples with different water content. The data is summarized in the table below: Dry unit weight y, N/m3 15365.91 17004.00 17221.22 16093.31 15243.99 water content (w, %) 10.45 12.50 15.07 17.65 19.70

Structural Analysis
6th Edition
ISBN:9781337630931
Author:KASSIMALI, Aslam.
Publisher:KASSIMALI, Aslam.
Chapter2: Loads On Structures
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

How to determine the optimum water content and the corresponding maximum dry unit weight of the soil using graph in Excel?

1. You are to determine the optimum water content and the corresponding maximum
dry unit weight of the soil at a location through testing five soil samples with
different water content. The data is summarized in the table below:
Dry unit
weight y,
N/m3
15365.91
17004.00
17221.22
16093.31
15243.99
water
content (w,
%)
10.45
12.50
15.07
17.65
19.70
Create a program that will give a smooth curve that will pass through the data points
and determine the optimum water content % (independent variable) and the
maximum dry unit weight (dependent variable) of the soil at the location. hint:
maximum dry unit weight is the peak of the curve and the derivative at that point is
zero. You may use any method for interpolation discussed in class
Transcribed Image Text:1. You are to determine the optimum water content and the corresponding maximum dry unit weight of the soil at a location through testing five soil samples with different water content. The data is summarized in the table below: Dry unit weight y, N/m3 15365.91 17004.00 17221.22 16093.31 15243.99 water content (w, %) 10.45 12.50 15.07 17.65 19.70 Create a program that will give a smooth curve that will pass through the data points and determine the optimum water content % (independent variable) and the maximum dry unit weight (dependent variable) of the soil at the location. hint: maximum dry unit weight is the peak of the curve and the derivative at that point is zero. You may use any method for interpolation discussed in class
Expert Solution
steps

Step by step

Solved in 4 steps with 1 images

Blurred answer
Knowledge Booster
Soil engineering for highway design
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
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