Obtaining Population statistics with Proc Univariate

Proc Univariate

19 easy to perform tests

Proc univariate provides descriptive statistics for a single variable.

Proc UNIVARIATE requires that the input data be available either in Excel worksheets, Access Database, DBase IV or in tab separated value (tsv) or comma separated value format. The primary use of proc UNIVARIATE is to determine the characteristics of a population in order to determine what further testing and analysis is required. However there are many additional types of tests that can be performed. Further examples of use are available.

Use Excel for auditing and analysis ? Why not try our Analytic software for the the most common functions - Benford's Law, outliers, univariate statistics, CMA sampling, interval sampling, sample size calculation, stratification, classification, holiday date checking, duplicates, gaps, analytic review, trend analysis, credit card validation (luhn-10) etc. This desktop version operates from within Excel (an add-in). Want to learn more? Visit the Analytics home page (or view the link Operation Guide for a full description and screen shots).

Proc Univariate provides the following statistics for the researcher/auditor:

Number of observations in the population
Median value
Mode value
Percentiles as follows- 1,5,10,25,50,75,90,95,98,99
Top 5 values (largest) (with position in file)
Bottom 5 values (smallest) (with position in file)
Quartiles
Range
Mean
Variance
Standard Deviation
Minimum Value
Maximum value
Sum of Squares
Skewness
Kurtosis
Number of observations equal to zero, less than zero and greater than zero
Number of missing observations
Corrected Sum of Squares
Uncorrected Sum of Squares
Standard Error of the Mean

More information is available on the electronic work papers page. Proc univariate Example Output.

Analysts interested in Proc Univariate may also be interested in Proc Summary.



	Proc Univariate 19 easy to perform tests Proc univariate provides descriptive statistics for a single variable. Proc UNIVARIATE requires that the input data be available either in Excel worksheets, Access Database, DBase IV or in tab separated value (tsv) or comma separated value format. The primary use of proc UNIVARIATE is to determine the characteristics of a population in order to determine what further testing and analysis is required. However there are many additional types of tests that can be performed. Further examples of use are available. Use Excel for auditing and analysis ? Why not try our Analytic software for the the most common functions - Benford's Law, outliers, univariate statistics, CMA sampling, interval sampling, sample size calculation, stratification, classification, holiday date checking, duplicates, gaps, analytic review, trend analysis, credit card validation (luhn-10) etc. This desktop version operates from within Excel (an add-in). Want to learn more? Visit the Analytics home page (or view the link Operation Guide for a full description and screen shots). Proc Univariate provides the following statistics for the researcher/auditor: Number of observations in the population Median value Mode value Percentiles as follows- 1,5,10,25,50,75,90,95,98,99 Top 5 values (largest) (with position in file) Bottom 5 values (smallest) (with position in file) Quartiles Range Mean Variance Standard Deviation Minimum Value Maximum value Sum of Squares Skewness Kurtosis Number of observations equal to zero, less than zero and greater than zero Number of missing observations Corrected Sum of Squares Uncorrected Sum of Squares Standard Error of the Mean More information is available on the electronic work papers page. Proc univariate Example Output. Analysts interested in Proc Univariate may also be interested in Proc Summary.