Unistat Statistics Software | Quade Two-Way ANOVA in Excel

Quade Two-Way ANOVA in Excel with UNISTAT

The UNISTAT statistics add-in extends Excel with Quade Two-Way ANOVA capabilities.

For further information visit UNISTAT User's Guide section 6.5.5. Quade Two-Way ANOVA.

Here we provide a sample output from the UNISTAT Excel statistics add-in for data analysis.

Quade Two-Way ANOVA

	Cases	Rank Sum	Mean Rank
Treatment 1	8	11.0000	1.3750
Treatment 2	8	16.0000	2.0000
Treatment 3	8	23.5000	2.9375
Treatment 4	8	29.5000	3.6875
Total	32	80.0000	2.5000

Number of Columns	4
Number of Rows	8

F(3,21)	6.8351
Right-Tail Probability	0.0022

Multiple Comparisons with t Distribution

Method: 95% t interval.
** denotes significantly different pairs. Vertical bars show homogeneous subsets.
A pairwise test result is significant if its q stat value is greater than the table q.

Group	Cases	Rank Sum	Treatment 1	Treatment 2	Treatment 3	Treatment 4
Treatment 1	8	-42.5000			**	**	\|
Treatment 2	8	-12.5000				**	\|\|
Treatment 3	8	11.0000	**				\|\|
Treatment 4	8	44.0000	**	**			\|

Comparison	Difference	Standard Error	q Stat	Table q	Probability	Lower 95%	Upper 95%	Result
Treatment 4 - Treatment 1	86.5000	19.8002	4.3686	2.0796	0.0003	45.3232	127.6768	**
Treatment 3 - Treatment 1	53.5000	19.8002	2.7020	2.0796	0.0134	12.3232	94.6768	**
Treatment 2 - Treatment 1	30.0000	19.8002	1.5151	2.0796	0.1446	-11.1768	71.1768
Treatment 4 - Treatment 2	56.5000	19.8002	2.8535	2.0796	0.0095	15.3232	97.6768	**
Treatment 3 - Treatment 2	23.5000	19.8002	1.1869	2.0796	0.2485	-17.6768	64.6768
Treatment 4 - Treatment 3	33.0000	19.8002	1.6667	2.0796	0.1104	-8.1768	74.1768

Homogeneous Subsets:
Group 1: Treatment 1 Treatment 2
Group 2: Treatment 2 Treatment 3
Group 3: Treatment 3 Treatment 4