Production of rice Rainfall Fertilizer Cultivation Quality of seeds
10 3 3 4 2
25 5 4 5 6
32 7 6 7 6
36 9 8 6 5
27 4 5 5 3
25 7 6 6 5
29 6 6 7 4
22 4 8 8 5
20 2 3 4 1
12 6 4 5 6
15 4 5 4 3
16 3 4 3 2
10 2 1 2 3
35 7 3 4 5
36 5 6 5 6
48 8 8 9 9
50 9 9 10 10
49 9 9 8 9
47 9 8 9 10
43 9 7 8 9
42 5 6 5 9
14 3 2 4 3
41 2 3 4 9
45 9 8 8 10
49 9 8 7 9
47 8 7 8 9
14 2 3 4 2
16 3 3 2 3
15 4 5 4 3
19 3 2 2 3
23 5 4 4 5
26 3 3 5 3
24 6 3 4 5
50 8 8 9 10
11 4 6 2 3
16 5 3 4 4
17 6 5 4 6
16 6 3 4 6
18 8 6 5 8
16 3 4 4 3
25 4 4 2 4
27 3 4 3 4
26 4 5 5 4
15 2 4 4 3
10 1 2 3 2
25 3 4 4 4
32 9 6 5 9
36 3 8 7 3
27 4 4 3 4
25 6 4 5 6
SUMMARY
OUTPUT
Regression Statistics
Multiple R 0.871524701
R Square 0.759555305
Adjusted R
Square 0.738182443
Standard Error 6.421621839
Observations 50
ANOVA
Significance
df SS MS F F
Regression 4 5862.004783 1465.501 35.53831 2.14E-13
Residual 45 1855.675217 41.23723
Total 49 7717.68
Standard Upper Lower Upper
Coefficients Error t Stat P-value Lower 95% 95% 95.0% 95.0%
Intercept 1.099690509 2.49747343 0.440321 0.661812 -3.93048 6.12986 -3.93048 6.12986
Rainfall -0.809358584 0.728649723 -1.11076 0.27257 -2.27693 0.658217 -2.27693 0.658217
Fertilizer 1.434332334 0.869224269 1.650129 0.10588 -0.31638 3.18504 -0.31638 3.18504
Cultivation 1.652731414 0.886441267 1.864457 0.068788 -0.13265 3.438116 -0.13265 3.438116
Quality of
seeds 2.761944214 0.62854152 4.394211 6.7E-05 1.495997 4.027892 1.495997 4.027892
After the regression:
Ans to the ques. No. 1
Develop the regression Equation?
We know that.
Y= a+b1x1+b2x2+b3x3+b4x4
Here,
a= 1.099690509
b1= -0.809358584
b2= 1.434332334
b3= 1.652731414
b4= 2.761944214
Now,
Ŷ = a+b1x1+b2x2+b3x3+b4x4
= 1.099690509 -0.809358584X1 + 1.434332334X2 + 1.652731414 X3 + 2.761944214X4
Ans to the Ques. No. 2
Which development variable impacts most on the dependent variable?
Ans: If we see on table of regression than we can see of our dependent variable’s Quality of seeds is
2.761944214
Ans to the ques no. 3
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.694763267
R Square 0.482695997
Adjusted R Square 0.47191883
Standard Error 9.12001777
Observations 50
ANOVA
d
f
Regression 1
Residual 48
Total 49
Co
efficients
Intercept 8.494436381
Rainfall 3.587946645
Identify Individual relationship between dependent variables and independent variables.
Ans: When we do regression between production of Rice and Rainfall then the output comes
3.587946645.
When we do regression between production of Rice and Fertilizer then the output comes
4.481308411
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.746222495
R Square 0.556848012
Adjusted R Square 0.547615679
Standard Error 8.441101372
Observations 50
ANOVA
df
Regression 1
Residual 48
Total 49
Coefficients
Intercept 4.673457944
Fertilizer 4.481308411
When we do regression between production of Rice and Cultivation then the output comes
4.702377596
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.780872872
R Square 0.609762442
Adjusted R Square 0.601632493
Standard Error 7.921132859
Observations 50
ANOVA
df
Regression 1
Residual 48
Total 49
Coefficients
Intercept 3.285969364
Cultivation 4.702377596
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.813188682
R Square 0.661275832
Adjusted R Square 0.654219079
Standard Error 7.379821493
Observations 50
ANOVA
df
Regression 1
Residual 48
Total 49
Coefficients
Intercept 6.73962482
Quality of seeds 3.837806638
When we do regression between production of Rice and Fertilizer then the output comes
3.837806638
