Shareware and Freeware Programs for Microsoft Excel

Home Page

Download / Purchase

Macro Support

Excel Related Links

Sponsored Links

Recent Programs

XLEcom Ecommerce Website Creator

Multiple Price Options Add-to-Cart Form Utility

Multiple File Import / Export Utility

Data Sheet

Newsletter Generator Utility

MySQL Database Backup Utility

Drupal CMS Theme Generator

Drupal File Comparison Utility

Drupal Members List PHP Script Generator

Sponsored Links

Older Programs

Database "Plus"

Database "Standard"

Schedule "Plus"

Schedule “Standard”

Form Print Spooler

Credit Card Program

Financial Analysis of Life

Email Generator Utility

Bulk File Generator

Phone / Email Book

Convert Cell References

Mathematical Summary Utility

Extra Utility Tools

Open & Save Utility

Sponsored Links

Mathematical Summary Utility

Download Version 2.2 Now

 Register it for $10.00

This Mathematical Summary utility generate a mathematical summary of any selected range of cells.

Basic Math Results:
 • Count of Numbers
 • Most Common Value
 • Minimum Value
 • Maximum Value
 • Median Value
 • Average Value
 • Summation (total)

Statistical Results:
 • Product (multiplied values)
 • Greatest Common Divisor
 • Least Common Multiple
 • Sum of Squares
 • Sample Standard Deviation
 • Population Standard Deviation
 • Variance (sample)
 • Variance (population)
 • Geometric Mean
 • Harmonic Mean Kurtosis
 • Skewness of the Distribution
 • Sum of Squares of Deviations
 • Average of the Absolute Deviations of Data Points from their Mean.

Description

Introduction
This Mathematical Summary utility will allow the user to instantly generate, with the option to print, a mathematical summary of any selected range of cells on any other spreadsheet. The Mathematical Summary will display both basic math and statistical results.The following are the calculated displayed results:

Basic Math Results: Count of Numbers, Most Common Value, Minimum Value, Maximum Value, Median Value, Average Value, and Summation (total).

Statistical Results: Product (all numbers multiplied), Greatest Common Divisor, Least Common Multiple, Sum of Squares, Standard Deviation (sample), Standard Deviation (population), Variance (sample), Variance (population), Geometric Mean, Harmonic Mean, Kurtosis, Skewness of the Distribution, Sum of Squares of Deviations, & Average of the Absolute Deviations of Data Points from their Mean.

Installation and Usage:
Put this program file in your Microsoft Excel XLStart folder to have it automatically launch at startup. A new command menu item will be added to the Excel Tools Menu called "Mathematical Summary". To install the program only when you need it, just load it using the File-Open command. To run the utility, follow the following two steps.

Step 1: Select the Menu command

Step 2: Select the cell range to evaluate

Basic View Results

Statistical View Results