Manuals/calci/FTESTANALYSIS - Revision history

Devika at 22:07, 7 August 2018

2018-08-07T22:07:53Z

Devika at 18:26, 6 June 2018

2018-06-06T18:26:34Z

Devika: /* Description */

2018-02-26T20:50:46Z

Description

Jayaram at 06:05, 13 March 2017

2017-03-13T06:05:12Z

Jayaram at 11:16, 9 March 2017

2017-03-09T11:16:07Z

Swapna at 19:33, 12 June 2015

2015-06-12T19:33:13Z

Devika: /* ZOS */

2015-06-08T18:56:49Z

ZOS

Devika at 17:42, 8 June 2015

2015-06-08T17:42:55Z

Devika: /* Examples */

2015-06-03T16:37:25Z

Examples

Devika: /* See Also */

2015-06-03T15:55:59Z

@@ Line 3: / Line 3: @@
 *<math>Alpha</math>  is the significance level.
 *<math>Newtableflag</math>  is the logical value.
 ==Description==

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''FTESTANALYSIS(ar1,ar2,alpha,newtableflag)'''</div><br/>
+<div style="font-size:30px">'''FTESTANALYSIS (Array1,Array2,Alpha,NewTableFlag)'''</div><br/>
-*<math>ar1</math> and <math>ar2 </math> are array of data.
+*<math>Array1</math> and <math>Array2 </math> are array of data.
-*<math>alpha</math>  is the significance level.
+*<math>Alpha</math>  is the significance level.
-*<math>newtableflag</math>  is the logical value.
+*<math>Newtableflag</math>  is the logical value.
 ==Description==
@@ Line 14: / Line 14: @@
 *For example, the comparison of SCORES across GROUPS,where there are two groups.
 *The purpose is to determine if the mean SCORE on a test is different for the two groups tested (i.e., control and treatment groups)
-*In FTESTANALYSIS(ar1,ar2,alpha,newtableflag) where <math>ar1</math> is the data of  first array, <math>ar2</math> is the data of second array.
+*In FTESTANALYSIS (Array1,Array2,Alpha,NewTableFlag) where <math>Array1</math> is the data of  first array, <math>Array2</math> is the data of second array.
-*<math> alpha </math> is the significance level which ranges from 0 to 1.
+*<math> Alpha </math> is the significance level which ranges from 0 to 1.
-*<math> newtableflag </math> is the logical value like TRUE or FALSE.
+*<math> Newtableflag </math> is the logical value like TRUE or FALSE.
 *TRUE is indicating the result will display in new worksheet.Suppose we are omitted the lv value it will consider the value as FALSE.
 *The F statistic of this function calculated by:
@@ Line 28: / Line 28: @@
 *In this function the array may be any numbers, names, or references that contains numbers.
 *values are not considered if the array contains any text, logical values or empty cells.
-When the <math>ar1</math> or <math>ar2</math> is less than 2 or the variance of the array value is zero, then this function will return the result as error.
+When the <math>Array1</math> or <math>Array2</math> is less than 2 or the variance of the array value is zero, then this function will return the result as error.
 ==ZOS==
 *The syntax is to use this function in ZOS is <math>FTESTANALYSIS (Array1,Array2,Alpha,NewTableFlag)</math>
 **<math>Array1</math> and <math>Array2 </math> are array of data.
-**<math>alpha</math>  is the significance level.
+**<math>Alpha</math>  is the significance level.
-**<math>newtableflag</math>  is the logical value.
+**<math>Newtableflag</math>  is the logical value.
 *For e.g.,FTESTANALYSIS([17,22,26,31,49],[50,47,45,13,24],0.4,true)
 *FTESTANALYSIS([24..30],[45..51],0.4,true)

@@ Line 19: / Line 19: @@
 *TRUE is indicating the result will display in new worksheet.Suppose we are omitted the lv value it will consider the value as FALSE.
 *The F statistic of this function calculated by:
-<math>\frac {Sx^2}{Sy^2}</math> has an F-distribution with <math>n−1</math> and <math>m−1</math> degrees of freedom.
+<math>\frac {Sx^2}{Sy^2}</math> has an F-distribution with n−1 and m−1 degrees of freedom.
 *Also <math>Sx^2 </math> is the sample variance of first set of values.
 *And <math>Sy^2 </math> is the sample variance of second set of values.

← Older revision		Revision as of 06:05, 13 March 2017
Line 151:		Line 151:


−	[[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:16, 9 March 2017
Line 148:		Line 148:
	==References==		==References==
	[http://en.wikipedia.org/wiki/F-test F Test]		[http://en.wikipedia.org/wiki/F-test F Test]
		+
		+
		+
		+	[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	[[ Z3 \| Z3 home ]]

@@ Line 136: / Line 136: @@
 | 1.7528541706121352 ||
 |}
 ==See Also==

@@ Line 52: / Line 52: @@
 {| class="wikitable"
 |-
 ! !!Variable1 !! Variable2
 |-
-| Mean || 23.25 || 18.5
+! Mean
 |-
-| Variance || 58.916666666666664 || 79
+! Variance
 |-
-| Observations || 4 || 4
+! Observations
 |-
-| Degree Of Freedom || 3 || 3
+! Degree Of Freedom
 |-
-| F-Value || 0.7457805907172995 ||
+! F-Value
 |-
-| P(F<=f) one-tail || 0.407624533735915 ||
+! P(F<=f) one-tail
 |-
-| F Critical one-tail || 1 ||
+! F Critical one-tail
 |}
@@ Line 95: / Line 103: @@
 =FTEST(A1:A5,B1:B5,0.30,false)
 {| class="wikitable"
 |-
 ! !!Variable1 !! Variable2
 |-
-| Mean || 18.6 || 30
+! Mean
 |-
-| Variance || 264.29999999999995 || 250
+! Variance
 |-
-| Observations || 5 || 5
+! Observations
 |-
-| Degree Of Freedom || 4 || 4
+! Degree Of Freedom
 |-
-| F-Value || 1.0572 ||
+! F-Value
 |-
-| P(F<=f) one-tail || 0.4791517866106137 ||
+! P(F<=f) one-tail
 |-
-| F Critical one-tail || 1.7528541706121352 ||
+! F Critical one-tail
 |}

@@ Line 114: / Line 114: @@
 ==See Also==
 *[[Manuals/calci/FDIST  | FDIST ]]
 *[[Manuals/calci/FINV  | FINV ]]