Regression Analysis

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 5

SUMMAR

Y OUTPUT
Regressio
n
Statistics
Multiple R 0.814823
R Square 0.663936
Adjusted
0.567918
R Square
Standard
0.731447
Error
Observati
10
ons
ANOVA

Regressio
n
Residual
Total

df

SS

MS

7.398915

3.699457694

7
9

3.745098
11.14401

0.53501403

Coefficien Standard
ts
Error
Intercept 17.637 5.520829

Significance
F

6.914693 0.02200268

P-value

Lower 95%

3.194630007

Upper
95%
0.015179 4.58231959 30.69169

Lower
95.0%
4.58232

Upper
95.0%
30.69169

0.532772503

0.610679

t Stat

X Variable
1

2.2E-05

4.13E-05

-7.559E-05

0.00012

-7.6E-05

0.00012

X Variable
2

-7E-05

3.54E-05 -1.964005295 0.090285 -0.0001532

1.42E-05

-0.00015

1.42E-05

year
2000-01
2001-02
2002-03
2003-04
2004-05
2005-06
2006-07
2007-08
2008-09
2009-10

count
sum
maximum
minimum
mean
median
mode
standard
deviation

production(mi
capital
no. of
llion tones) employed (K) employees
(Q)
(in crore)
(L)
7.126
18265 150832
7.315
17045 147601
8.029
16542 137496
8.581
15271 131910
8.901
20064 126857
9.351
21782 138211
9.849
25476 132973
10.288
28450 128804
9.846
34552 121295
9.736
43752 116950

In (Q)
1.96375007
1.98992703
2.08305999
2.14955046
2.18616363
2.23548329
2.28736993
2.33097817
2.28706528
2.27583036

10
89.022
10.288
7.126
8.9022
9.126

10
241199
43752
15271
24119.9
20923

Descriptive Data
10
1332929
150832
116950
133292.9
132441.5

1.112755019

9170.08784

10691.748

In (K)
9.81274194
9.74361218
9.71365788
9.63371088
9.90668244
9.98883922
10.14549211
10.25590344
10.45022071
10.68629261

In (L)
11.9239219
11.9022680
11.8313501
11.7898752
11.7508157
11.8365368
11.7979014
11.7660471
11.7059809
11.6695018

Output vs. Capital


12
11
10
9
8

Output vs. Capital

6
5

output vs. Labour


12
11
10

10
9

8
7
6
5

Output vs. Capital

output vs. Labour

You might also like