Introduction

Chances are you're going to have to deal with data that's not already in the form of an Excel file. This data may be standard scientific and engineering data (such as element properties or thermodynamic tables), or it could be the results of other computer simulations (such as computation fluid dynamics results or galaxy formation simulation results), or it could be experimental data obtained from any of a wide variety of scientific and engineering measurements. In many cases such data would be in the form of text files that could be imported into Excel for further analysis. Text files are common because they are universal, they are easy to generate in custom programs, and you don't have to have specialized software to read them. Still other data that you may want to process in Excel could reside in nontext files such as database files. This chapter will show you how to import data into Excel from these and other sources. Further, I'll show you how to massage that data once it's in Excel, making it easier to manipulate and analyze.

Using Excel

Getting Acquainted with Visual Basic for Applications

Collecting and Cleaning Up Data

Charting

Statistical Analysis

Time Series Analysis

Mathematical Functions

Curve Fitting and Regression

Solving Equations

Numerical Integration and Differentiation

Solving Ordinary Differential Equations

Solving Partial Differential Equations

Performing Optimization Analyses in Excel

Introduction to Financial Calculations

Index



Excel Scientific and Engineering Cookbook
Excel Scientific and Engineering Cookbook (Cookbooks (OReilly))
ISBN: 0596008791
EAN: 2147483647
Year: N/A
Pages: 206
Authors: David M Bourg

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net