Data Presentation Products
 
Microsoft Excel Tools  
 
Microsoft Excel Add-ins  

   

 
  HOME > PRODUCTS > EZ-Stat
 

 
EZ-Stat
Add-in for Microsoft® Excel®

EZ-Stat Analyzes Excel Data On-the-Fly Using
Standard Excel Math Functions and Excel Math Formulas

Fast, on-demand calculation of 29 commonly used Excel Data Analysis Formulas.
Calculate Standard Excel Math Formulas and Excel Math Functions on-the-fly
with no modifications to the Excel data, for user selected numeric fields,
for: (1) only the numeric data for a user selected non-numeric 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 non-numeric data fields.

Count  Total  Average  Mean  Median  Max  Min  Stdev ... 29 Excel Formulas

New!  EZ-Stat Ribbon for Excel 2007 / Excel 2010

The EZ-Stat Excel 2007 Ribbon
Every add-in'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 15-Day 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 EZ-Stat.

New! EZ-Format Includes All EZ-Stat Features Built-in.

Access Stat Features using "Stats" on the EZ-Format Ribbon and "S" on the EZ-Format Toolbar.

Download EZ-Format to try Free for 15-Days

EZ-Stats Full Stats Video
08/12/2008 04:10
"Full Stats" Calculates 24
Standard Excel Formulas
by up to four sort fields


Download and install to take the 2-minute 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 EZ-Stat Add-in for Microsoft Excel
Instantly Calculate 29 Commonly Used Excel Functions and Excel Formulas

"Best Add-in for Analyzing Excel Data On-the-Fly!"




Analyze Data using Standard Excel Math Formulas with no formatting changes.

AVEDEV AVERAGE AVERAGEA COUNT COUNTU COUNTA COUNTBLANK KURT MAX MAXA MEAN MEDIAN MIN
MINA MODE RANGE RANK RANKU SKEW STDEV STDEVA STDEVP STDEVPA SUM TOTAL VAR VARA VARP VARPA
Calculate Excel Formulas for one numeric field or for multiple numeric fields.


Analyze Excel Data in Filtered, unFiltered, Subtotaled and non-Subtotaled Lists.
The Excel Worksheet is never modified when Analyzing Excel Data using Excel Statistical Formulas.


Analyze Data by calculating Excel Formulas at up to four breakdown levels.
Specify the data, specify the Excel Formulas, specify the Numeric Fields and the Break Down Fields.




'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 non-numeric value in another column.

For fast Data Analysis calculate 29 Excel Statistics Formulas for the selected visible data using 'Range Stats'.
'Range Stats' for all Sales Values
calculated in 3 clicks and 2 seconds.
To Quickly Analyze Data for a single data value use the 29 Excel Formulas calculated by 'Range Stats'.
'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 non-numeric data value.


Create "Quick Stats" for a single data value or for all data values in two clicks!
For fast Data Analysis use the eight Excel Formulas automatically calculated by 'Quick Stats' in 2 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
Use 'Full Stats' to automatically calculate up to 25 Excel Formulas, for multiple numeric fields, for up to four sort fields.
Instantly Calculate up to 25 Excel Statistics Formulas and Excel Math Formulas

'Full Stats' calculated for two Numeric Fields at each change in three Non-Numeric Fields.
A partial automatically created 'Full Stats' Pivot Table used for Data Analysis at each change in up to four sort 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


   •    EZ-Stat performs Simple Statistical Analysis in Excel by automatically creating and calculating Excel Statistics Formulas, Excel Math Formulas and Excel Functions on-the-fly.
   •    Quickly Analyzing Data in Excel is accomplished by automatically calculating up to 29 simple Excel Statistics Formulas, Excel Math Formulas and Excel Functions.
   •    EZ-Stat's Simple Excel Statistics include all Excel Statistic Formulas, Excel Math Formulas and Excel Functions that operate on ranges of data.
   •    EZ-Stat's on-demand, on-the-fly, fast calculation of Excel Statistical Formulas, Excel Math Formulas and Excel Functions never modifies the original data.
   •    EZ-Stat'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 EZ-Stat 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 on-top-of 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 on-the-fly and on-demand 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 non-subtotaled 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 non-zero 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 non-numeric value.
   •    Examples of specific non-numeric 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 right-clicking 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 non-numeric value by right-clicking 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.
   •    EZ-Stat 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 on-top-of 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 non-numeric 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 non-unique, Excel Rank Descending non-unique, 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 non-unique.
   •    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 on-the-fly 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 on-the-fly 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 non-zero 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.
   •    EZ-Stat never modifies the original Excel List Data when calculating simple Excel Statistics Formulas and Excel Math Formulas.

Additional EZ-Stat Features for Fast Data Analysis


   •    EZ-Stat includes sample data, demos, instructions and videos to help you quickly learn the product.
   •    EZ-Stat works with Microsoft® Office Excel 2000 / XP / 2003 / 2007 on Microsoft® Windows® 2000 / XP / 2003 Server / Vista®.
   •    EZ-Stat 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 EZ-Stat product for up to 15-days before purchasing.
   •    EZ-Stat installs and completely uninstalls in seconds.
   •    EZ-Stat automatically self-registers when purchased from a machine on which it is currently installed or on which it is subsequently installed.
   •    EZ-Stat 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 EZ-Stat 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 EZ-Stat 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 You can not use the Excel AVEDEV Formula with 'Quick Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel AVEDEV Formula with 'Range Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel AVEDEV Formula with 'Full Stats' for Quick Data Analysis using Excel Statistics Formulas
AVERAGE Use the Excel AVERAGE Formula with 'Quick Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel AVERAGE Formula with 'Range Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel AVERAGE Formula with 'Full Stats' for Quick Data Analysis using Excel Statistics Formulas
AVERAGEA You can not use the Excel AVERAGEA Formula with 'Quick Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel AVERAGEA Formula with 'Range Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel AVERAGEA Formula with 'Full Stats' for Quick Data Analysis using Excel Statistics Formulas
COUNT Use the Excel COUNT Formula with 'Quick Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel COUNT Formula with 'Range Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel COUNT Formula with 'Full Stats' for Quick Data Analysis using Excel Statistics Formulas
COUNTUnique You can not use the custom Excel COUNT Unique Formula with 'Quick Stats' for Quick Data Analysis using Excel Statistics Formulas Use the custom Excel COUNT Unique Formula with 'Range Stats' for Quick Data Analysis using Excel Statistics Formulas Use the custom Excel COUNT Unique Formula with 'Full Stats' for Quick Data Analysis using Excel Statistics Formulas
COUNTA You can not use the Excel COUNTA Formula with 'Quick Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel COUNTA Formula with 'Range Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel COUNTA Formula with 'Full Stats' for Quick Data Analysis using Excel Statistics Formulas
COUNTBLANK You can not use the Excel COUNTBLANK Formula with 'Quick Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel COUNTBLANK Formula with 'Range Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel COUNTBLANK Formula with 'Full Stats' for Quick Data Analysis using Excel Statistics Formulas
KURT You can not use the Excel KURT Formula with 'Quick Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel KURT Formula with 'Range Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel KURT Formula with 'Full Stats' for Quick Data Analysis using Excel Statistics Formulas
MAX Use the Excel MAX Formula with 'Quick Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel MAX Formula with 'Range Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel MAX Formula with 'Full Stats' for Quick Data Analysis using Excel Statistics Formulas
MAXA You can not use the Excel MAXA Formula with 'Quick Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel MAXA Formula with 'Range Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel MAXA Formula with 'Full Stats' for Quick Data Analysis using Excel Statistics Formulas
MEAN (use AVERAGE) There is no Excel MEAN Formula - Use the Excel AVERAGE Formula with 'Quick Stats' for Quick Data Analysis There is no Excel MEAN Formula - Use the Excel AVERAGE Formula with 'Range Stats' for Quick Data Analysis There is no Excel MEAN Formula - Use the Excel AVERAGE Formula with 'Full Stats' for Quick Data Analysis
MEDIAN Use the Excel MEDIAN Formula with 'Quick Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel MEDIAN Formula with 'Range Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel MEDIAN Formula with 'Full Stats' for Quick Data Analysis using Excel Statistics Formulas
MIN Use the Excel MIN Formula with 'Quick Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel MIN Formula with 'Range Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel MIN Formula with 'Full Stats' for Quick Data Analysis using Excel Statistics Formulas
MINA You can not use the Excel MINA Formula with 'Quick Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel MINA Formula with 'Range Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel MINA Formula with 'Full Stats' for Quick Data Analysis using Excel Statistics Formulas
MODE You can not use the Excel MODE Formula with 'Quick Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel MODE Formula with 'Range Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel MODE Formula with 'Full Stats' for Quick Data Analysis using Excel Statistics Formulas
Excel Formula Name Quick Stats Range Stats Full Stats
RANGE (MAX - MIN) You can not use the Excel RANGE Formula with 'Quick Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel RANGE Formula with 'Range Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel RANGE Formula with 'Full Stats' for Quick Data Analysis using Excel Statistics Formulas
RANK (asc & dec) You can not use the Excel RANK Formula with 'Quick Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel RANK Formula with 'Range Stats' for Quick Data Analysis using Excel Statistics Formulas You can not use the Excel RANK Formula with 'Full Stats' for Quick Data Analysis using Excel Statistics Formulas
RANKUnique (asc & dec) You can not use the Excel RANKU Formula with 'Quick Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel RANKU Formula with 'Range Stats' for Quick Data Analysis using Excel Statistics Formulas You can not use the Excel RANKU Formula with 'Full Stats' for Quick Data Analysis using Excel Statistics Formulas
SKEW You can not use the Excel SKEW Formula with 'Quick Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel SKEW Formula with 'Range Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel SKEW Formula with 'Full Stats' for Quick Data Analysis using Excel Statistics Formulas
STDEV Use the Excel STDEV Formula with 'Quick Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel STDEV Formula with 'Range Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel STDEV Formula with 'Full Stats' for Quick Data Analysis using Excel Statistics Formulas
STDEVA You can not use the Excel STDEVA Formula with 'Quick Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel STDEVA Formula with 'Range Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel STDEVA Formula with 'Full Stats' for Quick Data Analysis using Excel Statistics Formulas
STDEVP Use the Excel STDEVP Formula with 'Quick Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel STDEVP Formula with 'Range Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel STDEVP Formula with 'Full Stats' for Quick Data Analysis using Excel Statistics Formulas
STDEVPA You can not use the Excel STDEVPA Formula with 'Quick Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel STDEVPA Formula with 'Range Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel STDEVPA Formula with 'Full Stats' for Quick Data Analysis using Excel Statistics Formulas
SUM Use the Excel SUM Formula with 'Quick Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel SUM Formula with 'Range Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel SUM Formula with 'Full Stats' for Quick Data Analysis using Excel Statistics Formulas
TOTAL (use SUM) There is no Excel TOTAL Formula - Use the Excel SUM Formula with 'Quick Stats' for Quick Data Analysis There is no Excel TOTAL Formula - Use the Excel SUM Formula with 'Range Stats' for Quick Data Analysis There is no Excel TOTAL Formula - Use the Excel SUM Formula with 'Full Stats' for Quick Data Analysis
VAR You can not use the Excel VAR Formula with 'Quick Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel VAR Formula with 'Range Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel VAR Formula with 'Full Stats' for Quick Data Analysis using Excel Statistics Formulas
VARA You can not use the Excel VARA Formula with 'Quick Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel VARA Formula with 'Range Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel VARA Formula with 'Full Stats' for Quick Data Analysis using Excel Statistics Formulas
VARP You can not use the Excel VARP Formula with 'Quick Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel VARP Formula with 'Range Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel VARP Formula with 'Full Stats' for Quick Data Analysis using Excel Statistics Formulas
VARPA You can not use the Excel VARPA Formula with 'Quick Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel VARPA Formula with 'Range Stats' for Quick Data Analysis using Excel Statistics Formulas Use the Excel VARPA Formula with 'Full Stats' for Quick Data Analysis using Excel Statistics Formulas
Excel Function Name
29
Quick Stats
8
Range Stats
29
Full Stats
25

Flash Videos on EZ-Stat Add-in for Microsoft Excel

Flash Video Titles for the EZ-Stat Add-in Tool for Microsoft Excel Released Runtime

Using EZ-Stat's "Full Stats" to Quickly Analyze Excel Data   08/12/2008   04:10
    Analyze Excel Data using up to 24 Standard Excel Formulas
    calculated at changes in up to four sort fields.
 
EZ-Stat for Microsoft Excel Video Demo 09/04/2007 06:45
    (See how to quickly and easily create 29 statistics for Excel List data)
 

Download the Free 15-Day Trial of the
EZ-Stat Add-in Tool for Microsoft Excel

Installs and Completely Uninstalls in Seconds.
Securely purchase from inside Excel to automatically self-register.

EZ-Stat for Excel Version 9.1    SLP-US $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 non-numeric fields.
Calculate up to 29 Excel Formulas and Excel Functions.          
Choose the numeric fields for which to calculate statistics.
Learn EZ-Stat within minutes of installing the Free 15-day trail!
Latest CNET version is 9.1 on September 10, 2010.
New Version 01/14/12
Get it from the DPPI website before the latest version is available on CNET Download.com!

Buy EZ-Stat for $39.95