Mean price per acre for vineyard land ANOVA ...
guru2009
MeanpriceperacreforvineyardlandANOVA.xlsxSheet1
| 1996 | 1997 | 1998 | ||||||||||
| 30000 | 30000 | 40000 | ||||||||||
| 34000 | 35000 | 41000 | ||||||||||
| 36000 | 37000 | 43000 | ||||||||||
| 38000 | 38000 | 44000 | ||||||||||
| 40000 | 40000 | 50000 | ||||||||||
| Hypotheses: | ||||||||||||
| Ho: There is no significant difference between the prices in the three years | ||||||||||||
| Ha: There is a significant difference in the prices in at least two years out of three | ||||||||||||
| Test: One factor ANOVA with α = 0.05 | ||||||||||||
| Rejection rule: Reject Ho if the p- value < 0.05 | ||||||||||||
| One factor ANOVA | ||||||||||||
| Mean | n | Std. Dev | ||||||||||
| 38400.0 | 35,600.0 | 5 | 3,847.08 | 1996 | ||||||||
| 38400.0 | 36,000.0 | 5 | 3,807.89 | 1997 | ||||||||
| 38400.0 | 43,600.0 | 5 | 3,911.52 | 1998 | ||||||||
| 38,400.0 | 15 | 5,220.84 | Total | |||||||||
| ANOVA table | ||||||||||||
| Source | SS | df | MS | F | p-value | |||||||
| Treatment | 203,200,000.00 | 2 | 101,600,000.000 | 6.83 | .0104 | |||||||
| Error | 178,400,000.00 | 12 | 14,866,666.667 | |||||||||
| Total | 381,600,000.00 | 14 | ||||||||||
| Post hoc analysis | ||||||||||||
| p-values for pairwise t-tests | ||||||||||||
| 1996 | 1997 | 1998 | ||||||||||
| 35,600.0 | 36,000.0 | 43,600.0 | ||||||||||
| 1996 | 35,600.0 | |||||||||||
| 1997 | 36,000.0 | .8724 | ||||||||||
| 1998 | 43,600.0 | .0066 | .0089 | |||||||||
| Decision: Since 0.0104 < 0.05, reject Ho | ||||||||||||
| Conclusion: There is a significant difference in the prices in at least two years out of three. Furher, we can conclude that the differene is significant for the year pairs 1996-1998 and 1997-1998 since these p- values are < 0.05. |
Output
| One factor ANOVA | |||||
| Mean | n | Std. Dev | |||
| 38400.0 | 35,600.0 | 5 | 3,847.08 | 1996 | |
| 38400.0 | 36,000.0 | 5 | 3,807.89 | 1997 | |
| 38400.0 | 43,600.0 | 5 | 3,911.52 | 1998 | |
| 38,400.0 | 15 | 5,220.84 | Total | ||
| ANOVA table | |||||
| Source | SS | df | MS | F | p-value |
| Treatment | 203,200,000.00 | 2 | 101,600,000.000 | 6.83 | .0104 |
| Error | 178,400,000.00 | 12 | 14,866,666.667 | ||
| Total | 381,600,000.00 | 14 | |||
| Post hoc analysis | |||||
| p-values for pairwise t-tests | |||||
| 1996 | 1997 | 1998 | |||
| 35,600.0 | 36,000.0 | 43,600.0 | |||
| 1996 | 35,600.0 | ||||
| 1997 | 36,000.0 | .8724 | |||
| 1998 | 43,600.0 | .0066 | .0089 | ||
| Tukey simultaneous comparison t-values (d.f. = 12) | |||||
| 1996 | 1997 | 1998 | |||
| 35,600.0 | 36,000.0 | 43,600.0 | |||
| 1996 | 35,600.0 | ||||
| 1997 | 36,000.0 | 0.16 | |||
| 1998 | 43,600.0 | 3.28 | 3.12 | ||
| critical values for experimentwise error rate: | |||||
| 0.05 | 2.67 | ||||
| 0.01 | 3.56 | ||||
Comparison of Groups
1996 1997 1998 30000 30000 40000 34000 35000 41000 36000 37000 43000 38000 38000 44000 40000 40000 50000 35600 36000 43600 38400 38400 38400
