Difference between revisions of "Manuals/calci/ANOVASINGLEFACTOR"

Latest revision as of 14:33, 17 August 2018

ANOVASINGLEFACTOR (Array,Alpha,GroupBy,NewTableFlag)

where, $Array$ is an array of numbers or reference to cells containing array
$Alpha$ represents a constant value between '0' and '1'
$GroupBy$ is a method to perform the analysis by columns or rows
decides if the output is to be displayed in the same worksheet or a new space cube.
- ANOVASINGLEFACTOR(), performs a simple analysis of variances between two data sets.This should be used when you have one indepenedent variable.

ANOVASINGLEFACTOR(Array, Alpha, GroupBy, NewTableFlag)

Analysis Of Variances(ANOVA) is a method of checking relationship between two or more data sets.
$Alpha$ should be in between '0' and '1'. Else Calci displays #N/A error message.
Analysis can be done by columns or rows. The choice should be entered in quotes (e.g. "COLUMNS" or "ROWS").
$NewTableFlag$ can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE.
If $NewTableFlag$ is TRUE, the result is displayed on new zspace sheet.

Consider the following table with Columns A and B as array inputs for ANOVASINGLEFACTOR() function.

=ANOVASINGLEFACTOR(A1:B4,0.05,"ROWS",TRUE) displays results in a new space.

Anova: Single Factor
SUMMARY
Groups	Count	Sum	Average	Variance
RowA	4	37	9.25	46.916666666666664
RowB	4	34	8.5	44.333333333333336

ANOVA
Source of Variation	Sum of Squares	Degree of Freedom	Mean of Squares	F	Probability	F Critical
Between Groups:	1.125	1	1.125	0.024657534246575342	0.8886077621608085	5.987702296337573
Within Groups:	273.75	6	45.625
Total:	274.875	7

@@ Line 1: / Line 1: @@
-=ANOVASINGLEFACTOR(Array, Alpha, GroupBy, NewTableFlag)=
+<div style="font-size:30px">'''ANOVASINGLEFACTOR (Array,Alpha,GroupBy,NewTableFlag)'''</div><br/>
 *where, <math>Array</math> is an array of numbers or reference to cells containing array
 *<math>Alpha</math> represents a constant value between '0' and '1'
 *<math>GroupBy</math> is a method to perform the analysis by columns or rows
 *<math>NewTableFlag</math> decides if the output is to be displayed in the same worksheet or a new space cube.
+**ANOVASINGLEFACTOR(), performs a simple analysis of variances between two data sets.This should be used when you have one indepenedent variable.
-ANOVASINGLEFACTOR() performs a simple analysis of variances between two data sets.
 == Description ==
@@ Line 51: / Line 50: @@
 |}
-  =ANOVASINGLEFACTOR(A1:B4,0.05,"COLUMNS",TRUE) displays results in a new space.
+  =ANOVASINGLEFACTOR(A1:B4,0.05,"ROWS",TRUE) displays results in a new space.
 <div id="8SpaceContent" class="zcontent" align="left">
@@ Line 64: / Line 63: @@
 ! Variance
 |- class="odd"
-| ColumnA
+| RowA
 | 4
 | 37
@@ Line 70: / Line 69: @@
 | 46.916666666666664
 |- class="even"
-| ColumnB
+| RowB
 | 4
 | 34
@@ Line 118: / Line 117: @@
 *[http://en.wikipedia.org/wiki/One-way_analysis_of_variance ANOVA Single Factor]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]