| Line 1: |
Line 1: |
| − | =ANOVASINGLEFACTOR(Array, Alpha, GroupBy, NewTableFlag)= | + | <div style="font-size:30px">'''ANOVASINGLEFACTOR (Array,Alpha,GroupBy,NewTableFlag)'''</div><br/> |
| − | | |
| | *where, <math>Array</math> is an array of numbers or reference to cells containing array | | *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>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. | | *<math>NewTableFlag</math> decides if the output is to be displayed in the same worksheet or a new space cube. |
| | + | **ANOVASINGLEFACTOR(), performs a simple analysis of variances between two data sets.This should be used when you have one indepenedent variable. |
| | | | |
| − | ANOVASINGLEFACTOR() performs a simple analysis of variances between two data sets.
| |
| | | | |
| | == Description == | | == Description == |
| Line 51: |
Line 50: |
| | |} | | |} |
| | | | |
| − | =ANOVASINGLEFACTOR(A1:B4,0.5,"COLUMNS",TRUE) displays results in a new space. | + | =ANOVASINGLEFACTOR(A1:B4,0.05,"ROWS",TRUE) displays results in a new space. |
| − | ----
| + | |
| | <div id="8SpaceContent" class="zcontent" align="left"> | | <div id="8SpaceContent" class="zcontent" align="left"> |
| | | | |
| Line 64: |
Line 63: |
| | ! Variance | | ! Variance |
| | |- class="odd" | | |- class="odd" |
| − | | ColumnA | + | | RowA |
| | | 4 | | | 4 |
| | | 37 | | | 37 |
| Line 70: |
Line 69: |
| | | 46.916666666666664 | | | 46.916666666666664 |
| | |- class="even" | | |- class="even" |
| − | | ColumnB | + | | RowB |
| | | 4 | | | 4 |
| | | 34 | | | 34 |
| Line 105: |
Line 104: |
| | | 7 | | | 7 |
| | |} | | |} |
| | + | |
| | + | ==Related Videos== |
| | + | |
| | + | {{#ev:youtube|EFdlFoHI_0I|280|center|ANOVASINGLEFACTOR}} |
| | | | |
| | == See Also == | | == See Also == |
| Line 114: |
Line 117: |
| | | | |
| | *[http://en.wikipedia.org/wiki/One-way_analysis_of_variance ANOVA Single Factor] | | *[http://en.wikipedia.org/wiki/One-way_analysis_of_variance ANOVA Single Factor] |
| | + | |
| | + | |
| | + | |
| | + | *[[Z_API_Functions | List of Main Z Functions]] |
| | + | |
| | + | *[[ Z3 | Z3 home ]] |