Fertilizer and Irrigation Impact Analysis
Fertilizer and Irrigation Impact Analysis
Regression Statistics
Multiple R 0.900144
R Square 0.81026
Adjusted R Square 0.715389
Standard Error 1.944777
Observations 10
ANOVA
df SS MS F Significance F
Regression 3 96.90705171 32.30235 8.540719 0.013836
Residual 6 22.69294829 3.782158
Total 9 119.6
1
0 Land Area in timads Residual
-1100 110 4 120 130 140 150 160 170 180 190
-2 2 Plot
Fertilizer Line Fit Plot
Residuals
-3 0 4
-2450 500 55080 600
2 Fertilizer 650 700 750
Irrigation water in literes Line
Residuals
-4 0 60
Crop Yield
-2 2.4 Irrigation
2.6
40 water2.8
in literes3 3.2 Fit 3.4
Plot
Crop Yield
3.6
-4 20 100
Land Area in timads
Predicted Crop Yield Line Fit
Crop Yield
80 Predicted Crop Yield
450 500 50 550 600 650 700 750
60
Irrigation0water in literes
Crop Yield
40
2.4 2.6 2.8 3 3.2 3.4 3.6
20
Land Area in timads
0
0 10 20 30 40 50 60 70 80 90 100
Sample Percentile
s Line
ds Line Fit
Yield
t
icted Crop Yield
Crop Yield
Predicted Crop Yield
3.6
60 70 80 90 100
entile
SUMMARY OUTPUT
Residuals
Adjusted R 0.377289 1
Standard E 2.084355 0
-1100 110 120
Observatio 9 -2
-3
ANOVA
df SS MS F Significance F
Regression 4 60.49955 15.12489 4.641813 0.083113
Residual 5 21.72267 4.344535
Total 9 82.22222
Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%
Upper 95.0%
Intercept 29.92457 8.976212 3.333763 0.020693 6.850478 52.99865 6.850478 52.99865
120 0.11946 0.037144 3.216146 0.023567 0.023979 0.214941 0.023979 0.214941
500 -0.016262 0.014598 -1.113997 0.315945 -0.053786 0.021263 -0.053786 0.021263
2.5 6.058236 2.838822 2.134067 0.08596 -1.239188 13.35566 -1.239188 13.35566
0.625 0 0 65535 #NUM! 0 0 0 0
Observation
Predicted 50Residuals Percentile 50
1 56.26126 -1.261264 5.555556 52
2 53.4735 -1.473501 16.66667 53
3 59.04903 0.950973 27.77778 54
4 58.85881 -0.858813 38.88889 55
5 58.84068 2.159323 50 56
6 58.16802 -2.168022 61.11111 58
7 53.78169 -0.781687 72.22222 59
8 57.75891 1.24109 83.33333 60
9 51.8081 2.191902 94.44444 61
120 Residual Plot
3
2 500 Residual Plot
Residuals
1
3
0
2
-1100 110 120 130 140 150 160 170 180 190
2.5 Residual Plot
Residuals
1
-2 3
-3
0
-1500
2
550 600 650 700
0.625 Residual Plot
750
Residuals
1 120
-2 3
-3
0
-1 2.4
2
2.6 2.8 3 3.2 3.4
120 Line Fit 3.6
Plot
1 500
Residuals
-2 65
-3
0
-1 0.6 60
0.65 0.7 0.75 0.8
500 Line
0.85
Fit 0.9
Plot
-2 55 2.5 65 Column G
2.5 Line Fit Plot
50
-3 Predicted 50
50 60
45 55 0.625 65 Column G
0.625 Line Fit50Plot
50
45 50055 Colum
65
50
2.4 2.650 2.8 360 3.2 3.4 3.6 Predict
45 2.5 55
50
0.6 0.6550 0.7 0.75 0.8 0.85 0.9
45 0.625
0 10 20 30 40 50 60 7
Sample Percentile
Plot
Column G
Line Fit50Plot
Predicted
Column G
ormal Probability Plot
Predicted 50
Column G
3.4 3.6 Predicted 50
Regression Statistics
Multiple R 0.900144
R Square 0.81026
Adjusted R Square 0.715389
Standard Error 1.944777
Observations 10
ANOVA
df SS MS F Significance F
Regression 3 96.90705 32.30235 8.540719 0.013836
Residual 6 22.69295 3.782158
Total 9 119.6
Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%
Upper 95.0%
Intercept 27.45758 6.813174 4.030073 0.00688 10.78635 44.12882 10.78635 44.12882
X Variable 1 0.124872 0.032968 3.787696 0.009098 0.044203 0.205542 0.044203 0.205542
X Variable 2 -0.016464 0.013614 -1.209302 0.272031 -0.049777 0.016849 -0.049777 0.016849
X Variable 3 6.62035 2.405008 2.752735 0.033171 0.735508 12.50519 0.735508 12.50519
1
3
0
2 X Variable 3 Residual Plot
-1100 110 120 130 140 150 160 170 180 190
Residuals
1
-2 3
-3
0
-1450
2
500 550
Residuals 600
X Variable 1 Line750Fit Plot
650 700
1X Variable 1
-2 80
-3
0
-1 2.4 60
2.6 2.8 3
X Variable 23.4Line3.6Fit Plot
3.2
-2 X
40 Variable 2
80 Y
X Variable 3 Line Fit Plot
Predicted Y
Y
-3 20 60
0 X Variable 380
40 Y
Y
100 110 120
20 130 140 60
Normal Probability Plot
150 160 170 180 190 Predicted Y
Upper 95.0% 0 X Variable
40 1 80 Y
Predicted Y
Y
450 50020 550 600
60 650 700 750
0 X Variable
40 2
Y
2.4 2.620 2.8 3 3.2 3.4 3.6
0 X Variable 3
0 10 20 30 40 50 60 70 80 90
Sample Percentile
lot
e Fit Plot
Y
Probability Plot
Predicted Y
Y
Predicted Y
3.4 3.6
0 40 50 60 70 80 90 100
Sample Percentile
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.900144227151197
R Square 0.810259629673626
Adjusted R Square 0.715389444510439
Standard Error 1.94477712052197
Observations 10
ANOVA
df SS MS F Significance F
Regression 3 96.9070517089657 32.30235 8.540719 0.01383552657875
Residual 6 22.6929482910343 3.782158
Total 9 119.6
Residuals
2.306004135 1
0 Land Area in timads Residual
-1100 110 4 120 130 140 150 160 170 180 190
15.71121 -2 2 Plot
Fertilizer Line Fit Plot
Residuals
-3 0 4
-2450 500 55080 600
2 Fertilizer 650 700 750
Irrigation water in lite
Residuals
11.74638 -4 0 60
3.2 Fit 3.4
Plot
Crop Yield
43.16879 -2 2.4 Irrigation
2.6
40 water2.8
in literes3 Crop Yield
3.6
-4 20 100
Land Area in tiC
Predicted
Crop Yield
100 120 50 140 160 180 200
100
Norm
Upper 95% Lower 95.0%
Upper 95.0% Fertilizer
0 80
Crop Yield
44.12881934 10.78635 44.12882 450 500 50 550 600 650
60 700 750
Crop Yield
0.205542039 0.044203 0.205542 Irrigation0water in40
literes
0.016849119 -0.049777 0.016849 2.4 2.6202.8 3 3.2
12.50519198 0.735508 12.50519 Land 0Area in timad
0 10 2
3.787696
es
ds Residual
er Line Fit Plot
700 750
tion water in literes Line
3.2 Fit 3.4
Plot
Crop Yield
3.6
Land Area in timads
Predicted Crop Yield Line Fit
timads PlotCrop Yield
60 180 200
100
Normal Probability
Predicted Crop Yield Plot
r 80 Crop Yield
00 50
550 600 650 Predicted Crop Yield
60 700 750
Crop Yield
ation0water in40
literes
2.4 2.6202.8 3 3.2 3.4 3.6
Land 0Area in timads
0 10 20 30 40 50 60 70 80 90 100
Sample Percentile
SUMMARY OUTPUT
Residuals
Adjusted R 0.715389 1
Standard E 1.944777 0
-1100 110 120
Observatio 10 -2
-3
ANOVA
df SS MS F Significance F
Regression 3 96.90705 32.30235 8.540719 0.013836
Residual 6 22.69295 3.782158
Total 9 119.6
Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 99.0%
Upper 99.0%
Intercept 27.45758 6.813174 4.030073 0.00688 10.78635 44.12882 2.198233 52.71693
Fertilizer 0.124872 0.032968 3.787696 0.009098 0.044203 0.205542 0.002646 0.247099
Irrigation w-0.016464 0.013614 -1.209302 0.272031 -0.049777 0.016849 -0.066938 0.03401
Land Area 6.62035 2.405008 2.752735 0.033171 0.735508 12.50519 -2.296043 15.53674
Observation
Predicted Crop Yield
Residuals Percentile Crop Yield
1 50.76129 -0.76129 5 50
2 56.17127 -1.171266 15 52
3 53.17293 -1.172933 25 53
4 59.1696 0.830401 35 54
5 59.08379 -1.083793 45 55
6 58.75452 2.245479 55 56
7 58.1504 -2.150399 65 58
8 53.42686 -0.426863 75 59
9 57.80369 1.196308 85 60
10 51.50564 2.494358 95 61
Fertilizer Residual Plot
3
2 Irrigation water in literes
Residual Plot
Residuals
1
0 Land Area in timads Residual
-1100 110 4 120 130 140 150 160 170 180 190
-2 2 Plot
Fertilizer Line Fit Plot
Residuals
-3 0 4
-2450 500 55080 600
2 Fertilizer 650 700 750
Irrigation water in literes Line
Residuals
-4 0 60
3.2 Fit 3.4
Plot
Crop Yield
-2 2.4 Irrigation
2.6
40 water2.8
in literes3 Crop Yield
3.6
-4 20 100
Land Area in timads
Predicted Crop Yield Line Fit
50
100 120 140 160 180 200
100
Normal Probability
Predicted Crop Yield Plot
Fertilizer
0 80 Crop Yield
Crop Yield
Crop Yield
Irrigation0water in40
literes
2.4 2.6202.8 3 3.2 3.4 3.6
Land 0Area in timads
0 10 20 30 40 50 60 70 80 90 100
Sample Percentile
e Fit
ility Plot
Yield
icted Crop Yield
60 70 80 90 100
centile
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.900144
R Square 0.81026
Adjusted R 0.715389
Standard E 1.944777
Observatio 10
ANOVA
df SS MS F Significance F
Regression 3 96.90705 32.30235 8.540719387022 0.013836
Residual 6 22.69295 3.782158
Total 9 119.6
Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 90.0%
Upper 90.0%
Intercept 27.45758 6.813174 4.030073 0.006879717463 10.78635 44.12882 14.21836 40.69681
X Variable 0.124872 0.032968 3.787696 0.009097901945 0.044203 0.205542 0.06081 0.188935
X Variable -0.016464 0.013614 -1.209302 0.272031060861 -0.049777 0.016849 -0.042919 0.009991
X Variable 6.62035 2.405008 2.752735 0.033171387559 0.735508 12.50519 1.946986 11.29371
1
3
0
2 X Variable 3 Residual Plot
-1100 110 120 130 140 150 160 170 180 190
Residuals
1
-2 3
-3
0
-1450
2
500 550
Residuals 600
X Variable 1 Line750Fit Plot
650 700
1X Variable 1
-2 80
-3
0
-1 2.4 60
2.6 2.8 3
X Variable 23.4Line3.6Fit Plot
3.2
-2 X
40 Variable 2
80 Y
X Variable 3 Line Fit Plot
Predicted Y
Y
-3 20 60
0 X Variable 380
40 Y
Y
100 110 120
20 130 140 60
Normal Probability Plot
150 160 170 180 190 Predicted Y
Upper 90.0% 0 X Variable
40 1 80 Y
Predicted Y
Y
450 50020 550 600
60 650 700 750
0 X Variable
40 2
Y
2.4 2.620 2.8 3 3.2 3.4 3.6
0 X Variable 3
0 10 20 30 40 50 60 70 80 90
Sample Percentile
lot
e Fit Plot
Y
Probability Plot
Predicted Y
Y
Predicted Y
3.4 3.6
0 40 50 60 70 80 90 100
Sample Percentile
FarmID cons Fertilizer
Irrigation water
Landin Area
literesin timads
Lnd in hac Crop Yield
1 1 120 500 2.5 0.625 50
2 1 150 600 3 0.75 55
3 1 130 550 2.8 0.7 52
4 1 170 650 3.2 0.8 60 120
5 1 160 700 3.5 0.875 58 500
6 1 180 550 2.7 0.675 61 2.5
7 1 150 520 3.1 0.775 56 0.625
8 1 140 530 2.6 0.65 53
9 1 130 510 3.4 0.85 59
10 1 110 580 3 0.75 54
211800
825300
Err:502 Err:502 Err:502 Err:502 4305
Err:502 Err:502 Err:502 Err:502 1076.25
Err:502 Err:502 Err:502 Err:502
Err:502 Err:502 Err:502 Err:502
120
500
2.5
X'X
150 130 170 160 180 150 140 130 110
600 550 650 700 550 520 530 510 580
3 2.8 3.2 3.5 2.7 3.1 2.6 3.4 3
0.75 0.7 0.8 0.875 0.675 0.775 0.65 0.85 0.75
1
SUMMARY OUTPUT
ANOVA
df SS MS F Significance F
Regression 4 96.90705170897 24.2267629272414 8.540719 0.018526
Residual 6 22.69294829103 3.78215804850572
Total 10 119.6
Residuals
-2 2.4 Irrigation
2.6 literes3
in80 3.2 3.4 3.6
-4
0
-1 0.6 60
0.65 0.7
Irrigation water in literes Line
0.75 0.8 0.85 0.9
Fit Plot
Crop Yield
-2 Land40Area in timads Crop Yield
-3 20 100
Land Area in timads Lin
Predicted Crop Yield
Upper 95.0% 0 Lnd in hac Plot Crop Yield
Crop Yield
44.12882 50
100 120 140 160 180 200
100
Lnd in hac Lin
Predicted Crop
0.205542 Fertilizer
0 80 Cr
Crop Yield
0.016849 450 500 50550 600 650
60 700 750
Pr Normal
Crop Yield
12.50519 Irrigation0water in40
literes 80
0 2.4 2.6202.8 3 3.2
60 3.4 3.6
Crop Yield
Land 0Area in timads
40
0.6 0.65 200.7 0.75 0.8 0.8
0Lnd in hac
0 10 20
ot
Fit Plot
ater
0.85
in literes
0.9
Line
Fit PlotCrop Yield
d Area in timads
Predicted Crop Yield Line Fit
PlotCrop Yield
00 Lnd inPredicted
hac Line Fit Plot
Crop Yield
80 Crop Yield
650
60 700 750 Normal Probability Plot
Predicted Crop Yield
in40
literes Crop Yield
80
2.6202.8 3 3.2 Predicted Crop Yield
60 3.4 3.6
Crop Yield
Regression Statistics
Multiple R 0.4650342944
R Square 0.216256895
Adjusted R Square -0.1505268493 1.265823
Standard Error 22.296121977
Observations 10
ANOVA
df SS MS F Significance F
Regression 3 960.1806 320.0602 0.965749 0.467764
Residual 7 3479.819 497.1171
Total 10 4440
20
0 60
-20450 40
500 55060 600 650 700 750
Irrigation water in literes Line
Residuals
-40 20
40
0
Fit Plot
Residuals
-20 2.4Irrigation
20 water2.8
2.6 in literes 3 3.2 3.4 3.6
-40 0 200
Land Area in timads Line Fit
-20 0.6 Land0.65
Area in 0.7
timads 0.75 Plot0.8 0.85 Fertilizer
0.9
Lnd in hac Line Fit Plot
Fertilizer
-40 100 Predicted Fertilizer
200
0 Lnd in hac200 Fertilizer
Fertilizer
100
450 500 550 600 150 650 700 750 Normal Probability Plot
Predicted Fertilizer
Fertilizer
Upper 95.0% Irrigation0 water in100
literes 200 Fertilizer
2.4 2.6 50 2.8 3 150 3.2 3.4 3.6 Predicted Fertilizer
Fertilizer
Land Area
0 in timads
100
0.6 0.65 50 0.7 0.75 0.8 0.85 0.9
Lnd
0 in hac
0 10 20 30 40 50 60 70 80 90
Sample Percentile
e Fit
Fit Plot
tilizer
Probability Plot
dicted Fertilizer
Fertilizer
Predicted Fertilizer
0.9
0 40 50 60 70 80 90 100
Sample Percentile
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.677192
R Square 0.458589
Adjusted R Square 0.161044
Standard Error 53.99175
Observations 10
ANOVA
df SS MS F Significance F
Regression 3 17284.24 5761.412 2.964595 0.119294
Residual 7 20405.76 2915.109
Total 10 37690
Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%
Upper 95.0%
Intercept 125.6933 183.087 0.686522 0.514474 -307.2387 558.6254 -307.2387 558.6254
Fertilizer 1.0302 0.828313 1.243733 0.253631 -0.928449 2.988849 -0.928449 2.988849
Land Area in timad 98.97916 55.30397 1.78973 0.116624 -31.79396 229.7523 -31.79396 229.7523
Lnd in hac 0 0 65535 #NUM! 0 0 0 0
Observation
Predicted Irrigation water
Residuals
in literes Percentile
Irrigation water in literes
1 496.7652 3.234794 5 500
2 577.1608 22.83922 15 510
3 536.761 13.23905 25 520
4 617.5606 32.43939 35 530
5 636.9524 63.04764 45 550
6 578.373 -28.37303 55 550
7 587.0587 -67.0587 65 580
8 527.2671 2.73288 75 600
9 596.1484 -86.14845 85 650
10 535.9528 44.04721 95 700
Fertilizer Residual Plot
100
50
Land Area in timads Residual
Plot
Residuals
0
100 110
Lnd in hac Residual Plot
100120 130 140 150 160 170 180 190
-50
50 100
Fertilizer Line Fit Plot
Residuals
-100 0 50
0.9
0 40 50 60 70 80 90 100
Sample Percentile
SUMMARY OUTPUT
Regression Statistics
Multiple R 1
R Square 1
Adjusted R Square 1
Standard Error 1.532E-17
Observations 10
ANOVA
df SS MS F Significance F
Regression 3 0.06225 0.02075 8.84E+31 2.533E-95
Residual 6 1.408E-33 2.347E-34
Total 9 0.06225
Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%
Upper 95.0%
Intercept -2.97E-17 5.367E-17 -0.552861 0.600334 -1.61E-16 1.017E-16 -1.61E-16 1.017E-16
Fertilizer 5.861E-20 2.597E-19 0.225678 0.828943 -5.77E-19 6.941E-19 -5.77E-19 6.941E-19
Land Area in timads 0.25 1.895E-17 1.32E+16 1.279E-95 0.25 0.25 0.25 0.25
Irrigation water in li -1.43E-19 1.073E-19 -1.333018 0.230907 -4.05E-19 1.195E-19 -4.05E-19 1.195E-19
-4E-17
-6E-17
-8E-17 0
Irrigation water in literes
-1E-16 2.4 2.6 Residual Plot
2.8 3 3.2 3.4 3.6
Fertilizer Line Fit Plot
Residuals
-4E-17
-1.2E-16
0
-8E-17 Fertilizer
450 1 500 550 600 650 700 750
Land Area in timads Line Fit
Residuals
-4E-17
-1.2E-16 0.8
Lnd in hac
-8E-17 Land 0.6Area in timads Plot Lnd in hac
-1.2E-16
0.4
0.2 1
Irrigation water in literes Line
Predicted Lnd in hac
Lnd in hac
0.5
100 120 140 160 180 200
1
Normal Probability Plot
Predicted Lnd in hac
Upper 95.0% Fertilizer
0 1 Lnd in hac
Lnd in hac
0.5
2.4 2.6 2.8 3 3.2 0.8 3.4 3.6 Predicted Lnd in hac
Lnd in hac
Land Area 0.6
in timads
0
0.4
450 500 550 600 650 700 750
0.2
Irrigation0 water in literes
0 10 20 30 40 50 60 70 80 90
Sample Percentile
e Fit
literes Line
tn hac
Probability
icted Lnd in hac Plot
Lnd in hac
Predicted Lnd in hac
50
0 40 50 60 70 80 90 100
Sample Percentile
Fertilizer
Land Area
Irrigation
in timads
water inLnd
literes
in hac Crop Yield
120 2.5 500 0.625 50
150 3 600 0.75 55
130 2.8 550 0.7 52
170 3.2 650 0.8 60
160 3.5 700 0.875 58 120 150
180 2.7 550 0.675 61 2.5 3
150 3.1 520 0.775 56 500 600
140 2.6 530 0.65 53 0.625 0.75
130 3.4 510 0.85 59
110 3 580 0.75 54
211800 4305
4305 89.8
825300 17069
1076.25 22.45
130 170 160 180 150 140 130 110
2.8 3.2 3.5 2.7 3.1 2.6 3.4 3
550 650 700 550 520 530 510 580
0.7 0.8 0.875 0.675 0.775 0.65 0.85 0.75