Introduction

Time series analysis is a broad field of study with applications ranging from engineering analysis to socioeconomic forecasting to stock market prediction, among many other applications. You can use Excel to perform many tasks required in time series analysis , such as pre- and post-processing of data, visualizing results, and making forecasts. Excel also offers a Fourier Analysis tool that allows you to transform time series data to the frequency domain (and back) for further analysis. This chapter aims to show you some specific examples of how you can effectively use Excel when analyzing time series data.

There are many time series analysis techniques available, many of which are tailored to specific kinds of time series, so I'm not going to attempt to cover them all. Instead, the examples discussed here serve to show you how you can leverage Excel's standard functionality to perform some important analysis tasks. Building on the techniques I show you here, you have the ability and power within Excel to devise all sorts of other analysis techniques.

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