Changes

Jump to navigation Jump to search

Manuals/calci/ANOVASINGLEFACTOR (view source)

Revision as of 02:31, 6 January 2014

1,931 bytes removed ,  02:31, 6 January 2014
no edit summary
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>
  −
----
 
Swapna
writer
2,661

edits

Retrieved from "http://wiki.zcubes.com/Special:MobileDiff/197002"

Navigation menu