Difference between revisions of "Manuals/calci/ANOVATWOFACTORWITHOUTREPLICATION"
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> --...") |
|||
(4 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | <div | + | <div style="font-size:30px">'''ANOVATWOFACTORWITHOUTREPLICATION (Array,Alpha,NewTableFlag) '''</div><br/> |
− | |||
− | |||
− | |||
− | |||
− | + | *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. | ||
+ | **ANOVATWOFACTORWITHOUTREPLICATION(), performs an analysis of variances between two or more data sets.This should be used when you only have one sample from each data set. | ||
− | + | == Description == | |
− | |||
− | |||
− | + | 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. | |
− | < | ||
− | |||
− | < | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | + | == Examples == | |
− | + | Consider the following table with Columns A and B as array inputs for ANOVATWOFACTORWITHOUTREPLICATION() function. | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
<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="odd" | |- class="odd" | ||
− | | class=" " | | + | | class="sshl_f" | 2 |
− | | class=" " | | + | | class=" " |5 |
− | + | | class=" " | | |
− | | class=" | + | |
− | |||
|- class="even" | |- class="even" | ||
− | | class="sshl_f" | | + | | class="sshl_f" | 6 |
− | | class=" " | | + | | class=" " |41 |
− | | class=" " | | + | | class=" " | |
− | + | ||
− | |||
|- class="odd" | |- class="odd" | ||
− | | class="sshl_f" | | + | | class="sshl_f" | 8 |
− | | class=" " | | + | | class=" " |45 |
− | | class=" " | | + | | class=" " | |
− | + | ||
− | |||
− | |||
|- class="even" | |- class="even" | ||
− | | class="sshl_f" | | + | | class="sshl_f" | 9 |
− | | class=" " | | + | | class=" " |56 |
− | | class=" " | | + | | class=" " | |
− | + | ||
− | |||
|- class="odd" | |- class="odd" | ||
− | | class="sshl_f" | | + | | class="sshl_f" | 10 |
− | | class=" " | | + | | class=" " |8 |
− | | class=" " | | + | | class=" " | |
− | + | ||
− | |||
|- class="even" | |- class="even" | ||
− | | class="sshl_f" | | + | | class="sshl_f" | 7 |
− | + | | class=" " |8 | |
− | | class=" " | 8 | + | | class=" " | |
− | | class=" | + | |
− | |||
|- class="odd" | |- class="odd" | ||
− | | class="sshl_f" | | + | | class="sshl_f" | 12 |
− | | class=" " | | + | | class=" " |5 |
− | | class=" " | | + | | class=" " | |
− | + | ||
− | |||
|- class="even" | |- class="even" | ||
− | | class="sshl_f" | | + | | class="sshl_f" | 17 |
− | | class=" " | | + | | class=" " |18 |
− | | class=" " | | + | | class=" " | |
− | + | ||
− | |||
|- class="odd" | |- class="odd" | ||
− | | class="sshl_f" | | + | | class="sshl_f" | 72 |
− | | class=" " | | + | | class=" " |31 |
− | | class=" " | | + | | class=" " | |
− | + | ||
− | |||
|- class="even" | |- class="even" | ||
− | | class="sshl_f" | | + | | class="sshl_f" | 6 |
− | | class=" " | | + | | class=" " |3 |
− | | class=" " | | + | | class=" " | |
− | + | ||
− | |||
|- class="odd" | |- class="odd" | ||
− | | class="sshl_f" | | + | | class="sshl_f" | 2 |
− | | class=" " | | + | | class=" " |7 |
− | | class=" " | | + | | class=" " | |
− | + | ||
− | |||
|- class="even" | |- class="even" | ||
− | | class="sshl_f" | | + | | class="sshl_f" | |
− | | class=" " | | + | | class=" " | |
− | | class=" | + | | class=" " | |
− | |||
− | |||
|} | |} | ||
− | + | ||
− | + | =ANOVATWOFACTORWITHOUTREPLICATION(A1:B12, 0.01, TRUE) returns the result in new Zspace cube. | |
+ | |||
<div id="8SpaceContent" class="zcontent" align="left"> | <div id="8SpaceContent" class="zcontent" align="left"> | ||
Line 226: | Line 178: | ||
| 152 | | 152 | ||
| 12.666666666666666 | | 12.666666666666666 | ||
− | | 369. | + | | 369.69696969696975 |
|- class="even" | |- class="even" | ||
| Column2 | | Column2 | ||
Line 252: | Line 204: | ||
| 1.6419915556286661 | | 1.6419915556286661 | ||
| 0.21186926809792436 | | 0.21186926809792436 | ||
− | | 4. | + | | 4.463512627383915 |
|- class="even" | |- class="even" | ||
| Columns: | | Columns: | ||
Line 260: | Line 212: | ||
| 0.9174206283928278 | | 0.9174206283928278 | ||
| 0.4028687266699078 | | 0.4028687266699078 | ||
− | | 9. | + | | 9.6447311508211713 |
|- class="odd" | |- class="odd" | ||
| Error: | | Error: | ||
Line 268: | Line 220: | ||
|- class="even" | |- class="even" | ||
| Total: | | Total: | ||
− | | 8283. | + | | 8283.833333333336 |
| 23 | | 23 | ||
|} | |} | ||
− | + | ==Related Videos== | |
− | + | ||
+ | {{#ev:youtube|j9ZPMlVHJVs|280|center|ANOVA}} | ||
+ | |||
+ | == 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] | ||
+ | |||
+ | |||
+ | |||
+ | *[[Z_API_Functions | List of Main Z Functions]] | ||
+ | |||
+ | *[[ Z3 | Z3 home ]] |
Latest revision as of 15:54, 17 August 2018
ANOVATWOFACTORWITHOUTREPLICATION (Array,Alpha,NewTableFlag)
- where, is an array of numbers or reference to cells containing array
- represents a constant value between '0' and '1'
- ANOVATWOFACTORWITHOUTREPLICATION(), performs an analysis of variances between two or more data sets.This should be used when you only have one sample from each data set.
that decides to display the output in the same worksheet or a new space cube.
Description
ANOVATWOFACTORWITHOUTREPLICATION(Array, Alpha, 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.
- 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 ANOVATWOFACTORWITHOUTREPLICATION() 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 | |
=ANOVATWOFACTORWITHOUTREPLICATION(A1:B12, 0.01, TRUE) returns the result in new Zspace cube.
Count | Sum | Average | Variance | |
---|---|---|---|---|
Row1 | 2 | 4 | 2 | 2 |
Row2 | 2 | 7 | 3.5 | 4.5 |
Row3 | 2 | 47 | 23.5 | 612.5 |
Row4 | 2 | 53 | 26.5 | 684.5 |
Row5 | 2 | 65 | 32.5 | 1104.5 |
Row6 | 2 | 18 | 9 | 2 |
Row7 | 2 | 15 | 7.5 | 0.5 |
Row8 | 2 | 17 | 8.5 | 24.5 |
Row9 | 2 | 35 | 17.5 | 0.5 |
Row10 | 2 | 103 | 51.5 | 840.5 |
Row11 | 2 | 9 | 4.5 | 4.5 |
Row12 | 2 | 9 | 4.5 | 12.5 |
Column1 | 12 | 152 | 12.666666666666666 | 369.69696969696975 |
Column2 | 12 | 230 | 19.166666666666668 | 360.3333333333333 |
Source of Variation | Sum of Squares | Degree of Freedom | Mean of Squares | F | Probability | F Critical |
---|---|---|---|---|---|---|
Rows: | 4990.833333333334 | 11 | 453.71212121212124 | 1.6419915556286661 | 0.21186926809792436 | 4.463512627383915 |
Columns: | 253.50000000000017 | 1 | 253.50000000000017 | 0.9174206283928278 | 0.4028687266699078 | 9.6447311508211713 |
Error: | 3039.500000000002 | 11 | 276.318181818182 | |||
Total: | 8283.833333333336 | 23 |
Related Videos
See Also
References