Difference between revisions of "Manuals/calci/ANOVATWOFACTORWITHOUTREPLICATION"

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.</div> --...")
 
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>
+
=ANOVATWOFACTORWITHOUTREPLICATION(Array, Alpha, NewTableFlag)=
−
----
 
−
<div id="1SpaceContent" class="zcontent" align="left">ANOVA:TwoFactor without replication performs an analysis of variances between two or more data sets. And used when we only have one sample from each data set.</div>
 
−
----
 
−
<div id="7SpaceContent" class="zcontent" align="left">
 
  
−
ANOVATWOFACTORWITHOUTREPLICATION  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>NewTableFlag</math> that decides to display the output in the same worksheet or a new space cube.
  
−
</div>
+
ANOVATWOFACTORWITHOUTREPLICATION() performs an analysis of variances between two or more data sets.
−
----
 
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
  
−
ANOVA : TWO - FACTOR WITHOUT REPLICATION
+
== Description ==
  
−
</div></div>
+
ANOVATWOFACTORWITHOUTREPLICATION(Array, Alpha, NewTableFlag)
−
----
 
−
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">what is ANOVA?</div><div class="ZEditBox"><center></center></div></div>
 
−
----
 
−
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
 
−
----
 
−
<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>'''ANOVATWOFACTORWITHOUTREPLICATION'''(Array, Alpha, NewTableFlag)
+
*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.
 +
*<math>NewTableFlag</math> can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE.
 +
*If <math>NewTableFlag</math> is TRUE, the result is displayed on new zspace sheet.
  
−
where,
+
== Examples ==
  
−
'''Array '''- Input range should be one or two blocks.
+
Consider the following table with Columns A and B as array inputs for ANOVATWOFACTORWITHOUTREPLICATION() function.
  
−
'''Alpha '''- is the constant in between 0 and 1.
 
−
 
−
'''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>=ANOVATWOFACTORWITHOUTREPLICATION(R1C1:R12C2, 0.01, TRUE) </nowiki>
 
−
 
−
ANOVATWOFACTORWITHREPLICATION  returns the result in new sheet(8Space).
 
−
 
−
<nowiki>=ANOVATWOFACTORWITHOUTREPLICATION(R1C1:R12C2, -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" | 8Space
+
 
−
| 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" |
 
 
|- 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" |
+
 
−
| 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=" " |
−
|
+
 
−
|
 
 
|- 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>
+
 
−
----
+
=ANOVATWOFACTORWITHOUTREPLICATION(A1:B12, 0.01, TRUE) returns the result in new Zspace cube.
 +
 
 
<div id="8SpaceContent" class="zcontent" align="left">
 
<div id="8SpaceContent" class="zcontent" align="left">
  
Line 226: Line 179:
 
| 152
 
| 152
 
| 12.666666666666666
 
| 12.666666666666666
−
| 369.69696969696974
+
| 369.69696969696975
 
|- class="even"
 
|- class="even"
 
| Column2
 
| Column2
Line 252: Line 205:
 
| 1.6419915556286661
 
| 1.6419915556286661
 
| 0.21186926809792436
 
| 0.21186926809792436
−
| 4.460024010499913
+
| 4.463512627383915
 
|- class="even"
 
|- class="even"
 
| Columns:
 
| Columns:
Line 260: Line 213:
 
| 0.9174206283928278
 
| 0.9174206283928278
 
| 0.4028687266699078
 
| 0.4028687266699078
−
| 9.64473915180063
+
| 9.6447311508211713
 
|- class="odd"
 
|- class="odd"
 
| Error:
 
| Error:
Line 268: Line 221:
 
|- class="even"
 
|- class="even"
 
| Total:
 
| Total:
−
| 8283.833333333335
+
| 8283.833333333336
 
| 23
 
| 23
 
|}
 
|}
  
−
</div>
+
== See Also ==
−
----
+
 
 +
*[[Manuals/calci/ANOVATWOFACTORWITHREPLICATION | ANOVATWOFACTORWITHREPLICATION]]
 +
*[[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]

Revision as of 16:42, 6 January 2014

ANOVATWOFACTORWITHOUTREPLICATION(Array, Alpha, NewTableFlag)

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

ANOVATWOFACTORWITHOUTREPLICATION() performs an analysis of variances between two or more data sets.

Description

ANOVATWOFACTORWITHOUTREPLICATION(Array, Alpha, 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.
  • 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 ANOVATWOFACTORWITHOUTREPLICATION() function.

1 3
2 5
6 41
8 45
9 56
10 8
7 8
12 5
17 18
72 31
6 3
2 7 


=ANOVATWOFACTORWITHOUTREPLICATION(A1:B12, 0.01, TRUE) returns the result in new Zspace cube.
Anova: Two-Factor Without Replication
SUMMARY
Count Sum Average Variance
Row1 2 4 2 2
Row2 2 7 3.5 4.5
Row3 2 47 23.5 612.5
Row4 2 53 26.5 684.5
Row5 2 65 32.5 1104.5
Row6 2 18 9 2
Row7 2 15 7.5 0.5
Row8 2 17 8.5 24.5
Row9 2 35 17.5 0.5
Row10 2 103 51.5 840.5
Row11 2 9 4.5 4.5
Row12 2 9 4.5 12.5
Column1 12 152 12.666666666666666 369.69696969696975
Column2 12 230 19.166666666666668 360.3333333333333

ANOVA
Source of Variation Sum of Squares Degree of Freedom Mean of Squares F Probability F Critical
Rows: 4990.833333333334 11 453.71212121212124 1.6419915556286661 0.21186926809792436 4.463512627383915
Columns: 253.50000000000017 1 253.50000000000017 0.9174206283928278 0.4028687266699078 9.6447311508211713
Error: 3039.500000000002 11 276.318181818182
Total: 8283.833333333336 23

See Also

References

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