Changes

Jump to navigation Jump to search

Manuals/calci/ANOVATWOFACTORWITHREPLICATION (view source)

Revision as of 22:31, 6 January 2014

1,615 bytes removed ,  22: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.</div>
+
=ANOVATWOFACTORWITHREPLICATION(Array, Alpha, NumberOfSamples, NewTableFlag)=
−
----
  −
<div id="1SpaceContent" class="zcontent" align="left">ANOVA :Two-Factor with replication performs an analysis of variances between two more data sets. And used when we have more than one sample from each data set.</div>
  −
----
  −
<div id="7SpaceContent" class="zcontent" align="left">
     −
ANOVATWOFACTORWITHREPLICATION  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>NumberOfSamples</math> represents the number of samples in an array 
 +
*<math>NewTableFlag</math> that decides to display the output in the same worksheet or a new space cube.
   −
It returns the #ERROR, when length of Array != length of NumberofSample.
+
ANOVATWOFACTORWITHREPLICATION() performs an analysis of variances between two or more data sets.
   −
</div>
+
== Description ==
−
----
  −
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
     −
ANOVA : TWO - FACTOR WITH REPLICATION
+
ANOVATWOFACTORWITHREPLICATION(Array, Alpha, NumberOfSamples, 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>
+
*Data in an array can be divided in one or more groups. That is represented by <math>NumberOfSamples</math>.
−
----
+
*<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>'''ANOVATWOFACTORWITHREPLICATION'''(Array, NumberofSample, Alpha, NewTableFlag)
+
== Examples ==
   −
where,
+
Consider the following table with Columns A and B as array inputs for ANOVATWOFACTORWITHREPLICATION() function.
   −
'''Array '''- Input range should be one or two blocks.
  −
  −
'''Alpha '''- is the constant in between 0 and 1.
  −
  −
'''NumberofSample''' - Input range should be one blocks.
  −
  −
'''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="14SpaceContent" class="zcontent" align="left">
  −
  −
Lets see an example in (Column3 , Row1)
  −
  −
<nowiki>=ANOVATWOFACTORWITHREPLICATION(R1C1:R12C2, 2, 0.01, TRUE) </nowiki>
  −
  −
ANOVATWOFACTORWITHREPLICATION  returns the result in new sheet(13Space).
  −
  −
<nowiki>=ANOVATWOFACTORWITHREPLICATION(R1C1:R12C2 , 2,-0.05, FALSE)</nowiki>
  −
  −
It returns the #ERROR(Alpha &gt;1 or Alpha&lt;0)
  −
  −
</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=" " |
−
| class="  " | Column1
+
 
−
| class="  " | Column2
  −
| class="  " | Column3
  −
| Column4
   
|- class="odd"
 
|- class="odd"
−
| class=" " | Row1
+
| class="sshl_f" | 2
−
| class=" " | 1
+
| class=" " |5
−
| class=" " | 3
+
| class=" " |
−
| class="sshl_f" | 13Space
+
 
−
| class="sshl_f" | 5
   
|- class="even"
 
|- class="even"
−
| class="sshl_f" | Row2
+
| class="sshl_f" | 6
−
| class=" " | 2
+
| class=" " |41
−
| class=" " | 5
+
| class=" " |
−
| class="sshl_f  " |
+
 
−
| class="sshl_f" | #ERROR
   
|- class="odd"
 
|- class="odd"
−
| class="sshl_f" | Row3
+
| class="sshl_f" | 8
−
| class=" " | 6
+
| class=" " |45
−
| class=" " | 41
+
| class=" " |
−
| class="sshl_f" |
+
 
−
| class="sshl_f SelectTD1 ChangeBGColor SelectTD1" |
  −
<div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]]  </div>
   
|- class="even"
 
|- class="even"
−
| class="sshl_f" | Row4
+
| class="sshl_f" | 9
−
| class=" " | 8
+
| class=" " |56
−
| class=" " | 45
+
| class=" " |
−
| class="sshl_f" |
+
 
−
| class="sshl_f" |
   
|- class="odd"
 
|- class="odd"
−
| class="sshl_f" | Row5
+
| class="sshl_f" | 10
−
| class=" " | 9
+
| class=" " |8
−
| class=" " | 56
+
| class=" " |
−
| class="sshl_f" |
+
 
−
| class="sshl_f" |
   
|- class="even"
 
|- class="even"
−
| class="sshl_f" | Row6
+
| class="sshl_f" | 7
−
| class=" " | 10
+
| class=" " |8
−
| class=" " | 8
+
| class=" " |
−
| class="sshl_f" |
+
 
−
| class="sshl_f" |
   
|- class="odd"
 
|- class="odd"
−
| class="sshl_f" | Row7
+
| class="sshl_f" | 12
−
| class=" " | 7
+
| class=" " |5
−
| class=" " | 8
+
| class=" " |
−
| 9
+
 
−
| class="sshl_f" | 128
   
|- class="even"
 
|- class="even"
−
| class="sshl_f" | Row8
+
| class="sshl_f" | 17
−
| class=" " | 12
+
| class=" " |18
−
| class=" " | 5
+
| class=" " |
−
| 14
+
 
−
| class="sshl_f    " | 15
   
|- class="odd"
 
|- class="odd"
−
| class="sshl_f" | Row9
+
| class="sshl_f" | 72
−
| class=" " | 17
+
| class=" " |31
−
| class=" " | 18
+
| class=" " |
−
| class="sshl_f" | 10000
+
 
−
| class="  " | 20
   
|- class="even"
 
|- class="even"
−
| class="sshl_f" | Row10
+
| class="sshl_f" | 6
−
| class=" " | 72
+
| class=" " |3
−
| class=" " | 31
+
| class=" " |
−
| 23
+
 
−
| 40
   
|- class="odd"
 
|- class="odd"
−
| class="sshl_f" | Row11
+
| class="sshl_f" | 2
−
| class=" " | 6
+
| class=" " |7
−
| class=" " | 3
+
| class=" " |
−
| 1.619775
+
 
−
| 0.525322
   
|- class="even"
 
|- class="even"
−
| class="sshl_f" | Row12
+
| class="sshl_f" |  
−
| class=" " | 2
+
| class=" " |
−
| class=" " | 7
+
| class=" " |
−
| class="sshl_f" |
  −
| class="sshl_f" |
   
|}
 
|}
   −
<div align="left">[[Image:calci1.gif]]</div></div>
+
 
−
----
+
=ANOVATWOFACTORWITHREPLICATION(A1:B12, 0.01, 2, TRUE) returns the result in new Zspace cube.
 +
 
 
<div id="8SpaceContent" class="zcontent" align="left">
 
<div id="8SpaceContent" class="zcontent" align="left">
   Line 158: Line 109:  
| 152
 
| 152
 
| 12.666666666666666
 
| 12.666666666666666
−
| 369.69696969696974
+
| 369.69696969696975
 
|- class="even"
 
|- class="even"
 
| Array2
 
| Array2
Line 182: Line 133:  
| 5
 
| 5
 
| 654.0666666666668
 
| 654.0666666666668
−
| 2.8081574239713784
+
| 2.8081574239713785
 
| 0.06629115945265437
 
| 0.06629115945265437
−
| 5.061984369714618
+
| 5.064312767657053
 
|- class="even"
 
|- class="even"
 
| Columns:
 
| Columns:
Line 192: Line 143:  
| 1.0883720930232565
 
| 1.0883720930232565
 
| 0.36437615127626016
 
| 0.36437615127626016
−
| 9.332898584189282
+
| 9.330229140735954
 
|- class="odd"
 
|- class="odd"
 
| Interaction:
 
| Interaction:
Line 200: Line 151:  
| 1.6872987477638656
 
| 1.6872987477638656
 
| 0.2120282015971952
 
| 0.2120282015971952
−
| 5.061984369714618
+
| 5.0650509516310676
 
|- class="even"
 
|- class="even"
 
| Within:
 
| Within:
Line 208: Line 159:  
|- class="odd"
 
|- class="odd"
 
| Total:
 
| Total:
−
| 8283.833333333335
+
| 8283.833333333336
 
| 23
 
| 23
 
|}
 
|}
   −
</div>
+
== See Also ==
−
----
+
 
 +
*[[Manuals/calci/ANOVATWOFACTORWITHOUTREPLICATION | ANOVATWOFACTORWITHOUTREPLICATION]]
 +
*[[Manuals/calci/ANOVASINGLEFACTOR | ANOVASINGLEFACTOR]]
 +
 
 +
== References ==
 +
 
 +
*[http://en.wikipedia.org/wiki/Analysis_of_variance ANOVA]
 +
*[http://en.wikipedia.org/wiki/Analysis_of_variance#ANOVA_for_multiple_factors Anova Multiple Factors]
Swapna
writer
2,661

edits

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

Navigation menu