Average - Revision history

Cg van at 10:33, 20 December 2011

2011-12-20T10:33:49Z

← Older revision		Revision as of 10:33, 20 December 2011
Line 1:		Line 1:
	~~[[Category:Functions_Used_in_where_Expressions]]~~		{{HelpFiles}}
	{{HelpFiles}}

	====average====		==== average ====

	Gets double values for row values of the column and calculates the average value of those values.		Gets double values for row values of the column and calculates the average value of those values.

	Returns empty if there is no valid rows		Returns empty if there is no valid rows

			'''Syntax'''

			average(''columnName'')

	'''~~Syntax~~'''		'''Arguments'''

	~~average(~~''columnName'')		''columnName'': Is the name of a column in the data table.

	'''~~Arguments~~'''		'''Return type'''

	~~''columnName'': Is the name of a column in the data table.~~		number or empty

	'''~~Return type~~'''		'''Examples'''

	~~number or empty~~		//get the average score of all students

	~~'''Examples'''~~		number a = average(Score) where (true);

	~~//get the average score of all students~~		print(a);

	~~number a = average(Score) where (true);~~		'''Availability'''

	~~'''Availability'''~~		Version 4.8 __NOTOC__ <!-- imported from file: 758.htm-->

	~~Version 4.8~~		[[Category:Functions_Used_in_where_Expressions]]
	~~__NOTOC__~~
	~~<!-- imported from file~~: ~~758.htm-->~~

Cg_pham at 08:11, 12 December 2011

2011-12-12T08:11:17Z

← Older revision		Revision as of 08:11, 12 December 2011
Line 1:		Line 1:
	[[Category:Functions_Used_in_where_Expressions]]		[[Category:Functions_Used_in_where_Expressions]]
			{{HelpFiles}}

	====average====		====average====

Cg_pham at 04:11, 28 March 2011

2011-03-28T04:11:42Z

← Older revision		Revision as of 04:11, 28 March 2011
Line 1:		Line 1:
	[[Category:~~Math_Functions~~]]		[[Category:Functions_Used_in_where_Expressions]]

Cg_pham at 06:34, 22 March 2011

2011-03-22T06:34:42Z

← Older revision		Revision as of 06:34, 22 March 2011
Line 1:		Line 1:
	[[Category:~~HelpBooks~~]]		[[Category:Math_Functions]]

Catglobe: jrfconvert import

2011-03-07T08:56:17Z

jrfconvert import

← Older revision		Revision as of 08:56, 7 March 2011
Line 4:		Line 4:
	====average====		====average====

	Gets ~~numeric~~ values of ~~all~~ the ~~parameters~~ and ~~returns~~ the average value of ~~them. The~~ values ~~of all parameters must be convertible to numbers~~.		Gets double values for row values of the column and calculates the average value of those values.

			Returns empty if there is no valid rows

	'''Syntax'''		'''Syntax'''

	average(''~~exp1, exp2, exp3,~~'' …)		average(''columnName'')

	'''Arguments'''		'''Arguments'''

	''~~exp~~''i: ~~Is an expression~~ of ~~any type~~		''columnName'': Is the name of a column in the data table.

	'''Return type'''		'''Return type'''

	number		number or empty

	'''Examples'''		'''Examples'''

	~~number a = average(1, 2, 3, 4, 5);~~		//get the average score of all students

	//~~a = 3~~

	~~number a =~~ average~~(1, "3");~~

	//a = 2		number a = average(Score) where (true);

	'''Availability'''		'''Availability'''
Line 32:		Line 30:
	Version 4.8		Version 4.8
	__NOTOC__		__NOTOC__
	<!-- imported from file: ~~565~~.htm-->		<!-- imported from file: 758.htm-->

Catglobe: jrfconvert import

2011-03-07T08:49:00Z

jrfconvert import

New page

[[Category:HelpBooks]]

====average====

Gets numeric values of all the parameters and returns the average value of them. The values of all parameters must be convertible to numbers.

'''Syntax'''

average(''exp1, exp2, exp3,'' …)

'''Arguments'''

''exp''i: Is an expression of any type

'''Return type'''

number

'''Examples'''

number a = average(1, 2, 3, 4, 5);

//a = 3

number a = average(1, "3");

//a = 2

'''Availability'''

Version 4.8
__NOTOC__