ZCubes Wiki

Difference between revisions of "ANOVASINGLEFACTOR"
 
(30 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
<div style="font-size:25px">'''ANOVASINGLEFACTOR(Array, Alpha, GroupBy, NewTableFlag)'''</div><br/>
+
<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>
+
*'''<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.
−
* <math>Alpha</math> should be in between '0' and '1'. Else Calci displays #N/A error message.
+
* '''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"''''').
−
* <math>NewTableFlag</math> can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE.
+
* '''NewTableFlag 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.
+
* '''If NewTableFlag is TRUE, the result is displayed on new zspace sheet.'''<br></br>
  
−
==Example==
+
==='''EXAMPLE'''===
 
{| class="wikitable"
 
{| class="wikitable"
 
|+Spreadsheet
 
|+Spreadsheet
Line 37: Line 37:
 
| 31 || 31 || 26 || 20 || 14 || 9
 
| 31 || 31 || 26 || 20 || 14 || 9
 
|}
 
|}
−
=ANOVASINGLEFACTOR(A6:F6,0.95,"ROWS",true)
+
'''= ANOVASINGLEFACTOR(A1:F6, 0.95, "ROWS", true)'''
 +
 
  
 
{| class="wikitable"
 
{| class="wikitable"
Line 44: Line 45:
 
|+SUMMARY
 
|+SUMMARY
 
|-
 
|-
−
! !!GROUPS!!COUNT!! AVERAGE!!VARIANCE
+
! GROUPS!!COUNT!! SUM !! AVERAGE!!VARIANCE
 
|-
 
|-
 
|ROW1||6 || 120 || 20 || 8
 
|ROW1||6 || 120 || 20 || 8
Line 58: Line 59:
 
|ROW6 || 6 || 131 || 21.833333333333332 || 82.96666666666665
 
|ROW6 || 6 || 131 || 21.833333333333332 || 82.96666666666665
 
|}
 
|}
 +
  
 
{| class="wikitable"
 
{| class="wikitable"
 
|+ANOVA
 
|+ANOVA
 
|-
 
|-
−
! !!SOURCE OF VARIATION!!SUM OF SQUARES!! DEGREE OF FREEDOM!!MEAN OF SQUARES !! F !! PROBABILITY !! F CRITICAL
+
! 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
 
|BETWEEN GROUPS: || 680.3333333333331 || 5 || 136.06666666666663 || 4.003269042170643 || 0.006690023031923189 || 0.22244315626178107
Line 70: Line 72:
 
|TOTAL: || 1699.9999999999998 || 35
 
|TOTAL: || 1699.9999999999998 || 35
 
|}
 
|}
 +
<br></br>
 +
 +
==='''EXCEL RESULTS'''===
 +
[[File:Anova.JPG]]
 +
 +
 +
==='''COMPARISON WITH OTHER SOFTWARE'''===
 +
Conduct ANOVA for the data in the range B2:C16.<br><br>
 +
[[File:Anova1.JPG]]<br><br>
 +
 +
'''SOLUTION'''<br>
 +
'''In z3:'''<br>
 +
[[File:Anovaz.JPG]]<br><br>
 +
 +
'''In R:'''<br>
 +
[[File:Anovar.JPG]]<br><br>
 +
 +
'''In Excel:'''<br>
 +
[[File:Anoex.JPG]]<br><br>

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.

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

Spreadsheet
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)


ANOVA: SINGLE FACTOR SUMMARY
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


ANOVA
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:
 

Retrieved from "http://wiki.zcubes.com/index.php?title=ANOVASINGLEFACTOR&oldid=214903"