Agriculture Reference
In-Depth Information
Solution. Let us make the following table:
2
2
Variety
x
y
ð
x x
Þ
ð
y
y
Þ
ð
x x
Þ
ð
y y
Þ
ð
x
x
Þ y y
ð
Þ
1
16
55
7
9.44
49
89.2
66.11
7
59.11
2
16
54
8.44
49
71.31
3
22
48
1
2.44
1
5.98
2.44
4
23
47
0
1.44
0
2.09
0
5
24
45
1
0.56
1
0.31
0.56
6
24
40
1
5.56
1
30.86
5.56
1.56
3.11
7
25
44
2
4
2.42
8
28
37
5
8.56
25
73.2
42.78
9
29
40
6
5.56
36
30.86
33.33
Mean
23
45.56
Variance
18.44
34.02
23.67
Covariance
The regression equation of yield on the
nu
m-
ber
The above example can very well be worked
out using MS Excel software as follows:
of
insects
is
given
by
ðY YÞ¼
Cov
ðX:YÞ
s
b
yx
ðX XÞ)ðY
45
:
56
Þ¼
ðX
23
Þ¼
2
X
23
:
67
ðX
23
Þ¼
1
:
284
ðX
23
Þ¼
1
:
284
Xþ
18
:
44
:
) Y ¼
:
:
X:
29
532
75
092
1
284
Slide 8.25: Step 1 showing data entry and the selection of the proper Analysis menu using MS Excel
