
EZStat^{™}
Addin for Microsoft^{®} Excel^{®}
EZStat Analyzes Excel Data OntheFly Using Standard Excel Math Functions and Excel Math Formulas

Fast, ondemand calculation of 29 commonly used Excel Data Analysis Formulas.
Calculate Standard Excel Math Formulas and Excel Math Functions onthefly
with no modifications to the Excel data, for user selected numeric fields,
for: (1) only the numeric data for a user selected nonnumeric value,
(2) all data values, (3) the range of data cells referenced by any Excel subtotal cell, and (4) at every change in up to four user selected nonnumeric data fields.
Count Total Average Mean Median Max Min Stdev ... 29 Excel Formulas

New! EZStat Ribbon for Excel 2007 / Excel 2010
Every addin's single install works with Excel 2000, XP, 2003, 2007 and Excel 2010
New! Includes 32 bit and 64 bit versions for Excel 2010.
Download 15Day Trial
Purchase for $39.95
Latest update 01/14/2012
Installs and Completely Uninstalls in Seconds. Securely Purchase from inside Excel.
Use with Excel 2000, XP, 2003, 2007 & 2010 on Windows^{®} 2000, XP, Vista^{®} & Windows 7^{®}.
We recommend running Windows Update for Windows and Office^{®} before installing EZStat.
New! EZFormat Includes All EZStat Features Builtin.
Access Stat Features using "Stats" on the EZFormat Ribbon and "S" on the EZFormat Toolbar.
Download EZFormat to try Free for 15Days
"Full Stats" Calculates 24 Standard Excel Formulas by up to four sort fields

Download and install to take the 2minute automated Tour.
If you have questions after the tour call our 800 number.
Installs and uninstalls in seconds.
Free updates and Enhancements.

See How to Instantly Analyze Excel Data Using 29 Automatically Created Excel Formulas and Functions
Flash Video on EZStat Addin for Microsoft Excel
Instantly Calculate 29 Commonly Used Excel Functions and Excel Formulas
"Best Addin for Analyzing Excel Data OntheFly!"

'Range Stats' instantly calculates 29 Excel Statistical Formulas, Excel Math Formulas and Excel Functions for Fast Data Analysis in Excel.
Calculate standard Excel Formulas for all values in a column or for a range of values in a column. Easily limit calculation of Excel Formulas to the data for a single nonnumeric value in another column.

'Range Stats' for all Sales Values calculated in 3 clicks and 2 seconds.

'Range Stats' for all Sales Values in 'CA' calculated in 4 clicks and 2 seconds.

'Quick Stats' instantly calculates 8 Popular Excel Math Formulas
Calculate popular Excel Math Formulas and Excel Math Functions for one or multiple numeric fields for all visible data or only the visible data for one selected nonnumeric data value.
Create "Quick Stats" for a single data value or for all data values in two clicks!

Count Total Average Median Minimum Maximum Standard Deviation & Median Excel Functions

'Full Stats' calculates Excel Math Formulas for up to Four Break Fields
Compare the results of Excel Formulas at every change in the fields
Calculate up to 25 different Excel Statistics Formulas, for one or more numeric fields, using only the currently visible data, at each change in up to four specified break fields.
The "Full Stats" Selection Dialog

Instantly Calculate up to 25 Excel Statistics Formulas and Excel Math Formulas

'Full Stats' calculated for two Numeric Fields at each change in three NonNumeric Fields.

Created from an automatic copy of visible detail data with no modifications to the original Excel worksheet.
Analyze by displaying individual Row and Data field values in the automatically created Excel Pivot Table.

General Features for Quickly Analyzing Data


• 
EZStat performs Simple Statistical Analysis in Excel by automatically creating and calculating Excel Statistics Formulas, Excel Math Formulas and Excel Functions onthefly.

• 
Quickly Analyzing Data in Excel is accomplished by automatically calculating up to 29 simple Excel Statistics Formulas, Excel Math Formulas and Excel Functions.

• 
EZStat's Simple Excel Statistics include all Excel Statistic Formulas, Excel Math Formulas and Excel Functions that operate on ranges of data.

• 
EZStat's ondemand, onthefly, fast calculation of Excel Statistical Formulas, Excel Math Formulas and Excel Functions never modifies the original data.

• 
EZStat's fast Statistical Analysis and fast Data Analysis uses "Quick Stats", "Range Stats" and "Full Stats".

• 
The fast Excel Formulas and Excel Functions automatically created by EZStat for Data Analysis operate on only the currently visible Detail Data.

• 
In Subtotaled Excel Lists the fast Excel Formulas and Excel Functions automatically exclude Subtotal Row Data from the Excel Math Formulas.

• 
Use Excel Data Filters to select the visible data for which Excel Formulas and Excel Functions will be automatically calculated for Data Analysis.

"Quick Stat" Features for Analyzing Excel Data


• 
"Quick Stats" display ontopof the original Excel worksheet and can be exported from the display dialog to a new Excel worksheet.

• 
Calculate 8 commonly used Excel Statistics Formulas, Excel Math Formulas and Excel Functions for Analyzing Data onthefly and ondemand in as little as two clicks.

• 
Calculate Excel Statistics Formulas, Excel Math Formulas and Excel Functions using Excel List data with no totals, with column totals or with subtotals.

• 
"Quick Stat" Excel Statistics Formulas, Excel Math Formulas and Excel Functions operate on only the currently visible data in subtotaled and nonsubtotaled Excel Lists.

• 
By default the "Quick Stats" 8 commonly used Excel Statistics Formulas, Excel Math Formulas and Excel Functions are calculated for all numeric fields in the Excel List Data.

• 
Optionally select specific numeric fields for which to quickly calculate Excel Statistic Formulas, Excel Math Formulas and Excel Functions for Data Analysis.

• 
Optionally calculate Excel Statistics Formulas, Excel Math Formulas and Excel Functions using only nonzero numeric values.

• 
Including zero values in Excel Statistics Formulas, Excel Math Formulas and Excel Functions changes the results of the Excel Average Formula or Excel Mean Formula and possibly the Excel Minimum Formula or Excel Maximum Formula.

• 
The "Quick Stat" eight fast Excel Formulas and Excel Functions can be calculated for all data in the Excel List or for only the data for one specific nonnumeric value.

• 
Examples of specific nonnumeric values include a State, person, date, product, region, year, etc.

• 
Calculated Excel Statistics Formulas, Excel Math Formulas and Excel Functions include the Excel Count Function, Excel Sum Function, Excel Average Function or Excel Mean Function, Excel Minimum Function, Excel Maximum Function, two Excel Standard Deviation Functions and the Excel Median Function.

• 
Calculate Excel Statistics Formulas, Excel Math Formulas and Excel Functions for "All" data by rightclicking in any "field description" and selecting "Quick Stats".

• 
The Excel Formula, Excel Statistical or Excel Function results of the fast Data Analysis of "All" data is the same no matter which field description is selected.

• 
Automatically calculate Excel Formulas and Excel Functions for one specific nonnumeric value by rightclicking in a cell containing the desired value and selecting "Quick Stats".

• 
One click exports the "Quick Stats" fast Excel Statistics and Excel Formula results to an Excel Workbook.

• 
Fast Excel Statistics, Excel Forumula and Excel Function results exported for subsequent Data Analysis is formatted for viewing and formatted for printing.

• 
EZStat never modifies the original Excel List Data when calculating Excel Statistic Formulas and Excel Math Formulas for Data Analysis.

"Range Stats" Features for Analyzing Data in Excel


• 
"Range Stats" display ontopof the original Excel worksheet and can be exported from the display dialog to a new Excel worksheet.

• 
Quickly and easily calculate Excel Statistics Formulas, Excel Math Formulas and Excel Functions for all visible detail data in one numeric field or for a range of visible detail data in one numeric field.

• 
Optionally and automatically use only the applicable selected numeric data to calculate Excel Formulas and to Analyze Data for only one nonnumeric value in another field.

• 
Example 1. Select a single cell in the "Sales Amt" column to automatically calculate all 29 Excel Statistics Formulas, Excel Math Formulas and Excel Functions for all "Sales Amt" data in the column.

• 
All 29 Excel Statictics Formulas, Excel Math Formulas and Excel Functions are calculated for Analysis of the Data even though all 29 Statistics Values and Excel Math Formula results may not initially display.

• 
The single selected numeric value will be automatically ranked using four different Excel Rank Formula variations: Excel Rank Ascending nonunique, Excel Rank Descending nonunique, Excel Rank Ascending unique and Excel Rank Descending unique.

• 
The Excel Rank Function Ascending unique and Excel Rank Function Descending unique are custom variations of the standard Excel Rank Formula which is always nonunique.

• 
Example 2. Select one contiguous range of cells in the "Sales Amt" column to automatically calculate all 29 Excel Statistical Formulas, Excel Math Formulas and Excel Functions for only the selected visible detail data.

• 
The four Excel Rank Formula or Excel Rank Function variations are not calculated when a range of cells is selected for Data Analysis.

• 
Example 3. Select either a single cell in the "Sales Amt" column or a contiguous range of cells in the "Sales Amt" column, then select "NY" in the State column to calculate the 25 or 29 Excel Statistics Formulas and Excel Math Formulas for only "NY".

"Full Stats" Features for Quick Data Analysis


• 
"Full Stats" are created in a new Excel workbook separate from the original Excel Data.

• 
Quickly and easily calculate Excel Statistic Formulas, Excel Math Formulas and Excel Functions at each change in all fields for combinations of up to four data fields.

• 
The quick, automatic onthefly calculation of from one to 25 Excel Statistic Formulas, Excel Math Formulas and Excel Functions at each change in up to any of four sort fields is manually time prohibitive.

• 
For example, automatically calculate Excel Statistics Formulas, Excel Math Formulas and Excel Functions for each unique occurance of State, Region, Product Line, and Date.

• 
Then quickly and automatically calculate Excel Statistics Formulas, Excel Math Formulas and Excel Functions for each unique occurance of State, Region and Product Line.

• 
The results of the onthefly fast Excel Statistical Formulas, Excel Math Formulas and Excel Functions are presented in an automatically created and automatically formatted Excel Pivot Table.

• 
Excel Pivot Tables are one of the best Data Analysis formats and tools for viewing and quickly manipulating data.

• 
Quickly and easily select subsets of the Excel Pivot Table Statistics for Data Analysis, viewing and printing.

• 
Choose to calculate up to 25 Excel Statistic Formulas, Excel Math Formulas and Excel Functions for the selected numeric fields in the Excel Data List.

• 
By default the Excel Statistic Formulas, Excel Math Formulas and Excel Functions are calculated for all numeric fields in the selected Excel List data.

• 
By default the Excel Count Formula, Excel Sum Formula, Excel Average Formula or Excel Mean Formula, Excel Minimum Formula, Excel Maximum Formula, and Excel Standard Deviation Formula are calculated using "Range Stats".

• 
Choose the numeric fields for which to calulate Excel Statistics Formulas, Excel Math Formulas and Excel Functions; for example Sales and Profit.

• 
Optionally calculate Excel Statistic Formulas, Excel Math Formulas and Excel Functions using only nonzero numeric values.

• 
Including zero values in Excel Statistic Formulas, Excel Math Formulas and Excel Functions changes the Excel Average Formula or Excel Mean Formula and possibly the Excel Minimum Formula or Excel Maximum Formula.

• 
Automatically calculate these simple Excel Formulas using Excel Data with no totals, with column totals or with subtotals.

• 
EZStat never modifies the original Excel List Data when calculating simple Excel Statistics Formulas and Excel Math Formulas.

Additional EZStat Features for Fast Data Analysis


• 
EZStat includes sample data, demos, instructions and videos to help you quickly learn the product.

• 
EZStat works with Microsoft® Office Excel 2000 / XP / 2003 / 2007 on Microsoft® Windows® 2000 / XP / 2003 Server / Vista®.

• 
EZStat works with Excel List Data beginning in cell A1 and with no totals, column totals or Excel Subtotals.

• 
For best results avoid using data formatted as "General"; format data as "Numeric", "Text" and "Date".

• 
Try the full EZStat product for up to 15days before purchasing.

• 
EZStat installs and completely uninstalls in seconds.

• 
EZStat automatically selfregisters when purchased from a machine on which it is currently installed or on which it is subsequently installed.

• 
EZStat includes free updates for both enhancements and bug fixes.

Additional Information on Using Microsoft Excel Formulas, Excel Functions and Excel Math Formulas for Analyzing Excel Data for Ranges of Cells and Values

AVEDEV

The Excel AVEDEV Formula or Excel AVEDEV Function returns the average of the absolute deviations of data points from their mean. Arguments can be numbers or names, arrays, or references that contain numbers.

Top

AVERAGE

The Excel AVERAGE Formula or Excel AVERAGE Function returns the average (arithmetic mean) of its arguments, which can be numbers or names, arrays, or references that contain numbers.

Top

AVERAGEA

The Excel AVERAGEA Formula or Excel AVERAGEA Function returns the average (arithmetic mean) of its arguments, evaluating text and FALSE in arguments as 0; TRUE evaluates as 1. Arguments can be numbers, names, arrays, or references.

Top

COUNT

The Excel COUNT Formula or Excel COUNT Function counts the number of cells that contain numbers and numbers within the list of arguments.

Top

COUNTUnique

This customized Excel COUNT Formula or Excel COUNT Function counts the number of cells that contain unique numbers and unique numbers within the list of arguments.

Top

COUNTA

The Excel COUNTA Formula or Excel COUNTA Function counts the number of cells that are not empty and the values within the list of arguments.

Top

COUNTBLANK

The Excel COUNTBLANK Formula or Excel COUNTBLANK Function counts the number of empty cells in a specified range of cells.

Top

KURT

The Excel KURT Formula or Excel KURT Function returns the kurtosis of a data set. Kurtosis characterizes the relative peakedness or flatness of a distribution compared with the normal distribution. Positive kurtosis indicates a relatively peaked distribution. Negative kurtosis indicates a relatively flat distribution.

Top

MAX

The Excel MAX Formula or Excel MAX Function returns the largest value in a set of values. Ignores logical values and text.

Top

MAXA

The Excel MAXA Formula or Excel MAXA Function returns the largest value in a set of values. Does not ignore logical values and text.

Top

MEAN

There is no Excel MEAN Formula or Excel MEAN Function. Use the Excel AVERAGE Formula.

Top

MEDIAN

The Excel MEDIAN Formula or Excel MEDIAN Function returns the median, or the number in the middle of the set of given numbers.

Top

MIN

The Excel MIN Formula or Excel MIN Function returns the smallest number in a set of values. Ignores logical values and text.

Top

MINA

The Excel MINA Formula or Excel MINA Function returns the smallest value in a set of values. Does not ignore logical values and text.

Top

MODE

The Excel MODE Formula or Excel MODE Function returns the most frequently occurring, or repetitive, value in an array or range of data.

Top

RANGE

There is no Excel RANGE Formula or Excel RANGE Function. Statistically it is the difference between the highest value and the lowest value in a set of values: calculated by EZStat using the Excel MAX Formula and Excel MIN Formula.

Top

RANK

The Excel RANK Formula or Excel RANK Function returns the rank of a number in a list of numbers: its size relative to other values in the list.

Top

RANKUnique

The Excel RANKU Formula or Excel RANKU Function returns the rank of a number in a list of unique numbers: its size relative to other values in the list. This is a special EZStat Statistical Formula.

Top

SKEW

The Excel SKEW Formula or Excel SKEW Function returns the skewness of a distribution: a characterization of the degree of asymmetry of a distribution around its mean. Positive skewness indicates a distribution with an asymmetric tail extending toward more positive values. Negative skewness indicates a distribution with an asymmetric tail extending toward more negative values.

Top

STDEV

The Excel STDEV Formula or Excel STDEV Function estimates standard deviation based on a sample (ignores logical values and text in the sample).

Top

STDEVA

The Excel STDEVA Formula or Excel STDEVA Function estimates standard deviation based on a sample, including logical values and text. Text and the logical value FALSE have the value 0; the logical value TRUE has the value 1.

Top

STDEVP

The Excel STDEVP Formula or Excel STDEVP Function calculates standard deviation based on the entire population given as arguments (ignores logical values and text).

Top

STDEVPA

The Excel STDEVPA Formula or STDEVPA Function calculates standard deviation based on an entire population, including logical values and text. Text and the logical value FALSE have the value 0; the logical value TRUE has the value 1.

Top

SUM

The Excel SUM Formula or Excel SUM Function adds all numbers in a range of cells.

Top

TOTAL

There is no Excel TOTAL formula or Excel TOTAL Function. Use the Excel SUM Formula.

Top

VAR

The Excel VAR Formula or Excel VAR Function estimates variance based on a sample (ignores logical values and text in the sample).

Top

VARA

The Excel VARA Formula or Excel VARA Function estimates variance based on a sample, including logical values and text. Text and the logical values FALSE have the value 0; the logical value TRUE has the value 1.

Top

VARP

The Excel VARP Formula or Excel VARP Function calculates variance based on the entire population (ignores logical values and text in the population).

Top

VARPA

The Excel VARPA Formula or Excel VARPA Function calculates variance based on the entire population, including logical values and text. Text and the logical value FALSE have the value 0; the logical value TRUE has the value 1.

Top

Instantly Make Excel Formulas for Only Visible Data

Calculate Excel Statistics Formulas and Excel Math Formulas using these Excel Functions for fast Excel Data Analysis

Excel Function Name

Quick Stats

Range Stats

Full Stats

AVEDEV




AVERAGE




AVERAGEA




COUNT




COUNTUnique




COUNTA




COUNTBLANK




KURT




MAX




MAXA




MEAN
(use AVERAGE)




MEDIAN




MIN




MINA




MODE




Excel Formula Name

Quick Stats

Range Stats

Full Stats

RANGE
(MAX  MIN)




RANK
(asc & dec)




RANKUnique
(asc & dec)




SKEW




STDEV




STDEVA




STDEVP




STDEVPA




SUM




TOTAL
(use SUM)




VAR




VARA




VARP




VARPA




Excel Function Name
29

Quick Stats
8

Range Stats
29

Full Stats
25


Download the Free 15Day Trial of the EZStat Addin Tool for Microsoft Excel
Installs and Completely Uninstalls in Seconds. Securely purchase from inside Excel to automatically selfregister.

EZStat for Excel Version 9.1
SLPUS $39.95
Create "Range Stats" for all data or for a range of data in one column.
Create "Quick Stats" for single data values or for all data.
Create "Full Stats" at every change in up to four nonnumeric fields.
Calculate up to 29 Excel Formulas and Excel Functions.
Choose the numeric fields for which to calculate statistics.
Learn EZStat within minutes of installing the Free 15day trail!
Latest CNET version is 9.1 on September 10, 2010.

New Version 01/14/12


