Copyright: StatGR Help V3.2 beta
Citation: StatGR Help (c) G. Ritschard


StatGR User's Guide
Overview

StatGR  A Statistical Excel Add-in

Version 3.2, May 2002

Author: Gilbert Ritschard  (gilbert.ritschard@themes.unige.ch)

• Installation

• Usage

StatGR provides the following macros:

• Boxplot

• Histogram from Individual Data

• Histogram from Aggregated Data

• QQ-Plot

• Correlogram

• CrossCorrelogram

For the latest version, check on  http://perso.unige.ch/~ritschar


StatGR Usage
StatGR

• Usage

Data to analyze should be in column.

Content of first cell is taken as the variable label.

To start a macro

1. Select the variable label at the top of the data column you want to analyze.

2. Launch the appropriate macro (Menu: StatGR.) The macro automatically selects the data range from the selected cell to the last non numerical value below this cell.

3. Some macros require additional data.

Histogram from Individual Data requires the class breaks to build the frequency table.

CrossCorrelogram considers the first selected data as the dependent variable and requires the predictor variable.

A Dialog will prompt you for the reference to the required additional data.

Provide only the reference to the first cell (variable label) of the column that contains the data series. The macro automatically selects all data below the indicated cell until it reaches a non numerical value.

Histogram from Aggregated Data does not seek data below the variable label but requires instead a table with 3 columns: lower bound of the class, upper bound of class, number of cases in the class. Give the full reference to the table when prompted. The referenced table must contain only numerical values (no labels are allowed.)

Table of content, Usage, Installation

• Installation

There are two ways to use the package:

1. Simply open the file StatGR.xla.

This first method should be used if you only occasionally use the package.

2. Install StatGR.xla Add-In by selecting the Tools/Add-Ins... menu item. In the Add-Ins Dialog, click the Browse button and search for the StatGR.xla file.

With this second method, the StatGR package will be loaded each time Excel is started until you deselect StatGR in the Add-Ins Dialog. When deselecting StatGR, it remains in the displayed list of Add-Ins. Thus the next time you can just select it again from the list.

Each time the StatGR.xla package is loaded (whatever the method), a new menu item StatGR is added to the menu bar. This menu item is also automatically deleted when the package is unloaded (for instance, when Excel closes or when the package is deselected from the add-ins list.)

Table of content, Usage, Installation