Changes

5,320 bytes added , 02:29, 25 October 2013

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

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

MassBot1

Bots, writer

193,448

edits

Changes

Manuals/calci/ANOVATWOFACTORWITHREPLICATION (view source)

Revision as of 02:29, 25 October 2013

Navigation menu

Search