VLC Home
  IM Home
   
-  Data Analysis Using MS EXCEL
- Exercises On Analysis Of Variance (Anova)
- Descriptive Statistics
- Regression Analysis
- t-Test
   
+ MS EXCEL Case Study
   
 
Self Test
Ask a Question
Download PDF File


Exercises On Analysis Of Variance (Anova)

Single Factor: Completely Randomized Design (CRD)
Ranomized Block Design

Single Factor: Completely Randomized Design (CRD):

The simplest of all Designs having a random arrangement is the "Completely Randomized Design" . It assumes the complete homogeneity of the experimental material.

Examples: Laboratory studies, Green house and Pot culture experiments, animal feeding experiments, Soil moisture and related studies etc.

Exercise: The percentage moisture content is determined for ten samples for each of four different soils. Calculate the analysis of variance to obtain an estimate of the sampling variation within a soil and hence calculate the standard error of the mean moisture content of a soil and the standard error of a difference between two such means. Test the hypothesis that there is no variation of soil moisture content between different soils and summarize briefly the conclusions to be drawn from this data

(Table value of t for 36 df at 5% level of significance = 2.034, 1% level of significance = 3.599.)

Soil A
Soil  B
Soil  C
Soil  D
12.8
8.1
9.8
16.4
13.4
10.3
10.6
8.2
11.2
4.2
9.1
15.1
11.6
7.8
4.3
10.4
9.4
5.6
11.2
7.8
10.3
8.1
11.6
9.2
14.1
12.7
8.3
12.6
11.9
6.8
8.9
11.00
10.5
6.9
9.2
8.0
10.4
6.4
6.4
9.8

Hints:

a) Analysis of Variance
- Enter the data from A1 cell to D11 Cell (The first row contains headings on Soil types)
- Click left mouse button on Tools > Data Analysis > Anova Single Factor > click on OK
- Type in the input range box A1:D11 & Click in the Lables in First Row Box

The Dialog Box Looks like as follows:

- Click on OK button

To see the contents of the first column clearly

-Select Column A by clicking > Format >Column >Autofit selection

The hypotheses that "there is no variation of soil moisture content between different soils" can be tested by comparing F-Value with F-Critical Value

Standard error of mean = Ös /r = s /10

The estimate of standard error of a difference = Ö2s /r = Ö2s /10

Coefficient of Variation % = (standard deviation(s) /mean)*100 CD(55%) = (t (.05) at 36 df ) (SEd)

Randomized Block design

The following data represent the yield of soyabean plants for five treatments grown in six randomized complete blocks. The experiment was conducted in the greenhouse. The five treatments are 20,40,60,80,100 ppm of nitrogen.

Yield of soybean in grams per plot

Replications

Treatment R1 R2 R3 R4 R5 R6
T1 8.8 12.9 11.7 31.2 22.0 9.9
T2 23.5 26.5 21.6 15.6 24.4 23.3
T3 41.2 22.5 21.8 46.3 15.6 22.6
T4 28.4 48.4 16.4 44.5 38.8 43.6
T5 67.4 33.2 59.5 49.8 57.1 36.6

Analyze the data and summarize the results.

Hints

- Enter data from A1 cell to G6 cell
- Click on Tools > Data Analysis > Anova Two
-Factor without replication >Ok
- Click in lables Box
- OK