0% found this document useful (0 votes)
23 views37 pages

Fertilizer and Irrigation Impact Analysis

Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
23 views37 pages

Fertilizer and Irrigation Impact Analysis

Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 37

Fertilizer Irrigation

Land Area in timads


Fertilizer 1
Irrigation 0.459179 1
Land Area 0.207519 0.582192 1
SUMMARY OUTPUT

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

CoefficientsStandard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%


Upper 95.0%
Intercept 27.45758 6.813173607 4.030073 0.00688 10.78635 44.12882 10.78635 44.12882
Fertilizer 0.124872 0.032967915 3.787696 0.009098 0.044203 0.205542 0.044203 0.205542
Irrigation water in l-0.016464 0.01361424 -1.209302 0.272031 -0.049777 0.016849 -0.049777 0.016849
Land Area in timad 6.62035 2.405007812 2.752735 0.033171 0.735508 12.50519 0.735508 12.50519

RESIDUAL OUTPUT PROBABILITY OUTPUT

ObservationPredicted Crop Yield


Residuals Percentile Crop Yield
1 50.76129 -0.76129024 5 50
2 56.17127 -1.17126621 15 52
3 53.17293 -1.17293344 25 53
4 59.1696 0.830401013 35 54
5 59.08379 -1.08379304 45 55
6 58.75452 2.245478709 55 56
7 58.1504 -2.15039933 65 58
8 53.42686 -0.42686256 75 59
9 57.80369 1.196307579 85 60
10 51.50564 2.494357528 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
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

0 Land Area in timads PlotCrop Yield


Crop Yield
50 Normal
100 120 140 160 180 200 Probability Plot
Predicted Crop Yield
100
Upper 95.0% Fertilizer
0 Crop Yield

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

Regression Statistics 120


Multiple R 0.857791 3
R Square 0.735805 2

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

RESIDUAL OUTPUT PROBABILITY OUTPUT

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

100 110 120 Predicted


50 130 140 150
60 160 170 180 190
45 12055 65 Column G
50
500 550
50 600 650
60 700 750 Normal Probability P Predicted 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

0.75 0.8 0.85 0.9


625
0 20 30 40 50 60 70 80 90 100
Sample Percentile
SUMMARY OUTPUT

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

RESIDUAL OUTPUT PROBABILITY OUTPUT

Observation Predicted Y Residuals Percentile Y


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
X Variable 1 Residual Plot
3
2 X Variable 2 Residual Plot
Residuals

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

Coefficients Standard Error t Stat P-value Lower 95%


Intercept 27.4575840985924 6.81317360675649 4.030073 0.00688 10.7863488563118
Fertilizer 0.124872456822922 0.032967915238891 3.787696 0.009098 0.04420287431734
Irrigation water in lite -0.0164637266683273 0.013614240304602 -1.209302 0.272031 -0.049776572614
Land Area in timads 6.62034986348494 2.40500781207792 2.752735 0.033171 0.73550774601526

RESIDUAL OUTPUT PROBABILITY OUTPUT

Observation Predicted Crop Yield Residuals Percentile Crop Yield


1 50.7612902418917 -0.7612902418917 5 50
2 56.1712662114891 -1.17126621148908 15 52
3 53.17293343575 -1.17293343575003 25 53
4 59.1695989872281 0.830401012771858 35 54
5 59.083793044628 -1.08379304462804 45 55
6 58.7545212905476 2.24547870945239 55 56
7 58.1503993313038 -2.15039933130376 65 58
8 53.4268625646488 -0.4268625646488 75 59
9 57.8036924205741 1.19630757942593 85 60
10 51.5056424719388 2.49435752806124 95 61
Fertilizer Residual Plot
3
2 Irrigation water in literes
Residual Plot

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

0 Land Area in timads Pl

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

Regression Statistics Fertilize


Multiple R 0.900144 3
R Square 0.81026 2

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

RESIDUAL OUTPUT PROBABILITY OUTPUT

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

0 Land Area in timads PlotCrop Yield


Crop Yield

50
100 120 140 160 180 200
100
Normal Probability
Predicted Crop Yield Plot
Fertilizer
0 80 Crop Yield
Crop Yield

450 500 50 550 600 650 Predicted Crop Yield


60 700 750

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

RESIDUAL OUTPUT PROBABILITY OUTPUT

ObservationPredicted Y Residuals Percentile Y


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
X Variable 1 Residual Plot
3
2 X Variable 2 Residual Plot
Residuals

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

825300 4305 1076.25


3275300 17069 4267.25
17069 89.8 22.45 2.101
4267.25 22.45 5.6125

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

211800 825300 4305


825300 3275300 17069
4305 17069 89.8

0.0002615 -5.94334E-05 -0.001238 80900


-5.943E-05 4.591433E-05 -0.005878 318370
-0.001238 -0.005878071 1.1877773 1669.3
Fertilizer Irrigation water in literes Land Area in timads
Fertilizer 1
Irrigation w 0.459178866031235 1
Land Area 0.207519031623211 0.582192171967689 1
Lnd in hac 0.207519031623211 0.582192171967689 1
Lnd in hac

1
SUMMARY OUTPUT

Regression Statistics VIF


Multiple R 0.9001442271512
R Square 0.8102596296736
Adjusted R 0.5487227778438
Standard E 1.944777120522
Observatio 10

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

Coefficients Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%


Intercept 27.457584098592 6.813173606756 4.03007257460213 0.00688 10.78635 44.12882 10.78635
Fertilizer 0.1248724568229 0.032967915239 3.78769648969541 0.009098 0.044203 0.205542 0.044203
Irrigation w -0.016463726668 0.013614240305 -1.20930190006723 0.272031 -0.049777 0.016849 -0.049777
Land Area 6.6203498634849 2.405007812078 2.75273528436691 0.033171 0.735508 12.50519 0.735508
Lnd in hac 0 0 65535 #NUM! 0 0 0

RESIDUAL OUTPUT PROBABILITY OUTPUT

ObservationPredicted Crop Yield Residuals Percentile Crop Yield


1 50.761290241892 -0.76129024189 5 50
2 56.171266211489 -1.17126621149 15 52
3 53.17293343575 -1.17293343575 25 53
4 59.169598987228 0.830401012772 35 54
5 59.083793044628 -1.08379304463 45 55
6 58.754521290548 2.245478709452 55 56
7 58.150399331304 -2.1503993313 65 58
8 53.426862564649 -0.42686256465 75 59
9 57.803692420574 1.196307579426 85 60
10 51.505642471939 2.494357528061 95 61
Fertilizer Residual Plot
3
2 Irrigation water in literes
Residuals 1 Residual Plot
0 Land Area in timads Residual
-1100 110 4 120 130 140 150 160 170 180 190
-2 2 Plot
-3 Residuals
0 4
Lnd in hac Residual Plot
-2450 500 550 3
2 Fertilizer 600 650 700 750
Fertilizer Line Fit Plot
Residuals
-4 0 2
1 water2.8

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

and 0Area in timads


40
0.6 0.65 200.7 0.75 0.8 0.85 0.9
0Lnd in hac
0 10 20 30 40 50 60 70 80 90 100
Sample Percentile
SUMMARY OUTPUT

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

CoefficientsStandard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%


Upper 95.0%
Intercept 62.039580261 74.50767 0.83266 0.432523 -114.1431 238.2222 -114.1431 238.2222
Irrigation water in 0.1756812302 0.141253 1.243733 0.253631 -0.15833 0.509692 -0.15833 0.509692
Land Area in timad-6.0410067942 27.47779 -0.219851 0.832261 -71.01565 58.93364 -71.01565 58.93364
Lnd in hac 0 0 65535 #NUM! 0 0 0 0

RESIDUAL OUTPUT PROBABILITY OUTPUT

Observation Predicted FertilizerResiduals Percentile Fertilizer


1 134.77767838 -14.77768 5 110
2 149.325298 0.674702 15 120
3 141.74943785 -11.74944 25 130
4 156.90115815 13.09884 35 130
5 163.87291762 -3.872918 45 140
6 142.35353853 37.64646 55 150
7 134.6666989 15.3333 65 150
8 139.4440146 0.555985 75 160
9 131.09758456 -1.097585 85 170
10 145.8116734 -35.81167 95 180
Irrigation water in literes
Residual Plot
60
Land Area in timads Residual
40 Plot
Lnd in hac Residual Plot
Residuals

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

RESIDUAL OUTPUT PROBABILITY OUTPUT

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

Irrigation water in literes


Residuals
-50 2.4 2.6
Fertilizer2.8
800 3 3.2 3.4 3.6
-100
0
0.6 600
0.65 0.7 0.75 0.8
Land Area in timads Line Fit
0.85 Irrigation
0.9 water in
-50 Land
400Area in timads literes Plot

Irrigation water in literes


-100 200 1000
Lnd in hac Line Fit Plot
Predicted Irrigation
Irrigation water in
water in literes

Irrigation water in literes


0 Lnd in hac800 literes
500
100 120 140 160 600180 200
Predicted Irrigation
Irrigation water in
water in literes
Normal Probability Plot

Irrigation water in literes


Upper 95.0% Fertilizer
0 400 800 literes
2.4 2.6 Predicted Irrigation
2002.8 3 600 3.2 3.4 3.6
water in literes
Land Area
0 in timads
400
0.6 0.65200
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
ation water in
es
Probability Plot
dicted Irrigation
Irrigation water in
er in literes
literes
Predicted Irrigation
water in literes

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

RESIDUAL OUTPUT PROBABILITY OUTPUT

ObservationPredicted Lnd in Residuals


hac Percentile Lnd in hac
1 0.625 0 5 0.625
2 0.75 -1.11E-16 15 0.65
3 0.7 0 25 0.675
4 0.8 -1.11E-16 35 0.7
5 0.875 -1.11E-16 45 0.75
6 0.675 0 55 0.75
7 0.775 -1.11E-16 65 0.775
8 0.65 0 75 0.8
9 0.85 -1.11E-16 85 0.85
10 0.75 -1.11E-16 95 0.875
Fertilizer Residual Plot
0
Land Area in timads Residual
-2E-17100 110 120 130 140 150 160 170 180 190
Plot
Residuals

-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

0 Irrigation water in literes Fit Plot 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

825300 Err:502 Err:502 Err:502 Err:502


17069 Err:502 Err:502 Err:502 Err:502
3275300 Err:502 Err:502 Err:502 Err:502
4267.25 Err:502 Err:502 Err:502 Err:502

You might also like