lab1 - Geology 351 - Geomath Computer Lab Introductory...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
10 Geology 351 - Geomath Computer Lab – Introductory Problem (using Excel) Evaluating Depth/Age Relationships in the North Sea The following instructions take you step-by-step through the generation and plotting of a data set using Excel. Many of you may already be familiar with Excel, but if you aren’t that’s not a problem. In future exercises, you will learn how to fit straight lines and polynomials of higher order to specific data sets. Today, we are going to plot up some data and take a conceptual look at some linear relationships we will see within the context of age- depth relationships for sediments deposited in the North Sea. We will learn how to generate xy data plots and format them in various ways. GETTING INTO EXCEL Follow along as we bring up Excel. The latest version of Excel (2007) is set up quite differently than prior versions. Access to various controls are arranged around what is referred to in Excel 2007 as the Ribbon. There are several folders across the top that one accesses to perform various tasks. To open a file, go to the office button in the upper left corner and click on it. In the drop down list you will see an open file option. Left click on FILE then browse to your data folder . In most cases this might be on the Desktop under your favorites list (upper left) . A lot of the class files will reside on a network folder. We’ll navigate over to this “common drive” and copy the FittingLabData folder over to your G:\Drive. The G: Drive is another network drive that is linked to your account and can be accessed from any computer in the building that is on the network. We’ll spend some time in class reviewing all this (take notes!) . For today’s lab, select the data set DepthAge.xls and click the open button. A spreadsheet or window containing the depth and age data will appear on the screen. The data in the spreadsheet were taken from Chapter 2 of Waltham's text (page 37, problem 2.11). The following data shown in the display below were taken from the Troll 3.1 well in the Norwegian North Sea. Data taken from Lehman, S., and Keigwin, L., (1992), Sudden changes in North Atlantic circulation during the last deglaciation, Nature, 356, 757-762.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
11 The first row contains the column labels Depth and Age (in cells A1 and B1) defining the data type listed in each column. GRAPHING AND PLOTTING! Let’s see what this data looks like. Click the insert folder tab on the Ribbon (note variety of options) Click on Scatter > (menu opens to right). You’ll see a variety of plot styles in the drop-down window. Select plot style with data points and curved line fit. After you click on the Scatter plot option a blank plot window comes, select columns A and then B to specify the x and y plot data (follow along in class and take marginal notes).
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This document was uploaded on 02/29/2012.

Page1 / 15

lab1 - Geology 351 - Geomath Computer Lab Introductory...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online