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
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
Chapter2: Loads On Structures
Section: Chapter Questions
Problem 1P
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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F56327a7e-0891-4f50-83a1-8913afba2acc%2F763988d7-4d80-464d-97bd-05541a596944%2Ftz9eq3f_processed.jpeg&w=3840&q=75)
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
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
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.Recommended textbooks for you
![Structural Analysis](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781337630931/9781337630931_smallCoverImage.jpg)
![Structural Analysis (10th Edition)](https://www.bartleby.com/isbn_cover_images/9780134610672/9780134610672_smallCoverImage.gif)
Structural Analysis (10th Edition)
Civil Engineering
ISBN:
9780134610672
Author:
Russell C. Hibbeler
Publisher:
PEARSON
![Principles of Foundation Engineering (MindTap Cou…](https://www.bartleby.com/isbn_cover_images/9781337705028/9781337705028_smallCoverImage.gif)
Principles of Foundation Engineering (MindTap Cou…
Civil Engineering
ISBN:
9781337705028
Author:
Braja M. Das, Nagaratnam Sivakugan
Publisher:
Cengage Learning
![Structural Analysis](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781337630931/9781337630931_smallCoverImage.jpg)
![Structural Analysis (10th Edition)](https://www.bartleby.com/isbn_cover_images/9780134610672/9780134610672_smallCoverImage.gif)
Structural Analysis (10th Edition)
Civil Engineering
ISBN:
9780134610672
Author:
Russell C. Hibbeler
Publisher:
PEARSON
![Principles of Foundation Engineering (MindTap Cou…](https://www.bartleby.com/isbn_cover_images/9781337705028/9781337705028_smallCoverImage.gif)
Principles of Foundation Engineering (MindTap Cou…
Civil Engineering
ISBN:
9781337705028
Author:
Braja M. Das, Nagaratnam Sivakugan
Publisher:
Cengage Learning
![Fundamentals of Structural Analysis](https://www.bartleby.com/isbn_cover_images/9780073398006/9780073398006_smallCoverImage.gif)
Fundamentals of Structural Analysis
Civil Engineering
ISBN:
9780073398006
Author:
Kenneth M. Leet Emeritus, Chia-Ming Uang, Joel Lanning
Publisher:
McGraw-Hill Education
![Sustainable Energy](https://www.bartleby.com/isbn_cover_images/9781337551663/9781337551663_smallCoverImage.gif)
![Traffic and Highway Engineering](https://www.bartleby.com/isbn_cover_images/9781305156241/9781305156241_smallCoverImage.jpg)
Traffic and Highway Engineering
Civil Engineering
ISBN:
9781305156241
Author:
Garber, Nicholas J.
Publisher:
Cengage Learning