- Data Service
- About
- Data Sources
- Azure Data Market
- CSV
- Date Time
- DB2
- Directory
- Ebay
- European Central Bank
- Excel
- Google Analytics
- Google Big Query
- Google Trends
- HTML Tables
- Import.io
- JSON
- Microsoft Office Access
- MongoDB
- MySQL
- OData
- Oracle
- PostgreSQL
- Python
- Quandl
- R Language
- Salesforce.com
- Search Metrics
- SharePoint
- SQL Server
- SQL Server Stored Procedure
- Statistics Denmark
- TARGIT Analysis
- Weather
- Windows Event Log
- Wine.com
- Cubes
- Formats
- Installation

# Statistical

## average

(float Number)

Returns the average (arithmetic mean) of the arguments. Calculates numbers only.

Example: Average(1, 3, 3, 1, "true", "false", "hello,[...]") returns 2.0

Number: Required. The first number for which you want the average.

## averagea

(Object Value)

Returns the average (arithmetic mean) of the arguments. Text and logical value FALSE have the value 0;

the logical value TRUE has the value 1.

Example: AverageA(1, 3, 3, 1, true, false, "hello,[...]") results in (1 + 3 + 3 + 1 + 1 + 0 + 0) / 7.0 (~1.28)

Value: Required. The first object for which you want the average.

## count

(float Number)

The COUNT function counts the number of arguments that contain numbers.

Example: Count(1, 3, 3, 1, true, false, "hello,[...]") returns 4.

Number: Required. The first number you want to count

## counta

(Object Value)

The COUNT function counts the number of arguments. Text and logical value FALSE have the value 0;

the logical value TRUE has the value 1.

Example: CountA(1, 3, 3, 1, true, false, "hello,[...]") returns 7

Value: Required. The first object you want to count

## distinctcnt

(Object object1)

Returns distinct count of the collection of values.

Example: DISTINCTCNT(1,1,2,8,10,5) returns distinct count (5).

object1: Required. The first object that you want to count distinc values based on.

## max

(float Number)

Returns the largest value in a list of arguments. Ignores logical values and text.

Example: MAX(1, 3, 3, 1, true, false, "hello") returns 3.

Number: Required. The first object argument for which you want to find the largest value.

## maxa

(Object Value)

Returns the largest value in a list of arguments. Text and logical value FALSE have the value 0;

the logical value TRUE has the value 1.

Example: MAXA(1, 3, 3, 1, true, false, "hello") returns 3.

Value: Required. The first object argument for which you want to find the largest value.

## min

(float Number)

Returns the smallest value in a list of arguments. Ignores logical values and text.

Example: MIN(1, 3, 3, 1, true, false, "hello") returns 1.

Number: Required. The first number argument for which you want to find the smallest value.

## mina

(Object Value)

Returns the smallest value in a list of arguments. Text and logical value FALSE have the value 0;

the logical value TRUE has the value 1.

Example: MINA(1, 3, 3, 1, true, false, "hello") returns 0.

Value: Required. The first object argument for which you want to find the smallest value.

## stdev

(float number1)

Estimates standard deviation based on a sample.

The standard deviation is a measure of how widely values are dispersed from the average value (the mean).

Example: STDEV(1345,1301,1368,1322,1310,1370,1318,1350,1303,1299)

is a standard deviation of breaking strength (27.46392).

number1: Required. The first number argument corresponding to a sample of a population/

## stdeva

(Object Value1)

Estimates standard deviation based on a sample. The standard deviation is a measure of how widely values are dispersed from the average value (the mean).

Text and logical value FALSE have the value 0; the logical value TRUE has the value 1.

Example: STDEVA(1345,1301,1368,1322,1310,1370,1318,1350,1303,1299)

is a standard deviation of breaking strength for all the tools (27.46391572).

Value1: Value1 is required, subsequent values are optional.

## stdevp

(float Value1)

Calculates standard deviation based on the entire population given as arguments.

The standard deviation is a measure of how widely values are dispersed from the average value (the mean).

Example: STDEVP(1345,1301,1368,1322,1310,1370,1318,1350,1303,1299)

is a standard deviation of breaking strength, assuming only 10 tools are produced (26.05455814).

Value1: Required. The first number argument corresponding to a population.

## stdevpa

(Object Value1)

Calculates standard deviation based on the entire population given as arguments, including text and logical values.

The standard deviation is a measure of how widely values are dispersed from the average value (the mean).

Text and logical value FALSE have the value 0; the logical value TRUE has the value 1.

Example: STDEVPA(1345,1301,1368,1322,1310,1370,1318,1350,1303,1299)

is a standard deviation of breaking strength, assuming only 10 tools are produced (26.05455814).

Value1: Value1 is required, subsequent values are optional.

## var

(float number1)

Estimates variance based on a sample.

Example: VAR(1345,1301,1368,1322,1310,1370,1318,1350,1303,1299)

is a variance for the breaking strength of the tools (754.2667).

number1: Required. The first object argument corresponding to a sample of a population.

## vara

(Object Value1)

Estimates variance based on a sample. Text and logical value FALSE have the value 0; the logical value TRUE has the value 1.

Example: VARA(1345,1301,1368,1322,1310,1370,1318,1350,1303,1299) is a variance for the breaking strength of the tools (754.2667).

Value1: Description

## varp

(float number1)

Calculates variance based on the entire population.

Example: VARP(1345,1301,1368,1322,1310,1370,1318,1350,1303,1299) is a variance of breaking strengths for all the tools,

assuming that only 10 tools are produced (678.84).

number1: Required. The first number argument corresponding to a population.

## varpa

(Object Value1)

Calculates variance based on the entire population. Text and logical value FALSE have the value 0;

the logical value TRUE has the value 1.

Example: VARPA(1345,1301,1368,1322,1310,1370,1318,1350,1303,1299)

is a variance of breaking strengths for all the tools, assuming that only 10 tools are produced (678.84).

Value1: Value1 is required, subsequent values are optional.