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.

Description

ANOVASINGLEFACTOR(Array, Alpha, GroupBy, NewTableFlag)

Analysis Of Variances(ANOVA) is a method of checking relationship between two or more data sets.
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").
can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE.
If is TRUE, the result is displayed on new zspace sheet.

Examples

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

1	3
7	8
12	5
17	18

=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

References

ANOVA Single Factor

List of Main Z Functions

Z3 home

@@ 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 108: / Line 107: @@
 ==Related Videos==
-{{#ev:youtube|EFd1FoHI_OI|280|center|ANOVASINGLEFACTOR}}
+{{#ev:youtube|EFdlFoHI_0I|280|center|ANOVASINGLEFACTOR}}
 == See Also ==
@@ 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 ]]