Difference between revisions of "Manuals/calci/ANOVASINGLEFACTOR"

 
(8 intermediate revisions by 3 users not shown)
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> that decides to display the output 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 ==
 +
 
ANOVASINGLEFACTOR(Array, Alpha, GroupBy, NewTableFlag)
 
ANOVASINGLEFACTOR(Array, Alpha, GroupBy, NewTableFlag)
  
Line 50: 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 63: Line 63:
 
! Variance
 
! Variance
 
|- class="odd"
 
|- class="odd"
| ColumnA
+
| RowA
 
| 4
 
| 4
 
| 37
 
| 37
Line 69: Line 69:
 
| 46.916666666666664
 
| 46.916666666666664
 
|- class="even"
 
|- class="even"
| ColumnB
+
| RowB
 
| 4
 
| 4
 
| 34
 
| 34
Line 104: Line 104:
 
| 7
 
| 7
 
|}
 
|}
 +
 +
==Related Videos==
 +
 +
{{#ev:youtube|EFdlFoHI_0I|280|center|ANOVASINGLEFACTOR}}
  
 
== See Also ==
 
== See Also ==
Line 113: 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 ]]

Latest revision as of 15:33, 17 August 2018

ANOVASINGLEFACTOR (Array,Alpha,GroupBy,NewTableFlag)


  • where, 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.
    • ANOVASINGLEFACTOR(), performs a simple analysis of variances between two data sets.This should be used when you have one indepenedent variable.


Description

ANOVASINGLEFACTOR(Array, Alpha, GroupBy, 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.
  • Analysis can be done by columns or rows. The choice should be entered in quotes (e.g. "COLUMNS" or "ROWS").
  •   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 ANOVASINGLEFACTOR() function.

1 3
7 8
12 5
17 18
=ANOVASINGLEFACTOR(A1:B4,0.05,"ROWS",TRUE) displays results in a new space.
Anova: Single Factor
SUMMARY
Groups Count Sum Average Variance
RowA 4 37 9.25 46.916666666666664
RowB 4 34 8.5 44.333333333333336

ANOVA
Source of Variation Sum of Squares Degree of Freedom Mean of Squares F Probability F Critical
Between Groups: 1.125 1 1.125 0.024657534246575342 0.8886077621608085 5.987702296337573
Within Groups: 273.75 6 45.625
Total: 274.875 7

Related Videos

ANOVASINGLEFACTOR

See Also

References