Bin Frequency Cumulative % Bin Frequency

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

Bin

3353.6
8858.2
9477.8
10061.1
10412.5
10600.3
10807.4
11362.2
12159
12330.6
12865.2
14035.8
14777.8
15201.6
15312.6
15551.6
16122.4
16418.6
16990.5
18098.3
18360.1
18885.6
20121.6
20532.9
20915
21864
22010.9
23014.1
23103.5
23265
23557.3
24980.8
25116.5
25203.2
26361.5
26610.6
27445.4
27620.6
28261.1
28624.1
28758
29258.1
29498.2
29603.1
30827.5
31222.4

Frequency
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
1
1
0
0
0
0
0
0
0
0
0
0

Cumulative %
0.00% More
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
2.86%
2.86%
2.86%
2.86%
2.86%
2.86%
2.86%
2.86%
2.86%
2.86%
2.86%
5.71%
8.57%
8.57%
8.57%
8.57%
8.57%
8.57%
8.57%
8.57%
8.57%
8.57%
8.57%

Bin

Frequency
35635.1
57505.7
20532.9
26361.5
26610.6
38366.4
42969.6
43415.3
44724.9
51322.4
52668.9
3353.6
8858.2
9477.8
10061.1
10412.5
10600.3
10807.4
11362.2
12159
12330.6
12865.2
14035.8
14777.8
15201.6
15312.6
15551.6
16122.4
16418.6
16990.5
18098.3
18360.1
18885.6
20121.6
20915
21864
22010.9
23014.1
23103.5
23265
23557.3
24980.8
25116.5
25203.2
27445.4

21
3
2
1
1
1
1
1
1
1
1
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

31800.8
32436.9
35635.1
36554.3
36707.4
36801.9
37029.3
38366.4
38691.9
38829.2
39945.1
40362.1
40410.5
41041.1
42969.6
43415.3
43917.9
44724.9
47160.2
51322.4
52668.9
52937.6
57505.7
57803.5
More

0
0
3
0
0
0
0
1
0
0
0
0
0
0
1
1
0
1
0
1
1
0
2
0
21

8.57%
8.57%
17.14%
17.14%
17.14%
17.14%
17.14%
20.00%
20.00%
20.00%
20.00%
20.00%
20.00%
20.00%
22.86%
25.71%
25.71%
28.57%
28.57%
31.43%
34.29%
34.29%
40.00%
40.00%
100.00%

27620.6
28261.1
28624.1
28758
29258.1
29498.2
29603.1
30827.5
31222.4
31800.8
32436.9
36554.3
36707.4
36801.9
37029.3
38691.9
38829.2
39945.1
40362.1
40410.5
41041.1
43917.9
47160.2
52937.6
57803.5

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

Histogram
30
20
10
0

150.00%
100.00%
50.00%
0.00%
More
43415.3
10412.5
14777.8
18360.1
23265
28624.1
32436.9
40362.1

Frequency

Cumulative %
60.00%
68.57%
74.29%
77.14%
80.00%
82.86%
85.71%
88.57%
91.43%
94.29%
97.14%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%

Bin

Frequency
Cumulative %

100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%

SUMMARY OUTPUT

1
8

Regression Statistics
Multiple R
0.943163544
R Square
0.889557471
Adjusted R Square
0.882432147
Standard Error
12159.86228
Observations
34
ANOVA
df
Regression
Residual
Total

SS
36919573494
4583729772
41503303266

MS
F
Significance F
18459786747 124.844486 1.47439E-15
147862250.7

Coefficients
Standard Error
238.26761
5669.513453
2.543575683
0.24405775
-0.290673999
0.34456887

t Stat
P-value
Lower 95%
0.042026112 0.9667474 -11324.78127
10.42202381 1.1833E-11 2.045816622
-0.84358752 0.40536259 -0.99342684

2
31
33

Intercept
10412.5
8858.2

RESIDUAL OUTPUT
Observation
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21

PROBABILITY OUTPUT
Predicted 20395,3
28410.65431
26057.65164
33014.88701
28460.65175
35165.10858
37704.6971
42487.59683
38934.44449
47778.89027
48176.44778
58289.27016
52927.5468
63692.42335
66198.33772
74410.42245
60892.74165
71887.81639
72328.89008
85916.1827
75008.96817
85818.09528

Residuals
Standard Residuals
-2011.254312
-0.170653207
6882.248355
0.583952884
5196.31299
0.440902711
-2228.951751
-0.189124649
-423.7085815
-0.035951311
4239.602903
0.359726678
6612.003169
0.561022811
-4537.54449
-0.385006767
-3383.790271
-0.287111709
6178.052215
0.524202444
5991.829843
0.508401635
-9668.146799
-0.820333983
-8434.023347
-0.715619664
2169.162278
0.184051563
6072.277545
0.515227554
-8602.441654
-0.729909813
-6850.416392
-0.581251969
6448.509916
0.547150548
6933.317296
0.58828604
-13180.26817
-1.118334475
-8715.895282
-0.739536256

Percentile
1.470588235
4.411764706
7.352941176
10.29411765
13.23529412
16.17647059
19.11764706
22.05882353
25
27.94117647
30.88235294
33.82352941
36.76470588
39.70588235
42.64705882
45.58823529
48.52941176
51.47058824
54.41176471
57.35294118
60.29411765

22
23
24
25
26
27
28
29
30
31
32
33
34

90439.27663
105640.2328
94327.96393
101030.1283
102063.5175
133914.2554
120017.2215
134762.0861
135654.8426
123053.486
94271.21455
101276.8833
108907.1667

2379.123373
7261.067189
-21059.06393
-8949.628349
9589.282499
1845.044643
-28886.92153
-19687.78613
2668.857354
36376.91401
2250.185446
8653.216651
18872.8333

0.201866582
0.616095337
-1.786843554
-0.759368307
0.813642414
0.156550459
-2.451030573
-1.670491806
0.226450263
3.086550026
0.19092631
0.734218028
1.601343756

63.23529412
66.17647059
69.11764706
72.05882353
75
77.94117647
80.88235294
83.82352941
86.76470588
89.70588235
92.64705882
95.58823529
98.52941176

10412,5 Residual Plot


Residuals

40000
20000
0
-20000
-40000

Upper 95%
11801.31649
3.041334744
0.412078842

OBABILITY OUTPUT
20395.3
26231.7
26399.4
32939.9
34396.9
34741.4
38211.2
41944.3
43259.4
44395.1
49099.6
52290.3
54354.5
55258.4
61828.7
64281.1
65037.4
68367.5
73268.9
77102.2
78777.4
80482.7

Lower 95,0%
-11324.78127
2.045816622
-0.99342684

Upper 95,0%
11801.31649
3.041334744
0.412078842

10000 20000 30000 40000 50000


10412,5

91130.3
92080.5
92818.4
92849.5
96521.4
109930.1
111652.8
112901.3
115074.3
127780
135759.3
138323.7
159430.4

esidual Plot

40000 50000 60000 70000

Sample Percentile

98.529

89.705

80.882

72.058

63.235

54.411

45.588

36.764

27.941

19.117

10.294

200000
150000
100000
50000
0

1.4705

20395,3

Normal Probability Plot

Series1

Perioada

PIB

IMP

EXP

trimestre
20395.3

2001 T2

26399.4

12159

9477.8

2001 T3

32939.9

11362.2

10600.3

2001 T4

38211.2

14035.8

10061.1

2002 T1

26231.7

12330.6

10807.4

2002 T2

34741.4

15201.6

12865.2

2002 T3

41944.3

16418.6

14777.8

2002 T4

49099.6

18360.1

15312.6

2003 T1

34396.9

16990.5

15551.6

2003 T2

44395.1

20532.9

16122.4

2003 T3

54354.5

20915

18098.3

2003 T4

64281.1

24980.8

18885.6

2004 T1

43259.4

23014.1

20121.6

2004 T2

55258.4

27445.4

21864

2004 T3

68367.5

28624.1

23557.3

2004 T4

80482.7

31800.8

23103.5

2005 T1

52290.3

26361.5

22010.9

2005 T2

65037.4

30827.5

23265

2005 T3

78777.4

31222.4

25203.2

2005 T4

92849.5

36554.3

25116.5

2006 T1

61828.7

32436.9

26610.6

2006 T2

77102.2

36801.9

27620.6

2006 T3

92818.4

38691.9

28261.1

2006 T4

112901.3

44724.9

28758

2007 T1

73268.9

40362.1

29498.2

2007 T2

92080.5

42969.6

29258.1

2007 T3

111652.8

43415.3

29603.1

2007 T4

135759.3

52937.6

3353.6

2008 T1

91130.3

51322.4

37029.3

2008 T2

115074.3

57505.7

40410.5

2008 T3

138323.7

57803.5

39945.1

2008 T4

159430.4

52668.9

38366.4

2009 T1

96521.4

41041.1

35635.1

2009 T2

109930.1

43917.9

36707.4

2009 T3

127780

47160.2

38829.2

2599315

180000
160000
140000
120000

10412.5

8858.2

2001 T1

1113310 815546.6

Predicted 20395,3
28410.65431
26057.65164
33014.88701
28460.65175
35165.10858
37704.6971
42487.59683
38934.44449
47778.89027
48176.44778
58289.27016
52927.5468
63692.42335
66198.33772
74410.42245
60892.74165
71887.81639
72328.89008
85916.1827
75008.96817
85818.09528
90439.27663
105640.2328
94327.96393
101030.1283
102063.5175
133914.2554
120017.2215
134762.0861
135654.8426
123053.486
94271.21455
101276.8833
108907.1667

Residuals
-2011.254312
6882.248355
5196.31299
-2228.951751
-423.7085815
4239.602903
6612.003169
-4537.54449
-3383.790271
6178.052215
5991.829843
-9668.146799
-8434.023347
2169.162278
6072.277545
-8602.441654
-6850.416392
6448.509916
6933.317296
-13180.26817
-8715.895282
2379.123373
7261.067189
-21059.06393
-8949.628349
9589.282499
1845.044643
-28886.92153
-19687.78613
2668.857354
36376.91401
2250.185446
8653.216651
18872.8333

-10000

-20000

-30000

-40000
101276.8833

123053.486

134762.0861

133914.2554

101030.1283

105640.2328

85818.09528

85916.1827

71887.81639

74410.42245

63692.42335

58289.27016

47778.89027

42487.59683

35165.10858

33014.88701

28410.65431

120000

100000
PIB

80000
IMP

60000
EXP

40000

20000

0
9 11 13 15 17 19 21 23 25 27 29 31 33 35

Distributia rezidurilor

40000

30000

20000

10000

0
Residuals

250000

200000

150000

EXP Predicted 20395,3


EXP 8858.2

100000

IMP 10412.5

50000

0
1 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31 33

60000
40000
20000
IMP

IMP
1200000

IMP
109930.1

159430.4

115074.3

92080.5

135759.3

EXP
112901.3

26399.4
38211.2
34741.4
49099.6
44395.1
64281.1
55258.4
80482.7
65037.4
92849.5
77102.2

y = 0.4279x + 55.805
R = 0.9992

Axis Title

1000000
800000
600000

IMP

400000

Linear (IMP)

200000
0
0

1000000

2000000

Axis Title

3000000

Distributia reziduurilor
40000
30000
20000
10000
0
-10000

Residuals
1

9 11 13 15 17 19 21 23 25 27 29 31 33

-20000
-30000
-40000

160000
140000
120000
100000
80000

Predicted 20395,3

60000

Residuals

40000
20000
0
-20000
-40000

1 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31 33

You might also like