Contents: | Main | Chapter | See Also: | Getting Started Manual | Programmer Manual |

VA FileMan currently offers three types of statistical processing:

In each case, to generate statistics from reports, you use a two-step process:

- Use the Print File Entries or Search File Entries options to generate
a VA FileMan report. Do not queue the report. The entries you select in your
report are the ones on which statistics will be generated; the way you use sort
and print qualifiers in the report affects the way statistics will be
generated, as discussed later in this chapter.
- Immediately after the report finishes, use the Statistics option on the VA FileMan menu to generate statistics.

The two-step process for each type of statistical output is described below.

**NOTE:** If you have statistical software on a personal computer,
you might want to consider using VA FileMan's
Export
Tool as an alternative to VA FileMan's statistics options, especially if
the statistics options described in this chapter do not provide the statistical
analysis you need. With the Export Tool, you can export your data into a format
your personal computer statistical software can read and use all of that
software's capabilities to perform statistical analyses on VA FileMan data.

The Descriptive Statistics routine creates a summary report of the numeric information produced by the preceding print. The number of cases is always shown.

To get descriptive statistics for fields printed out in a report, you must associate one of the following qualifiers with fields in the print:

Qualifier |
Description |

# |
Count, mean, standard deviation, minimum, and maximum |

+ |
Count and mean |

To obtain descriptive statistics:

- Print a report, and use the
**#**or**+**print qualifiers on one or more fields. - Immediately after the report completes, generate the Descriptive Statistics based on the report.

**Initial Print**

**Generating the Descriptive Statistics **

Select OPTION:OTHER OPTIONSSelect OTHER OPTION:STATISTICSSelect STATISTICAL ROUTINE:DESCRIPTIVE STATISTICS User: WILLIAMS,BERNARD 2:51 PM 02/15/96 DESCRIPTIVE STATISTICS N OF STANDARD CASES MEAN DEVIATION MINIMUM MAXIMUM BUDGET 27 45845.1481 25685.8582 2589.0000 95200.0000 COST 27 45914.1111 25796.2936 259.0000 96000.0000

If you subtotal by two fields (i.e., sub-subtotal) in a sort, you can
create Scattergrams for fields that were counted with **!**, **+**, or
**#** in the corresponding print.

Only numeric values are charted. The Scattergram is scaled to fit your
output device's row and column dimensions. Occurrences of more than nine points
in a single print position are marked by an asterisk ("*****").

**Initial Print **

**Generating the Scattergram**

If you subtotal by one or more fields in a sort, you can get Histograms
for the fields that are preceded by **#**, **!**, **&**, or
**+** qualifiers in the corresponding print. The Histograms that you can
produce depend on which print qualifier is used:

Qualifier |
Description |

! |
Produces a Count Histogram |

& |
Produces a Sum Histogram |

+ |
Produces Count, Sum, and Mean Histograms |

# |
Produces Count, Sum, and Mean Histograms |

Here is an example of a using a subtotal in a print, and then producing a Count Histogram:

Reviewed/Updated: March 4, 2007