Changes

Manuals/calci/ANOVATWOFACTORWITHOUTREPLICATION (view source)

Revision as of 21:42, 6 January 2014

1,668 bytes removed , 21:42, 6 January 2014

no edit summary

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

−

~~</div>~~

−

~~----~~

{| id="TABLE3" class="SpreadSheet blue"

|- class="even"

+

| class="sshl_f" | 1

+

| class=" " |3

| class=" " |

−

~~| class=" " | Column1~~

+

−

~~| class=" " | Column2~~

−

~~| class=" " | Column3~~

−

~~| Column4~~

|- 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="sshl_f" | ~~Row2~~

+

| class="sshl_f" | 6

−

| class=" " | 2

+

| class=" " |41

−

| class=" " | 5

+

| class=" " |

−

~~| class="sshl_f " |~~

+

−

~~| class="sshl_f" | #ERROR~~

|- 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="sshl_f" | ~~Row4~~

+

| class="sshl_f" | 9

−

| class=" " | 8

+

| class=" " |56

−

| class=" " | 45

+

| class=" " |

−

~~| class="sshl_f" |~~

+

−

~~| class="sshl_f" |~~

|- 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="sshl_f" | ~~Row6~~

+

| class="sshl_f" | 7

−

~~| class=" " | 10~~

+

| class=" " |8

−

| class=" " | 8

+

| class=" " |

−

| class="~~sshl_f~~" |

+

−

~~| class="sshl_f" |~~

|- class="odd"

−

| class="sshl_f" | ~~Row7~~

+

| class="sshl_f" | 12

−

| class=" " | 7

+

| class=" " |5

−

| class=" " | 8

+

| class=" " |

−

~~| 9~~

+

−

~~| class="sshl_f" |~~

|- 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="sshl_f" | ~~Row9~~

+

| class="sshl_f" | 72

−

| class=" " | 17

+

| class=" " |31

−

| class=" " | 18

+

| class=" " |

−

~~| class="sshl_f" |~~

+

−

~~| class=" " | 20~~

|- class="even"

−

| class="sshl_f" | ~~Row10~~

+

| class="sshl_f" | 6

−

| class=" " | 72

+

| class=" " |3

−

| class=" " | 31

+

| class=" " |

−

~~| 23~~

+

−

~~| 40~~

|- class="odd"

−

| class="sshl_f" | ~~Row11~~

+

| class="sshl_f" | 2

−

| class=" " | 6

+

| class=" " |7

−

| class=" " | 3

+

| class=" " |

−

|

+

−

|

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

+

Line 226: Line 179:

| 152

| 12.666666666666666

−

| 369.~~69696969696974~~

+

| 369.69696969696975

|- class="even"

| Column2

Line 252: Line 205:

| 1.6419915556286661

| 0.21186926809792436

−

| 4.~~460024010499913~~

+

| 4.463512627383915

|- class="even"

| Columns:

Line 260: Line 213:

| 0.9174206283928278

| 0.4028687266699078

−

| 9.~~64473915180063~~

+

| 9.6447311508211713

|- class="odd"

| Error:

Line 268: Line 221:

|- class="even"

| Total:

−

| 8283.~~833333333335~~

+

| 8283.833333333336

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

Swapna

writer

2,661

edits

Changes

Manuals/calci/ANOVATWOFACTORWITHOUTREPLICATION (view source)

Revision as of 21:42, 6 January 2014

Navigation menu

Search