Changes

5,532 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: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 <0 or Alpha >1.

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

ANOVA : TWO - FACTOR WITHOUT 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>'''ANOVATWOFACTORWITHOUTREPLICATION'''(Array, Alpha, NewTableFlag)

where,

'''Array '''- Input range should be one or two blocks.

'''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 >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" | 8Space
| 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" |
|- 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" |
| class=" " | 20
|- class="even"
| class="sshl_f" | Row10
| class=" " | 72
| class=" " | 31
| 23
| 40
|- class="odd"
| class="sshl_f" | Row11
| class=" " | 6
| class=" " | 3
|
|
|- 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">

{| class="SpreadSheet blue"
|+ Anova: Two-Factor Without Replication<br />SUMMARY
|- class="even"
!
! Count
! Sum
! Average
! Variance
|- class="odd"
| Row1
| 2
| 4
| 2
| 2
|- class="even"
| Row2
| 2
| 7
| 3.5
| 4.5
|- class="odd"
| Row3
| 2
| 47
| 23.5
| 612.5
|- class="even"
| Row4
| 2
| 53
| 26.5
| 684.5
|- class="odd"
| Row5
| 2
| 65
| 32.5
| 1104.5
|- class="even"
| Row6
| 2
| 18
| 9
| 2
|- class="odd"
| Row7
| 2
| 15
| 7.5
| 0.5
|- class="even"
| Row8
| 2
| 17
| 8.5
| 24.5
|- class="odd"
| Row9
| 2
| 35
| 17.5
| 0.5
|- class="even"
| Row10
| 2
| 103
| 51.5
| 840.5
|- class="odd"
| Row11
| 2
| 9
| 4.5
| 4.5
|- class="even"
| Row12
| 2
| 9
| 4.5
| 12.5
|- class="odd"
| Column1
| 12
| 152
| 12.666666666666666
| 369.69696969696974
|- class="even"
| Column2
| 12
| 230
| 19.166666666666668
| 360.3333333333333
|}

{| class="SpreadSheet blue"
|+ <br />ANOVA
|- class="even"
! Source of Variation
! Sum of Squares
! Degree of Freedom
! Mean of Squares
! F
! Probability
! F Critical
|- class="odd"
| Rows:
| 4990.833333333334
| 11
| 453.71212121212124
| 1.6419915556286661
| 0.21186926809792436
| 4.460024010499913
|- class="even"
| Columns:
| 253.50000000000017
| 1
| 253.50000000000017
| 0.9174206283928278
| 0.4028687266699078
| 9.64473915180063
|- class="odd"
| Error:
| 3039.500000000002
| 11
| 276.318181818182
|- class="even"
| Total:
| 8283.833333333335
| 23
|}

</div>
----

MassBot1

Bots, writer

193,448

edits

Changes

Manuals/calci/ANOVATWOFACTORWITHOUTREPLICATION (view source)

Revision as of 02:29, 25 October 2013

Navigation menu

Search