Scribd
Upload
6 views2 pages

Understanding the STDEVA Function in Excel

The document describes the syntax of important statistical functions in Microsoft Excel including AVERAGE, STDEVA, and RANK.AVG. The AVERAGE function calculates the average of numbers or cell references. The STDEVA function calculates the standard deviation of a sample of values. The RANK.AVG function ranks a number within a list and returns its position as a percentage or fraction.

Uploaded by

goldstone
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
6 views2 pages

Understanding the STDEVA Function in Excel

The document describes the syntax of important statistical functions in Microsoft Excel including AVERAGE, STDEVA, and RANK.AVG. The AVERAGE function calculates the average of numbers or cell references. The STDEVA function calculates the standard deviation of a sample of values. The RANK.AVG function ranks a number within a list and returns its position as a percentage or fraction.

Uploaded by

goldstone
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

STATISTICAL RANK CALCULATION

Syntax of important functions

1. AVERAGE function

Syntax
AVERAGE(number1, [number2], ...)

The AVERAGE function syntax has the following arguments:

Number1 Required. The first number, cell reference, or range for which you want the
average.

Number2, ... Optional. Additional numbers, cell references or ranges for which you
want the average, up to a maximum of 255.

2. STDEVA function

Syntax
STDEVA(value1, [value2], ...)

The STDEVA function syntax has the following arguments:

Value1, value2, ... Value1 is required, subsequent values are optional. 1 to 255 values
corresponding to a sample of a population. You can also use a single array or a reference
to an array instead of arguments separated by commas.

[Link] function

Syntax
[Link](number,ref,[order])

The [Link] function syntax has the following arguments:

Number Required. The number whose rank you want to find.

Ref Required. An array of, or a reference to, a list of numbers. Nonnumeric values in Ref
are ignored.

Order Optional. A number specifying how to rank number.

You might also like