Manuals/calci/ANOVATWOFACTORWITHREPLICATION

ANOVATWOFACTORWITHREPLICATION (Array,Alpha,NumberofSamplesPerRow,NewTableFlag)

where, Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array} is an array of numbers or reference to cells containing array
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Alpha} represents a constant value between '0' and '1'
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NumberOfSamples} represents the number of samples in an array
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NewTableFlag} that decides to display the output in the same worksheet or a new space cube.
- ANOVATWOFACTORWITHREPLICATION(), performs an analysis of variances between more more data sets.This should be used when you have more than one sample from each data set.

Description

ANOVATWOFACTORWITHREPLICATION(Array, Alpha, NumberOfSamples, NewTableFlag)

Analysis Of Variances(ANOVA) is a method of checking relationship between two or more data sets.
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Alpha} should be in between '0' and '1'. Else Calci displays #N/A error message.
Data in an array can be divided in one or more groups. That is represented by Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NumberOfSamples} .
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NewTableFlag} can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE.
If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NewTableFlag} is TRUE, the result is displayed on new zspace sheet.

Consider the following table with Columns A and B as array inputs for ANOVATWOFACTORWITHREPLICATION() function.

=ANOVATWOFACTORWITHREPLICATION(A1:B12, 0.01, 2, TRUE) returns the result in new Zspace cube.

Anova: Two-Factor With Replication
SUMMARY
Groups	Count	Sum	Average	Variance
Array1	12	152	12.666666666666666	369.69696969696975
Array2	12	230	19.166666666666668	360.3333333333333

ANOVA
Source of Variation	Sum of Squares	Degree of Freedom	Mean Square	F-Value	Probability	F Critical
Sample:	3270.333333333334	5	654.0666666666668	2.8081574239713785	0.06629115945265437	5.064312767657053
Columns:	253.50000000000017	1	253.50000000000017	1.0883720930232565	0.36437615127626016	9.330229140735954
Interaction:	1965.0000000000018	5	393.00000000000034	1.6872987477638656	0.2120282015971952	5.0650509516310676
Within:	2795	12	232.91666666666666
Total:	8283.833333333336	23