Difference between revisions of "ANOVASINGLEFACTOR"
Jump to navigation
Jump to search
| (21 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | <div style="font-size:25px">'''ANOVASINGLEFACTOR(Array, Alpha, GroupBy, NewTableFlag)'''</div | + | <div style="font-size:25px">'''ANOVASINGLEFACTOR(Array, Alpha, GroupBy, NewTableFlag)'''</div> |
| − | *<math>Array</math> is an array of numbers or reference to cells containing array | + | *'''<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>Alpha</math> represents a constant value between '0' and '1' |
| − | *<math>GroupBy</math> is a method to perform the analysis by columns or rows | + | *'''<math>GroupBy</math> is a method to perform the analysis by columns or rows |
| − | *<math>NewTableFlag</math> decides if the output is to be displayed in the same worksheet or a new space cube.<br></br> | + | *'''<math>NewTableFlag</math> decides if the output is to be displayed in the same worksheet or a new space cube.<br></br> |
==='''DESCRIPTION'''=== | ==='''DESCRIPTION'''=== | ||
| − | * ANOVASINGLEFACTOR() performs a simple analysis of variances between two data sets. | + | * '''ANOVASINGLEFACTOR() performs a simple analysis of variances between two data sets. |
| − | * Analysis Of Variances (ANOVA) is a method of checking relationship between two or more data sets. | + | * '''Analysis Of Variances (ANOVA) is a method of checking relationship between two or more data sets. |
| − | * | + | * '''Alpha should be in between '0' and '1'. Else, Calci displays #N/A error message.''' |
| − | * Analysis can be done by columns or rows. The choice should be entered in quotes (e.g. "COLUMNS" or "ROWS"). | + | * '''Analysis can be done by columns or rows. The choice should be entered in quotes (e.g. '''''"COLUMNS"''''' or '''''"ROWS"'''''). |
| − | * | + | * '''NewTableFlag can be a logical value '''''TRUE''''' or '''''FALSE'''''. If omitted, Calci assumes it to be FALSE. |
| − | * If | + | * '''If NewTableFlag is TRUE, the result is displayed on new zspace sheet.'''<br></br> |
==='''EXAMPLE'''=== | ==='''EXAMPLE'''=== | ||
| Line 37: | Line 37: | ||
| 31 || 31 || 26 || 20 || 14 || 9 | | 31 || 31 || 26 || 20 || 14 || 9 | ||
|} | |} | ||
| − | '''=ANOVASINGLEFACTOR( | + | '''= ANOVASINGLEFACTOR(A1:F6, 0.95, "ROWS", true)''' |
Latest revision as of 14:01, 12 August 2020
ANOVASINGLEFACTOR(Array, Alpha, GroupBy, NewTableFlag)
- is an array of numbers or reference to cells containing array
- represents a constant value between '0' and '1'
- is a method to perform the analysis by columns or rows
- decides if the output is to be displayed in the same worksheet or a new space cube.
is an array of numbers or reference to cells containing array
represents a constant value between '0' and '1'
is a method to perform the analysis by columns or rows
decides if the output is to be displayed in the same worksheet or a new space cube.DESCRIPTION
- ANOVASINGLEFACTOR() performs a simple analysis of variances between two data sets.
- Analysis Of Variances (ANOVA) is a method of checking relationship between two or more data sets.
- Alpha should be in between '0' and '1'. Else, Calci displays #N/A error message.
- Analysis can be done by columns or rows. The choice should be entered in quotes (e.g. "COLUMNS" or "ROWS").
- NewTableFlag can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE.
- If NewTableFlag is TRUE, the result is displayed on new zspace sheet.
EXAMPLE
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | 19 | 18 | 25 | 20 | 17 | 21 |
| 2 | 8 | 10 | 10 | 18 | 7 | 16 |
| 3 | 21 | 31 | 26 | 28 | 14 | 24 |
| 4 | 15 | 26 | 17 | 14 | 17 | 13 |
| 5 | 23 | 32 | 26 | 16 | 27 | 18 |
| 6 | 31 | 31 | 26 | 20 | 14 | 9 |
= ANOVASINGLEFACTOR(A1:F6, 0.95, "ROWS", true)
| GROUPS | COUNT | SUM | AVERAGE | VARIANCE |
|---|---|---|---|---|
| ROW1 | 6 | 120 | 20 | 8 |
| VARIANCE | 6 | 69 | 11.5 | 19.9 |
| ROW3 | 6 | 144 | 24 | 35.6 |
| ROW4 | 6 | 102 | 17 | 22 |
| ROW5 | 6 | 142 | 23.666666666666668 | 35.46666666666667 |
| ROW6 | 6 | 131 | 21.833333333333332 | 82.96666666666665 |
| SOURCE OF VARIATION | SUM OF SQUARES | DEGREE OF FREEDOM | MEAN OF SQUARES | F | PROBABILITY | F CRITICAL |
|---|---|---|---|---|---|---|
| BETWEEN GROUPS: | 680.3333333333331 | 5 | 136.06666666666663 | 4.003269042170643 | 0.006690023031923189 | 0.22244315626178107 |
| WITHIN GROUPS: | 1019.6666666666666 | 30 | 33.98888888888889 | |||
| TOTAL: | 1699.9999999999998 | 35 |
EXCEL RESULTS
COMPARISON WITH OTHER SOFTWARE
Conduct ANOVA for the data in the range B2:C16.
SOLUTION
In z3:
In R:
In Excel:
