Difference between revisions of "Manuals/calci/ANOVATWOFACTORWITHREPLICATION"

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> --...")
 
 
(3 intermediate revisions by 2 users not shown)
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>
+
<div style="font-size:30px">'''ANOVATWOFACTORWITHREPLICATION (Array,Alpha,NumberofSamplesPerRow,NewTableFlag) '''</div><br/>
−
----
 
−
<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.
 +
**ANOVATWOFACTORWITHREPLICATION(), performs an analysis of variances between more more data sets.This should be used when you have more than one sample from each data set.
  
−
It returns the #ERROR, when length of Array != length of NumberofSample.
+
== Description ==
  
−
</div>
+
ANOVATWOFACTORWITHREPLICATION(Array, Alpha, NumberOfSamples, NewTableFlag)
−
----
 
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
  
−
ANOVA : TWO - FACTOR WITH REPLICATION
+
*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.
 +
*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.
 +
*If <math>NewTableFlag</math> is TRUE, the result is displayed on new zspace sheet.
  
−
</div></div>
+
== Examples ==
−
----
 
−
<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>'''ANOVATWOFACTORWITHREPLICATION'''(Array, NumberofSample, Alpha, NewTableFlag)
+
Consider the following table with Columns A and B as array inputs for ANOVATWOFACTORWITHREPLICATION() function.
  
−
where,
 
−
 
−
'''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 108:
 
| 152
 
| 152
 
| 12.666666666666666
 
| 12.666666666666666
−
| 369.69696969696974
+
| 369.69696969696975
 
|- class="even"
 
|- class="even"
 
| Array2
 
| Array2
Line 182: Line 132:
 
| 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 142:
 
| 1.0883720930232565
 
| 1.0883720930232565
 
| 0.36437615127626016
 
| 0.36437615127626016
−
| 9.332898584189282
+
| 9.330229140735954
 
|- class="odd"
 
|- class="odd"
 
| Interaction:
 
| Interaction:
Line 200: Line 150:
 
| 1.6872987477638656
 
| 1.6872987477638656
 
| 0.2120282015971952
 
| 0.2120282015971952
−
| 5.061984369714618
+
| 5.0650509516310676
 
|- class="even"
 
|- class="even"
 
| Within:
 
| Within:
Line 208: Line 158:
 
|- class="odd"
 
|- class="odd"
 
| Total:
 
| Total:
−
| 8283.833333333335
+
| 8283.833333333336
 
| 23
 
| 23
 
|}
 
|}
  
−
</div>
+
==Related Videos==
−
----
+
 
 +
{{#ev:youtube|j9ZPMlVHJVs|280|center|ANOVA}}
 +
 
 +
== 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]
 +
 
 +
 
 +
 
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 
 +
*[[ Z3 |  Z3 home ]]

Latest revision as of 16:56, 17 August 2018

ANOVATWOFACTORWITHREPLICATION (Array,Alpha,NumberofSamplesPerRow,NewTableFlag)


  • where, is an array of numbers or reference to cells containing array
  • represents a constant value between '0' and '1'
  • represents the number of samples in an array
  • that decides to display the output in the same worksheet or a new space cube.
    • ANOVATWOFACTORWITHREPLICATION(), performs an analysis of variances between more more data sets.This should be used when you have more than one sample from each data set.

Description

ANOVATWOFACTORWITHREPLICATION(Array, Alpha, NumberOfSamples, 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.
  • Data in an array can be divided in one or more groups. That is represented by .
  • 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 ANOVATWOFACTORWITHREPLICATION() 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 


=ANOVATWOFACTORWITHREPLICATION(A1:B12, 0.01, 2, TRUE) returns the result in new Zspace cube.
Anova: Two-Factor With Replication
SUMMARY
Groups Count Sum Average Variance
Array1 12 152 12.666666666666666 369.69696969696975
Array2 12 230 19.166666666666668 360.3333333333333

ANOVA
Source of Variation Sum of Squares Degree of Freedom Mean Square F-Value Probability F Critical
Sample: 3270.333333333334 5 654.0666666666668 2.8081574239713785 0.06629115945265437 5.064312767657053
Columns: 253.50000000000017 1 253.50000000000017 1.0883720930232565 0.36437615127626016 9.330229140735954
Interaction: 1965.0000000000018 5 393.00000000000034 1.6872987477638656 0.2120282015971952 5.0650509516310676
Within: 2795 12 232.91666666666666
Total: 8283.833333333336 23

Related Videos

ANOVA

See Also

References


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