Difference between revisions of "Manuals/calci/ANOVASINGLEFACTOR"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left">Analysis Of Variances(ANOVA) is a method of checking if there is a relationship between two ror more data sets.ANOVA :Sin...")
 
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left">Analysis Of Variances(ANOVA) is a method of checking if there is a relationship between two ror more data sets.ANOVA :Single Factor performs a simple analysis of variances between two data sets.</div>
+
=ANOVASINGLEFACTOR(Array, Alpha, GroupBy, NewTableFlag)=
−
----
 
−
<div id="1SpaceContent" class="zcontent" align="left">ANOVA :Single Factor performs a simple analysis of variances between two data sets.</div>
 
−
----
 
−
<div id="7SpaceContent" class="zcontent" align="left">
 
  
−
ANOVA:SINGLE FACTOR returns #ERROR, if Alpha &lt;0 or Alpha &gt;1.
+
*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> that decides to display the output in the same worksheet or a new space cube.
  
−
</div>
+
ANOVASINGLEFACTOR() performs a simple analysis of variances between two data sets.
−
----
 
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
  
−
ANOVA : SINGLE FACTOR
+
== Description ==
 +
ANOVASINGLEFACTOR(Array, Alpha, GroupBy, NewTableFlag)
  
−
</div></div>
+
*Analysis Of Variances(ANOVA) is a method of checking relationship between two or more data sets.
−
----
+
*<math>Alpha</math> should be in between '0' and '1'. Else Calci displays #N/A error message.
−
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">what is ANOVA?</div><div class="ZEditBox"><center></center></div></div>
+
*Analysis can be done by columns or rows. The choice should be entered in quotes (e.g. "COLUMNS" or "ROWS").
−
----
+
*<math>NewTableFlag</math> can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE.
−
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
+
*If <math>NewTableFlag</math> is TRUE, the result is displayed on new zspace sheet.
−
----
 
−
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
 
−
----
 
−
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
 
−
----
 
−
<div id="9SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax</div><div class="ZEditBox"><center></center></div></div>
 
−
----
 
−
<div id="5SpaceContent" class="zcontent" align="left">
 
  
−
<nowiki>=</nowiki>'''ANOVASIGLEFACTOR'''(Array, Alpha, GroupBy,NewTableFlag)
+
== Examples ==
  
−
where,
+
Consider the following table with Columns A and B as array inputs for ANOVASINGLEFACTOR() function.
  
−
'''Array '''- Input range should be one or two blocks.
 
−
 
−
'''Alpha '''- represents the constant and value in between 0 and 1.
 
−
 
−
'''GroupBy''' - Either groupby columns or rows.
 
−
 
−
'''NewTableFlag''' - is the TRUE or FALSE.If set as TRUE, the result in new sheet.If NewTableFlag is omitted, it assumed to be false.
 
−
 
−
</div>
 
−
----
 
 
<div id="2SpaceContent" class="zcontent" align="left">
 
<div id="2SpaceContent" class="zcontent" align="left">
  
 
{| id="TABLE3" class="SpreadSheet blue"
 
{| id="TABLE3" class="SpreadSheet blue"
 
|- class="even"
 
|- class="even"
 +
| class="sshl_f" | 1
 +
| class=" " |3
 
| class=" " |
 
| class=" " |
−
| Column1
+
 
−
| class="  " | Column2
 
−
| Column3
 
−
| Column4
 
 
|- class="odd"
 
|- class="odd"
−
| class=" " | Row1
+
| class="sshl_f" | 7
−
| class=" " | 1
+
| class=" " |8
−
| class=" " | 3
+
| class=" " |
−
| class="sshl_f" | 15Space
+
 
−
| class="sshl_f" | 5
 
 
|- class="even"
 
|- class="even"
−
| class=" " | Row2
+
| class="sshl_f" | 12
−
| class=" " | 7
+
| class=" " |5
−
| class=" " | 8
+
| class=" " |
−
| class="   " | 9
+
 
−
| class="sshl_f" | 128
 
 
|- class="odd"
 
|- class="odd"
−
| Row3
+
| class="sshl_f" | 17
−
| class=" " | 12
+
| class=" " |18
−
| class=" " | 5
+
| class=" " |
−
| 14
+
 
−
| class="sshl_f    " | 15
 
 
|- class="even"
 
|- class="even"
−
| Row4
+
| class="sshl_f" |  
−
| class=" " | 17
+
| class=" " |
−
| class=" " | 18
+
| class=" " |
−
| class="sshl_f" | #ERROR
 
−
| class="  " | 20
 
−
|- class="odd"
 
−
| class=" " | Row5
 
−
| 37
 
−
| class="  " | 31
 
−
| class="SelectTD1 ChangeBGColor SelectTD1" | 23
 
−
| 168
 
−
|- class="even"
 
−
| Row6
 
−
| class="sshl_f" | 16Space
 
−
| 0.850904
 
−
| 1.619775
 
−
| 0.525322
 
 
|}
 
|}
  
−
<div align="left">[[Image:calci1.gif]]</div></div>
+
=ANOVASINGLEFACTOR(A1:B4,0.5,"COLUMNS",TRUE) displays results in a new space.
 
----
 
----
 
<div id="8SpaceContent" class="zcontent" align="left">
 
<div id="8SpaceContent" class="zcontent" align="left">
Line 101: Line 63:
 
! Variance
 
! Variance
 
|- class="odd"
 
|- class="odd"
−
| Column1
+
| ColumnA
 
| 4
 
| 4
 
| 37
 
| 37
Line 107: Line 69:
 
| 46.916666666666664
 
| 46.916666666666664
 
|- class="even"
 
|- class="even"
−
| Column2
+
| ColumnB
 
| 4
 
| 4
 
| 34
 
| 34
Line 131: Line 93:
 
| 0.024657534246575342
 
| 0.024657534246575342
 
| 0.8886077621608085
 
| 0.8886077621608085
−
| 5.98702940083107
+
| 5.987702296337573
 
|- class="even"
 
|- class="even"
 
| Within Groups:
 
| Within Groups:
Line 143: Line 105:
 
|}
 
|}
  
−
</div>
+
== See Also ==
−
----
 
−
<div id="13SpaceContent" class="zcontent" align="left">
 
  
−
{| id="TABLE4" class="SpreadSheet blue"
+
*[[Manuals/calci/ANOVATWOFACTORWITHOUTREPLICATION | ANOVATWOFACTORWITHOUTREPLICATION]]
−
|+ Anova: Single Factor<br />SUMMARY
+
*[[Manuals/calci/ANOVATWOFACTORWITHREPLICATION | ANOVATWOFACTORWITHREPLICATION]]
−
|- class="even"
 
−
! Groups
 
−
! Count
 
−
! Sum
 
−
! Average
 
−
! Variance
 
−
|- class="odd"
 
−
| Column1
 
−
| 4
 
−
| 37
 
−
| 9.25
 
−
| 46.916666666666664
 
−
|- class="even"
 
−
| Column2
 
−
| 4
 
−
| 34
 
−
| 8.5
 
−
| 44.333333333333336
 
−
|}
 
−
 
 
−
{| id="TABLE5" class="SpreadSheet blue"
 
−
|+ <br />ANOVA
 
−
|- class="even"
 
−
! Source of Variation
 
−
! Sum of Squares
 
−
! Degree of Freedom
 
−
! Mean of Squares
 
−
! F
 
−
! Probability
 
−
! F Critical
 
−
|- class="odd"
 
−
| Between Groups:
 
−
| 1.125
 
−
| 1
 
−
| 1.125
 
−
| 0.024657534246575342
 
−
| 0.8886077621608085
 
−
| 5.98702940083107
 
−
|- class="even"
 
−
| Within Groups:
 
−
| 273.75
 
−
| 6
 
−
| 45.625
 
−
|- class="odd"
 
−
| Total:
 
−
| 274.875
 
−
| 7
 
−
|}
 
−
 
 
−
</div>
 
−
----
 
−
<div id="14SpaceContent" class="zcontent" align="left">
 
−
 
 
−
Lets see an example in (Column3 , Row1)
 
−
 
 
−
<nowiki>=ANOVASINGLEFACTOR(R1C1:R4:C2, 0.05, "columns", TRUE) </nowiki>
 
−
 
 
−
ANOVASINGLEFACTOR returns the result in new sheet(15Space).
 
  
−
<nowiki>=ANOVASINGLEFACTOR(R1C1:R4C2 , 0.05, "rows", TRUE)</nowiki>
+
== References ==
  
−
It returns the results in new sheet(16Space).
+
*[http://en.wikipedia.org/wiki/One-way_analysis_of_variance ANOVA Single Factor]
−
 
 
−
<nowiki>=ANOVASINGLEFACTOR(R1C1:R4C2 , -0.05, "rows", FALSE)</nowiki>
 
−
 
 
−
It returns the #ERROR(Alpha &gt;1 or Alpha&lt;0)
 
−
 
 
−
</div>
 
−
----
 

Revision as of 20:31, 5 January 2014

ANOVASINGLEFACTOR(Array, Alpha, GroupBy, NewTableFlag)

  • where, is an array of numbers or reference to cells containing array
  • represents a constant value between '0' and '1'
  • is a method to perform the analysis by columns or rows
  • that decides to display the output in the same worksheet or a new space cube.

ANOVASINGLEFACTOR() performs a simple analysis of variances between two data sets.

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.5,"COLUMNS",TRUE) displays results in a new space.
Anova: Single Factor
SUMMARY
Groups Count Sum Average Variance
ColumnA 4 37 9.25 46.916666666666664
ColumnB 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

See Also

References

Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/ANOVASINGLEFACTOR&oldid=197002"