UM Home | A to Z | UM Search
Geosciences Home Page

Gravity and Electromagnetics - Geology 438
Professor: Steve Sheriff

Exams from Seismology and Magnetics

Free Spreadsheet exercises from Computation and Computer Methods in Geology - you'll need to develop solid spreadsheet skills.

  • Exercise one covers relative versus absolute addresses and graphing equations.
  • Exercise two introduces Excel's array functions for transposing, multiplying and inverting matrices.
  • Exercise three uses the array functions for solving simultaneous equations and fitting lines to linear data.
  • Exercise four demonstrates Excel's LINEST() function for least squares.
  • Exercise five requires importing ASCII data, sorting, MEDIAN(), and AVERAGE.

 

 

Geosciences Department - The University of Montana - 32 Campus Drive #1296 - Missoula, MT 59812-1296
Phone: (406) 243-2341 Fax: (406) 243-4028 Email: geology@mso.umt.edu

The University of Montana - Missoula

Layout and Design by Brian W. Collins, updates and current content by Aaron Deskins ©2005/2008


The University of Montana Geosciences Department