Manuals/calci/QUARTILE - Revision history

Devika at 22:00, 8 August 2018

2018-08-08T22:00:38Z

Devika: /* Description */

2018-06-08T19:20:37Z

Description

Devika at 19:20, 8 June 2018

2018-06-08T19:20:09Z

Devika: /* Examples */

2018-02-27T21:01:49Z

Examples

Jayaram at 06:41, 13 March 2017

2017-03-13T06:41:33Z

Jayaram at 11:29, 9 March 2017

2017-03-09T11:29:44Z

Swapna at 01:40, 20 June 2015

2015-06-20T01:40:29Z

Devika at 15:50, 11 May 2015

2015-05-11T15:50:20Z

Abin: /* Examples */

2014-01-08T08:08:43Z

Examples

Abin: /* Examples */

2014-01-08T07:50:47Z

Examples

@@ Line 2: / Line 2: @@
 *<math>Array</math>  is the array of numeric values
 *<math>Quartile</math> indicates the  position of the quartile
 ==Description==

@@ Line 19: / Line 19: @@
 . The array is empty
 . <math>Quartile<0</math> or <math>Quartile>4</math>
-. MIN,MEDIAN and MAX will give the same value as QUARTILE when <math>qu</math> is 0,2,and 4 respectively.
+. MIN,MEDIAN and MAX will give the same value as QUARTILE when <math>Quartile</math> is 0,2,and 4 respectively.
 ==Examples==

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''QUARTILE(ar,qu)'''</div><br/>
+<div style="font-size:30px">'''QUARTILE(Array,Quartile)'''</div><br/>
-*<math>ar</math>  is the array of numeric values
+*<math>Array</math>  is the array of numeric values
-*<math> qu</math> indicates the  position of the quartile
+*<math>Quartile</math> indicates the  position of the quartile
 ==Description==
@@ Line 7: / Line 7: @@
 *Quartiles are the values that divide a list of numbers into quarters.
 *A quartile is a type of quantile.
-*In <math> QUARTILE(ar,qu)</math>, <math>ar</math> is the array  of numeric values to find the Quartile and <math> qu</math> is the position of the quartile.
+*In <math> QUARTILE(Array,Quartile)</math>, <math>Array</math> is the array  of numeric values to find the Quartile and <math> Quartile</math> is the position of the quartile.
   '''qu value'''   '''QUARTILE(result)'''
    -           Minimum value
@@ Line 15: / Line 15: @@
     -          Maximum value
 *The difference between the upper and lower quartiles is called the inter-quartile range.
-*When we are giving <math>qu</math> in a decimal value, then it will change in to integer.
+*When we are giving <math>Quartile</math> in a decimal value, then it will change in to integer.
 *This function will give the result as error when
 . The array is empty
-. <math>qu<0</math> or <math>qu>4</math>
+. <math>Quartile<0</math> or <math>Quartile>4</math>
 . MIN,MEDIAN and MAX will give the same value as QUARTILE when <math>qu</math> is 0,2,and 4 respectively.

@@ Line 43: / Line 43: @@
 |}
-*=QUARTILE(A1:A5,0) = 2
+*=QUARTILE(A1:A4,0) = 2
-*=QUARTILE(A1:A5,1) = 3
+*=QUARTILE(A1:A4,1) = 6.5
 *=QUARTILE(B2:E3,3) = 16.25
 *=QUARTILE(A2:B3,3) = 12.5

← Older revision		Revision as of 06:41, 13 March 2017
Line 65:		Line 65:


−	[[Z_API_Functions \| List of Main Z Functions]]	+	*[[Z_API_Functions \| List of Main Z Functions]]

−	[[ Z3 \| Z3 home ]]	+	*[[ Z3 \| Z3 home ]]

← Older revision		Revision as of 11:29, 9 March 2017
Line 61:		Line 61:
	==References==		==References==
	*[http://en.wikipedia.org/wiki/Quartile Quartile]		*[http://en.wikipedia.org/wiki/Quartile Quartile]
		+
		+
		+
		+
		+	[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	[[ Z3 \| Z3 home ]]

@@ Line 48: / Line 48: @@
 *=QUARTILE(A2:B3,3) = 12.5
 *=QUARTILE(A5:E5,3) = NAN
 ==See Also==

← Older revision		Revision as of 15:50, 11 May 2015
Line 56:		Line 56:

	==References==		==References==
		+	*[http://en.wikipedia.org/wiki/Quartile Quartile]

@@ Line 40: / Line 40: @@
 |-
 ! 5
-| 11 || 20 || 9  ||78 || 25
+|   ||   ||    ||  ||
 |}
-#ar={2,3,7,9,15}
+*=QUARTILE(A1:A5,0) = 2
-*QUARTILE(A1:A5,0)=2
+*=QUARTILE(A1:A5,1) = 3
-*QUARTILE(A1:A5,1)=3
+*=QUARTILE(B2:E3,3) = 16.25
-#ar={8,12,13,20,25,28,42}
+*=QUARTILE(A2:B3,3) = 12.5
-*QUARTILE(B2:B8,3)=26.5
+*=QUARTILE(A5:E5,3) = NAN
 ==See Also==