Chapter Six:
Topics in Data Display and Analysis


Working with Binary Series

Identifying Outliers

Replacing Outliers

Achieving Results with the Binary Series

Creating Custom Charts and Reports

Getting the Series into the Window

Positioning the Scales

Setting the Range on the Scales

Annotating the Window and Worksheet

Displaying / Hiding Elements of the Chart

Automating the Custom Chart

Performing Matrix Math

Creating a Matrix

The RAVEL Command

The UNRAVEL Command


The OUTERPROD command

Editing a Matrix

Vectors from Matrices

Matrix Math

Balancing Matrices

The BALANCE function

The NOBALANCE function

Table and Matrix Size and the Speed of Computations

Performing Fourier Transforms

Four Basic Fourier Transforms

Fourier Series: Continuous, Periodic Time Series

Fourier Series: Continuous, Non-periodic Time Series

Fourier Transform: Discrete, Non-Periodic Time Sequence

Fourier Transform: Discrete, Periodic Time Sequence



Performing Peak Analysis

Curve Fitting and Polynomial Evaluation

Least Squares Fit

Statistical Analysis

Single Series Stats

Matrix or Table Stats