problem9-7 - calculations following the suggested format...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Geol 351 – Geomathematics: Chapter 9 Integral Calculus Estimating the cross-sectional area of a sedimentary deposit Problem 9.7 : The thickness of a sedimentary deposit varies as shown in the table below: Distance (m) Thickness (m) 0 0 100 1 200 2 400 3 1000 2.5 1500 2 1800 1 2000 0 Analytical procedures: 1) Bring up Excel and enter the above data . 2) Construct a graph of the thickness versus distance along this profile. 3) Add a trendline to your Excel plot. Use a 5 th order polynomial and display the equation on your graph. Include the trendline equation box and correlation coefficient on your graph. Select the equation line box and format the coefficients to be in scientific notation with a three decimal place precision. 4) Determine the cross sectional area of this deposit. Set up your worksheet
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: calculations following the suggested format discussed in class. Over what range of x do you integrate? 5) Compare the result you obtain using the 5 th order polynomial to that cited in the answers to problems on page 193 obtained by Waltham using a 4 th order polynomial. 6) Assume this sheet sand is nearly rectangular in map view and has total length of 8 km. Estimate the volume of the deposit. 7) Given that the sand has a porosity of 17%. Assume the sand is water saturated. What is the total volume of water contained in the sand? Present A) your Excel chart showing trendline, trendline equation and correlation coefficient; B) your integration (area) and volume calculations, and C) your calculations of total deposit volume and water volume....
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online