Changes

Jump to navigation Jump to search
no edit summary
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 ]]
writer
6,694

edits

Navigation menu