Devika at 21:56, 17 August 2018

2018-08-17T21:56:02Z

Jayaram at 13:02, 14 March 2017

2017-03-14T13:02:17Z

Swapna at 18:23, 28 April 2015

2015-04-28T18:23:17Z

Swapna at 22:31, 6 January 2014

2014-01-06T22:31:02Z

Show changes

MassBot1: Created page with "
Analysis Of Variances(ANOVA) is a method of checking if there is a relationship between two ror more data sets.
--..."

2013-10-25T02:29:42Z

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> --..."

New page

<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 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 <0 or Alpha >1.

It returns the #ERROR, when length of Array != length of NumberofSample.

</div>
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">

ANOVA : TWO - FACTOR WITH REPLICATION

</div></div>
----
<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)

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 >1 or Alpha<0)

</div>
----
<div id="2SpaceContent" class="zcontent" align="left">

{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
| class=" " |
| class=" " | Column1
| class=" " | Column2
| class=" " | Column3
| Column4
|- class="odd"
| class=" " | Row1
| class=" " | 1
| class=" " | 3
| class="sshl_f" | 13Space
| class="sshl_f" | 5
|- class="even"
| class="sshl_f" | Row2
| class=" " | 2
| class=" " | 5
| class="sshl_f " |
| class="sshl_f" | #ERROR
|- class="odd"
| class="sshl_f" | Row3
| class=" " | 6
| class=" " | 41
| 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="sshl_f" | Row4
| class=" " | 8
| class=" " | 45
| class="sshl_f" |
| class="sshl_f" |
|- class="odd"
| class="sshl_f" | Row5
| class=" " | 9
| class=" " | 56
| class="sshl_f" |
| class="sshl_f" |
|- class="even"
| class="sshl_f" | Row6
| class=" " | 10
| class=" " | 8
| class="sshl_f" |
| class="sshl_f" |
|- class="odd"
| class="sshl_f" | Row7
| class=" " | 7
| class=" " | 8
| 9
| class="sshl_f" | 128
|- class="even"
| class="sshl_f" | Row8
| class=" " | 12
| class=" " | 5
| 14
| class="sshl_f " | 15
|- class="odd"
| class="sshl_f" | Row9
| class=" " | 17
| class=" " | 18
| class="sshl_f" | 10000
| class=" " | 20
|- class="even"
| class="sshl_f" | Row10
| class=" " | 72
| class=" " | 31
| 23
| 40
|- class="odd"
| class="sshl_f" | Row11
| class=" " | 6
| class=" " | 3
| 1.619775
| 0.525322
|- class="even"
| class="sshl_f" | Row12
| class=" " | 2
| class=" " | 7
| class="sshl_f" |
| class="sshl_f" |
|}

<div align="left">[[Image:calci1.gif]]</div></div>
----
<div id="8SpaceContent" class="zcontent" align="left">

{| id="TABLE1" class="SpreadSheet blue"
|+ Anova: Two-Factor With Replication<br />SUMMARY
|- class="even"
! Groups
! Count
! Sum
! Average
! Variance
|- class="odd"
| Array1
| 12
| 152
| 12.666666666666666
| 369.69696969696974
|- class="even"
| Array2
| 12
| 230
| 19.166666666666668
| 360.3333333333333
|}

{| id="TABLE2" class="SpreadSheet blue"
|+ <br />ANOVA
|- class="even"
! Source of Variation
! Sum of Squares
! Degree of Freedom
! Mean Square
! F-Value
! Probability
! F Critical
|- class="odd"
| Sample:
| 3270.333333333334
| 5
| 654.0666666666668
| 2.8081574239713784
| 0.06629115945265437
| 5.061984369714618
|- class="even"
| Columns:
| 253.50000000000017
| 1
| 253.50000000000017
| 1.0883720930232565
| 0.36437615127626016
| 9.332898584189282
|- class="odd"
| Interaction:
| 1965.0000000000018
| 5
| 393.00000000000034
| 1.6872987477638656
| 0.2120282015971952
| 5.061984369714618
|- class="even"
| Within:
| 2795
| 12
| 232.91666666666666
|- class="odd"
| Total:
| 8283.833333333335
| 23
|}

</div>
----

@@ Line 1: / Line 1: @@
-=ANOVATWOFACTORWITHREPLICATION(Array, Alpha, NumberOfSamples, NewTableFlag)=
+<div style="font-size:30px">'''ANOVATWOFACTORWITHREPLICATION (Array,Alpha,NumberofSamplesPerRow,NewTableFlag) '''</div><br/>
 *where, <math>Array</math> is an array of numbers or reference to cells containing array
@@ Line 5: / Line 5: @@
 *<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.
 == Description ==

← Older revision		Revision as of 13:02, 14 March 2017
Line 176:		Line 176:
	*[http://en.wikipedia.org/wiki/Analysis_of_variance ANOVA]		*[http://en.wikipedia.org/wiki/Analysis_of_variance ANOVA]
	*[http://en.wikipedia.org/wiki/Analysis_of_variance#ANOVA_for_multiple_factors Anova Multiple Factors]		*[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 ]]

@@ Line 162: / Line 162: @@
 | 23
 |}
 == See Also ==

Manuals/calci/ANOVATWOFACTORWITHREPLICATION - Revision history

Devika at 21:56, 17 August 2018

Jayaram at 13:02, 14 March 2017

Swapna at 18:23, 28 April 2015

Swapna at 22:31, 6 January 2014

MassBot1: Created page with "Analysis Of Variances(ANOVA) is a method of checking if there is a relationship between two ror more data sets. --..."

MassBot1: Created page with "
Analysis Of Variances(ANOVA) is a method of checking if there is a relationship between two ror more data sets.
--..."