Related Topics:
	Function Wizard

Spreadsheet Functions

This section presents the functions that can be entered in analysis workbooks and general spreadsheets in RGA by using the Function Wizard. The functions are grouped into the following categories:

• Data source functions return values that are based on the analysis in a specified data source.

Syntax: RELIABILITY (Data_Src,Time,[Conf_Level])

Example: =RELIABILITY("Folio1!Data1",1000,0.95) uses the analysis in Folio1!Data1 to return the 95% one-sided confidence bound on the reliability of an item that has operated for 1,000 hours.

• Mathematical functions do not require a data source. They perform a variety of mathematical and statistical operations (e.g., sine, pi or averages).

Syntax: AVERAGE(Number1,Number2,...)

Example 1: =AVERAGE(10,7,9,27,2) sums the numbers, then divides by 5 to return 11.

Example 2: =AVERAGE(A1:A6) returns the average of the values in cells A1 through A6.

Data Source Functions

Mathematical Functions