Year : 2008

B 151

Linear

Model Summary
Adjusted R Std. Error of the
R R Square Square Estimate
.629 .396 .329 .230
The independent variable is Pieces.

Coefficients
Standardized
Unstandardized Coefficients Coefficients
B Std. Error Beta t Sig.
Piecces -2.215E-6 .000 -.629 -2.430 .038
(Constant) 8.937 .081 110.907 .000
The dependent variable is in (rate)
Logarithmic
Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.748 .560 .511 .196
The independent variable is Piecces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
ln(Piecces) -.214 .063 -.748 -3.382 .008
(Constant) 10.986 .638 17.207 .000
The dependent variable is in (rate)
Quadratic

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.784 .614 .518 .195
The independent variable is Piecces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Piecces -1.276E-5 .000 -3.626 -2.543 .035
Piecces ** 2 3.624E-11 .000 3.033 . .
(Constant) 9.131 .114 80.122 .000
The dependent variable is in (rate)
Cubic

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.784 .615 .519 .194
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Piecces -1.042E-5 .000 -2.960 -2.655 .029
Piecces ** 3 1.008E-16 .000 2.377 . .
(Constant) 9.103 .104 87.783 .000
The dependent variable is in (rate)
Growth

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.629 .396 .329 .026
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Piecces -2.547E-7 .000 -.629 -2.430 .038
(Constant) 2.190 .009 236.355 .000
The dependent variable is ln (Rate).
Exponential

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.629 .396 .329 .026
The independent variable is Piecces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Piecces -2.547E-7 .000 -.629 -2.430 .038
(Constant) 8.935 .083 107.928 .000
The dependent variable is ln(Rate).
Summary
2
Model R
Linear Y=a+bx 0.396
Logarithmic y=ab x 0.560
Quadratic Y=a+bx+c x 2 0.614
Cubic Y=a x 3+b x 2+cx+d, a≠0 0.615
Growth Y=ax /b+ x 0.396
Exponential Y=ae bx 0.396

Analysis & Interpretation:

From the above table we can interpret that cubic model is best fitted model for trend because
the value of R2 is higher than other values.
G 060

Due to rate being constant for five years we have made analysis by comparing amount and
pieces.

Linear

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

1.000 1.000 . .

The independent variable is Pieces.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces 7.000 .000 1.000 . .

(Constant) 5.054E-13 .000 . .

Logarithmic
 Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

1.000 1.000 . .

The independent variable is Pieces.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

ln(Pieces) 4541.011 .000 1.000 . .

(Constant) -24848.531 .000 . .

Quadratic

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

1.000 1.000 . .

The independent variable is Pieces.

 Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces ** 2 .005 .000 1.000 . .

(Constant) 2261.538 .000 . .

Cubic

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

1.000 1.000 . .

The independent variable is Pieces.

 Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces ** 2 .005 .000 1.000 . .

(Constant) 2261.538 .000 . .

Growth

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

1.000 1.000 . .

The independent variable is Pieces.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces .002 .000 1.000 . .

(Constant) 7.418 .000 . .

The dependent variable is ln(Amt).

Exponential

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

1.000 1.000 . .

The independent variable is Pieces.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces .002 .000 1.000 . .

(Constant) 1665.592 .000 . .

The dependent variable is ln(Amt).

Summary
2
Model R
Linear Y=a+bx 1.00
Logarithmic y=ab x 1.00
Quadratic Y=a+bx+c x 2 1.00
Cubic Y=a x 3+b x 2+cx+d, a≠0 1.00
Growth Y=ax /b+ x 1.00
Exponential Y=ae bx 1.00

Analysis & Interpretation:

From the above table we can interpret that all the models are best fitted for trend of G 060

G 062

Considering the average price of euro as 64.78 per Indian rupee and converting the rates into
Indian rupees.

Linear
 Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.970 .942 .912 .912

The independent variable is Pieces.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces -.003 .000 -.970 -5.679 .030

(Constant) 51.165 3.225 15.865 .004

Logarithmic

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.970 .942 .912 .912

The independent variable is Pieces.

 Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

ln(Pieces) -18.006 3.171 -.970 -5.679 .030

(Constant) 192.268 28.044 6.856 .021

Quadratic
Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.970 .942 .912 .912

The independent variable is Pieces.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces -.003 .000 -.970 -5.679 .030

(Constant) 51.165 3.225 15.865 .004

Cubic

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.970 .942 .912 .912

The independent variable is Pieces.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces -.003 .000 -.970 -5.679 .030

(Constant) 51.165 3.225 15.865 .004

Growth
 Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.970 .941 .911 .028

The independent variable is Pieces.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces -7.859E-5 .000 -.970 -5.640 .030

(Constant) 4.044 .099 41.043 .001

The dependent variable is ln(Rate).

Exponential

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.970 .941 .911 .028

The independent variable is Pieces.

 Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces -7.859E-5 .000 -.970 -5.640 .030

(Constant) 57.079 5.625 10.148 .010

The dependent variable is ln(Rate).

Summary
2
Model R
Linear Y=a+bx 0.942
Logarithmic y=ab x 0.942
Quadratic Y=a+bx+c x 2 0.942
Cubic Y=a x 3+b x 2+cx+d, a≠0 0.942
Growth Y=ax /b+ x 0.941
Exponential Y=ae bx 0.941

Analysis & Interpretation:

From the above table we can interpret that linear, logarithmic, quadratic, & cubic models are
best fitted for trend of G 062.
S 002

Linear

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
1.000 1.000 . .
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces .005 .000 1.000 . .
(Constant) 27.125 .000 . .
Logarithmic

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
1.000 1.000 . .
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
ln(Pieces) 4.660 .000 1.000 . .
(Constant) 1.080 .000 . .
Quadratic

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
1.000 1.000 . .
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces ** 2 1.953E-6 .000 1.000 . .
(Constant) 28.688 .000 . .
Cubic

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
1.000 1.000 . .
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces ** 2 1.953E-6 .000 1.000 . .
(Constant) 28.688 .000 . .
Growth

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
1.000 1.000 . .
The independent variable is Pieces.
 Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces .000 .000 1.000 . .
(Constant) 3.310 .000 . .
The dependent variable is ln(Rate).

Exponential

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
1.000 1.000 . .
The independent variable is Pieces.
 Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces .000 .000 1.000 . .
(Constant) 27.379 .000 . .
The dependent variable is ln(Rate).

Summary
2
Model R
Linear Y=a+bx 1.00
Logarithmic y=ab x 1.00
Quadratic Y=a+bx+c x 2 1.00
Cubic Y=a x 3+b x 2+cx+d, a≠0 1.00
Growth Y=ax /b+ x 1.00
Exponential Y=ae bx 1.00

Analysis & Interpretation:

From the above table we can interpret that all the models are best fitted for trend of S 002.
T 001
Linear

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.202 .041 -.119 2.190
The independent variable is Peaces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Peaces .000 .000 .202 .504 .632
(Constant) 21.148 1.042 20.291 .000
Logarithmic

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.004 .000 -.167 2.236
The independent variable is Peaces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
ln(Peaces) .012 1.125 .004 .010 .992
(Constant) 21.411 8.593 2.492 .047
Quadratic
Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.728 .529 .341 1.680
The independent variable is Peaces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Peaces -.004 .002 -6.735 -2.201 .079
Peaces ** 2 3.455E-7 .000 6.972 2.278 .072
(Constant) 27.150 2.753 9.862 .000
Cubic

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.743 .552 .373 1.639
The independent variable is Peaces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Peaces ** 2 -1.345E-6 .000 -27.145 -2.290 .071
Peaces ** 3 1.211E-10 .000 27.425 . .
(Constant) 24.530 1.549 15.841 .000
Growth

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.202 .041 -.119 .105
The independent variable is Peaces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Peaces 5.973E-6 .000 .202 .504 .632
(Constant) 3.047 .050 61.209 .000
The dependent variable is ln(Rate).
Exponential

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.202 .041 -.119 .105
The independent variable is Peaces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Peaces 5.973E-6 .000 .202 .504 .632
(Constant) 21.053 1.048 20.088 .000
The dependent variable is ln(Rate).

Summary
2
Model R
Linear Y=a+bx 0.041
Logarithmic y=ab x 0.000
Quadratic Y=a+bx+c x 2 0.529
 Cubic Y=a x 3+b x 2+cx+d, a≠0 0.552
Growth Y=ax /b+ x 0.041
Exponential Y=ae bx 0.041

Analysis & Interpretation:

From the above table we can interpret that cubic model is best fitted for trend of T 001.

Year 2009

B 151

Linear
Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.368 .135 .081 .298
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces -1.791E-6 .000 -.368 -1.581 .134
(Constant) 8.891 .076 116.604 .000
The dependent variable is in 9rate)
Logarithmic

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.100 .010 -.052 .319
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
ln(Pieces) -.032 .079 -.100 -.401 .694
(Constant) 9.139 .739 12.368 .000
The dependent variable is in (rate)
Quadratic

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.369 .136 .021 .308
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces -3.214E-6 .000 -.660 -.284 .781
Pieces ** 2 4.953E-12 .000 .294 . .
(Constant) 8.906 .141 63.278 .000
The dependent variable is in (rate)

Cubic

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.373 .139 .024 .307
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces -4.269E-6 .000 -.876 -.435 .670
Pieces ** 3 3.080E-17 .000 .512 . .
(Constant) 8.918 .132 67.473 .000
The dependent variable is in (rate)

Growth

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.361 .131 .076 .035
The independent variable is Pieces.
 Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces -2.049E-7 .000 -.361 -1.550 .141
(Constant) 2.185 .009 245.409 .000
The dependent variable is ln(Rate).

Exponential

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.361 .131 .076 .035
The independent variable is Pieces.
 Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces -2.049E-7 .000 -.361 -1.550 .141
(Constant) 8.887 .079 112.339 .000
The dependent variable is ln (Rate).

Summary
2
Model R
Linear Y=a+bx 0.135
Logarithmic y=ab x 0.010
Quadratic Y=a+bx+c x 2 0.136
Cubic Y=a x 3+b x 2+cx+d, a≠0 0.139
Growth Y=ax /b+ x 0.131
Exponential Y=ae bx 0.131

Analysis & Interpretation:

From the above table we can interpret that cubic model is best fitted for trend of B 151.

G 060
Due to rate being constant for five years we have made analysis by comparing amount and
pieces.

Linear
 Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

1.000 1.000 1.000 .000

The independent variable is Pieces.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces 7.000 .000 1.000 . .

(Constant) -4.392E-13 .000 . .

Logarithmic
 Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.914 .835 .808 1772.125

The independent variable is Pieces.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

ln(Pieces) 4713.449 855.028 .914 5.513 .001

(Constant) -24768.044 5473.368 -4.525 .004

Quadratic

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

1.000 1.000 1.000 .000

The independent variable is Pieces.

 Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces 7.000 .000 1.000 . .

(Constant) -4.392E-13 .000 . .

Cubic

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

1.000 1.000 1.000 .000

The independent variable is Pieces.

 Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces 7.000 .000 1.000 . .

(Constant) -4.392E-13 .000 . .

Growth

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.914 .835 .808 .344

The independent variable is Pieces.

 Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces .001 .000 .914 5.513 .001

(Constant) 7.383 .207 35.705 .000

The dependent variable is ln(Amt).

Exponential

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.914 .835 .808 .344

The independent variable is Pieces.

 Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces .001 .000 .914 5.513 .001

(Constant) 1608.077 332.508 4.836 .003

The dependent variable is ln(Amt).

Summary
2
Model R
Linear Y=a+bx 1.000
Logarithmic y=ab x 0.835
Quadratic Y=a+bx+c x 2 1.000
Cubic Y=a x 3+b x 2+cx+d, a≠0 1.000
Growth Y=ax /b+ x 0.835
Exponential Y=ae bx 0.835

Analysis & Interpretation:

From the above table we can interpret that linear, quadratic & cubic models are the best fitted
for trend of G 060.
G 062
Considering the average price of euro as 65.93 per Indian rupee and converting the rates into
Indian rupees.

Linear

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.500 .250 -.500 1.867

The independent variable is Pieces.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces .000 .000 .500 .577 .667

(Constant) 23.070 3.233 7.135 .089

Logarithmic
 Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.500 .250 -.500 1.867

The independent variable is Pieces.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

ln(Pieces) 1.904 3.298 .500 .577 .667

(Constant) 8.170 28.876 .283 .824

Quadratic

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.500 .250 -.500 1.867

The independent variable is Pieces.

 Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces .000 .000 .500 .577 .667

(Constant) 23.070 3.233 7.135 .089

Cubic

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.500 .250 -.500 1.867

The independent variable is Pieces.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces .000 .000 .500 .577 .667

(Constant) 23.070 3.233 7.135 .089

Growth

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.500 .250 -.500 .077

The independent variable is Pieces.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces 1.083E-5 .000 .500 .577 .667

(Constant) 3.139 .133 23.652 .027

The dependent variable is ln(Rate).

Exponential

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.500 .250 -.500 .077

The independent variable is Pieces.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces 1.083E-5 .000 .500 .577 .667

(Constant) 23.070 3.061 7.536 .084

The dependent variable is ln(Rate).

Summary
 2
Model R
Linear Y=a+bx 0.250
Logarithmic y=ab x 0.250
Quadratic Y=a+bx+c x 2 0.250
Cubic Y=a x 3+b x 2+cx+d, a≠0 0.250
Growth Y=ax /b+ x 0.250
Exponential Y=ae bx 0.250

Analysis & Interpretation:

From the above table we can interpret that all the models are the best fitted for trend of G
062.

S 002
Linear

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
1.000 1.000 1.000 .000
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces .004 .000 1.000 . .
(Constant) 32.000 .000 . .
Logarithmic

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
1.000 1.000 1.000 .000
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
ln(Pieces) 2.885 .000 1.000 . .
(Constant) 16.068 .000 . .
Quadratic

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
1.000 1.000 1.000 .000
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces .004 .000 1.000 . .
(Constant) 32.000 .000 . .
Cubic

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
1.000 1.000 1.000 .000
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces .004 .000 1.000 . .
(Constant) 32.000 .000 . .
Growth

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
1.000 1.000 1.000 .000
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces .000 .000 1.000 . .
(Constant) 3.469 .000 . .
The dependent variable is ln(Rate).
Exponential

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
1.000 1.000 1.000 .000
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces .000 .000 1.000 . .
(Constant) 32.111 .000 . .
The dependent variable is ln(Rate).
Summary
2
Model R
Linear Y=a+bx 1.00
Logarithmic y=ab x 1.00
Quadratic Y=a+bx+c x 2 1.00
Cubic Y=a x 3+b x 2+cx+d, a≠0 1.00
Growth Y=ax /b+ x 1.00
Exponential Y=ae bx 1.00

Analysis & Interpretation:

From the above table we can interpret that al models are best fitted for trend of S 002.

T 001

Linear
Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.032 .001 -.124 3.032
The independent variable is Pieces.
 Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces .000 .002 .032 .091 .930
(Constant) 21.857 3.886 5.625 .000

Logarithmic

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.060 .004 -.121 3.028
The independent variable is Pieces.
 Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
ln(Pieces) .548 3.222 .060 .170 .869
(Constant) 18.115 24.042 .753 .473

Quadratic

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.307 .094 -.165 3.086
The independent variable is Pieces.
 Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces .013 .016 2.252 .853 .422
Pieces ** 2 -4.000E-6 .000 -2.241 -.849 .424
(Constant) 12.000 12.272 .978 .361

Cubic

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.369 .136 -.111 3.014
The independent variable is Pieces.
 Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces ** 2 4.604E-6 .000 2.579 1.036 .335
Pieces ** 3 -1.744E-9 .000 -2.615 . .
(Constant) 18.352 4.409 4.162 .004

Growth

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.038 .001 -.123 .139
The independent variable is Pieces.
 Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces 1.025E-5 .000 .038 .107 .918
(Constant) 3.074 .178 17.227 .000
The dependent variable is ln(Rate).

Exponential

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.038 .001 -.123 .139
The independent variable is Pieces.
 Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces 1.025E-5 .000 .038 .107 .918
(Constant) 21.628 3.859 5.604 .001
The dependent variable is ln(Rate).

Summary
2
Model R
Linear Y=a+bx 0.001
Logarithmic y=ab x 0.004
Quadratic Y=a+bx+c x 2 0.094
Cubic Y=a x 3+b x 2+cx+d, a≠0 0.136
Growth Y=ax /b+ x 0.001
Exponential Y=ae bx 0.001

Analysis & Interpretation:

From the above table we can interpret that cubic model is best fitted for trend of T 001.

Year 2010
B 151

Linear
 Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.243 .059 .029 .289
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces -7.515E-6 .000 -.243 -1.394 .173
(Constant) 8.885 .090 99.020 .000
The dependent variable is in (rate)

Logarithmic
 Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.239 .057 .026 .289
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
ln(Pieces) -.066 .048 -.239 -1.367 .181
(Constant) 9.386 .445 21.102 .000
The dependent variable is in (rate)

Quadratic
 Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.256 .066 .003 .293
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces -1.785E-7 .000 -.006 -.011 .992
Pieces ** 2 -1.694E-10 .000 -.251 . .
(Constant) 8.831 .149 59.159 .000
The dependent variable is in (rate)

Cubic
 Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.431 .186 .102 .278
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces -6.575E-5 .000 -2.126 -1.853 .074
Pieces ** 2 4.240E-9 .000 6.272 . .
Pieces ** 3 -7.071E-14 .000 -4.580 . .
(Constant) 9.050 .177 51.225 .000
The dependent variable is in (rate)

Growth
 Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.243 .059 .029 .033
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces -8.642E-7 .000 -.243 -1.394 .173
(Constant) 2.184 .010 211.667 .000
The dependent variable is ln (rate).

Exponential

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.243 .059 .029 .033
The independent variable is Pieces.
 Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces -8.642E-7 .000 -.243 -1.394 .173
(Constant) 8.882 .092 96.915 .000
The dependent variable is ln (rate).

Summary

2
Model R
Linear Y=a+bx 0.059
Logarithmic y=ab x 0.057
Quadratic Y=a+bx+c x 2 0.066
Cubic Y=a x 3+b x 2+cx+d, a≠0 0.186
Growth Y=ax /b+ x 0.059
Exponential Y=ae bx 0.059

Analysis & Interpretation:

From the above table we can interpret that cubic model is best fitted for trend of B 151.
G 060
Due to rate being constant for five years we have made analysis by comparing amount and
pieces.

Linear

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

1.000 1.000 1.000 .000

The independent variable is Pieces.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces 7.000 .000 1.000 1.342E8 .000

(Constant) 1.759E-13 .000 .000 1.000

Logarithmic

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.961 .923 .904 1899.946

The independent variable is Pieces.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

ln(Pieces) 10236.675 1477.008 .961 6.931 .002

(Constant) -62700.157 10355.175 -6.055 .004

Quadratic

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

1.000 1.000 1.000 .000

The independent variable is Pieces.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces 7.000 .000 1.000 1.703E7 .000

Pieces ** 2 9.430E-18 .000 .000 . .

(Constant) 2.430E-11 .000 .000 1.000

Cubic

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

1.000 1.000 1.000 .000

The independent variable is Pieces.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces 7.000 .000 1.000 1.703E7 .000

Pieces ** 2 9.430E-18 .000 .000 . .

(Constant) 2.430E-11 .000 .000 1.000

Growth

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.961 .923 .904 .178

The independent variable is Pieces.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces .001 .000 .961 6.931 .002

(Constant) 8.138 .136 59.652 .000

The dependent variable is ln(Amt).

Exponential
Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.961 .923 .904 .178

The independent variable is Pieces.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces .001 .000 .961 6.931 .002

(Constant) 3420.512 466.619 7.330 .002

The dependent variable is ln(Amt).

Summary

2
Model R
Linear Y=a+bx 1.000
Logarithmic y=ab x 0.923
Quadratic Y=a+bx+c x 2 1.000
Cubic Y=a x 3+b x 2+cx+d, a≠0 1.000
Growth Y=ax /b+ x 0.923
Exponential Y=ae bx 0.923

Analysis & Interpretation:

From the above table we can interpret that linear, quadratic & cubic models are best fitted for
trend of G 060.

G 062
Considering the average price of euro as 59.37 per Indian rupee and converting the rates into
Indian rupees.

Linear

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.153 .023 -.085 2.023

The independent variable is Pieces.

 Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces -8.013E-5 .000 -.153 -.463 .654

(Constant) 22.304 1.341 16.628 .000

Logarithmic

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.174 .030 -.077 2.016

The independent variable is Pieces.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

ln(Pieces) -.468 .882 -.174 -.530 .609

(Constant) 25.793 7.652 3.371 .008

Quadratic

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.206 .043 -.197 2.124

The independent variable is Pieces.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces .000 .001 -1.241 -.455 .662

Pieces ** 2 4.601E-8 .000 1.098 .402 .698

(Constant) 23.482 3.254 7.216 .000

Cubic

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.206 .043 -.197 2.124

The independent variable is Pieces.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces .000 .001 -.829 -.482 .642

Pieces ** 3 2.707E-12 .000 .690 . .

(Constant) 23.212 2.663 8.717 .000

Growth

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.161 .026 -.082 .090

The independent variable is Pieces.

 Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces -3.776E-6 .000 -.161 -.489 .637

(Constant) 3.102 .060 51.789 .000

The dependent variable is ln(Rate).

Exponential

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.161 .026 -.082 .090

The independent variable is Pieces.

 Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces -3.776E-6 .000 -.161 -.489 .637

(Constant) 22.247 1.333 16.694 .000

The dependent variable is ln(Rate).

Summary
2
Model R
Linear Y=a+bx 0.023
Logarithmic y=ab x 0.030
Quadratic Y=a+bx+c x 2 0.043
Cubic Y=a x 3+b x 2+cx+d, a≠0 0.043
Growth Y=ax /b+ x 0.026
Exponential Y=ae bx 0.026
Analysis & Interpretation:

From the above table we can interpret that quadratic & cubic models are the best fitted for
trend of G 062.

S 002
Linear
 Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.211 .045 -.147 .261
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces 7.352E-5 .000 .211 .483 .650
(Constant) 38.019 .275 138.190 .000

Logarithmic
 Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.115 .013 -.184 .265
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
ln(Pieces) .065 .251 .115 .259 .806
(Constant) 37.665 1.850 20.359 .000

Quadratic
 Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.726 .528 .292 .205
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces -.001 .001 -4.238 -1.904 .130
Pieces ** 2 4.368E-7 .000 4.503 2.023 .113
(Constant) 39.206 .625 62.684 .000

Cubic
 Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.728 .530 .295 .205
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces ** 2 -3.870E-7 .000 -3.989 -1.753 .154
Pieces ** 3 1.422E-10 .000 4.355 . .
(Constant) 38.411 .234 163.956 .000

Growth
 Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.211 .045 -.147 .007
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces 1.922E-6 .000 .211 .483 .650
(Constant) 3.638 .007 505.797 .000
The dependent variable is ln(Rate).

Exponential
 Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.211 .045 -.147 .007
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces 1.922E-6 .000 .211 .483 .650
(Constant) 38.019 .273 139.029 .000
The dependent variable is ln(Rate).

Summary
2
Model R
Linear Y=a+bx 0.045
Logarithmic y=ab x 0.013
Quadratic Y=a+bx+c x 2 0.528
Cubic Y=a x 3+b x 2+cx+d, a≠0 0.530
Growth Y=ax /b+ x 0.045
Exponential Y=ae bx 0.045
Analysis & Interpretation:

From the above table we can interpret that cubic model is best fitted for trend of S 002.
T 001

Limitation:

Rate is constant so there is no model formulation.

Year 2011

B 151

Linear
Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.066 .004 -.027 .435
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces 3.279E-6 .000 .066 .376 .710
(Constant) 8.881 .148 60.054 .000
The dependent variable is in (rate)
Logarithmic

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.028 .001 -.030 .435
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
ln(Pieces) .011 .071 .028 .157 .876
(Constant) 8.825 .668 13.209 .000
The dependent variable is in (rate)
Quadratic
Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.219 .048 -.014 .432
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces 2.750E-5 .000 .556 1.242 .223
Pieces ** 2 -6.322E-10 .000 -.532 . .
(Constant) 8.709 .207 42.129 .000
The dependent variable is in (rate)
Cubic
Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.509 .259 .185 .387
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces .000 .000 -2.422 -2.212 .035
Pieces ** 2 8.617E-9 .000 7.253 . .
Pieces ** 3 -1.418E-13 .000 -5.198 . .
(Constant) 9.201 .250 36.740 .000
The dependent variable is in (rate)

Growth
Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.058 .003 -.028 .048
The independent variable is Pieces.
 Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces 3.147E-7 .000 .058 .328 .745
(Constant) 2.184 .016 134.201 .000
The dependent variable is ln (rate).

Exponential
Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.058 .003 -.028 .048
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces 3.147E-7 .000 .058 .328 .745
(Constant) 8.879 .144 61.457 .000
The dependent variable is ln (rate).
Summary
2
Model R
Linear Y=a+bx 0.004
Logarithmic y=ab x 0.001
Quadratic Y=a+bx+c x 2 0.048
Cubic Y=a x 3+b x 2+cx+d, a≠0 0.259
Growth Y=ax /b+ x 0.003
Exponential Y=ae bx 0.003

Analysis & Interpretation:

From the above table we can interpret that cubic model is best fitted for trend of B 151.

G 060
Due to rate being constant for five years we have made analysis by comparing amount and
pieces.

Linear
 Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

1.000 1.000 1.000 .000

The independent variable is Piece.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Piece 7.000 .000 1.000 1.342E8 .000

(Constant) 3.586E-12 .000 .000 1.000

Logarithmic

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.942 .888 .874 2051.615

The independent variable is Piece.

 Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

ln(Piece) 7786.478 976.927 .942 7.970 .000

(Constant) -45169.849 6851.231 -6.593 .000

Quadratic

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

1.000 1.000 1.000 .000

The independent variable is Piece.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Piece 7.000 .000 1.000 3.207E7 .000

Piece ** 2 1.054E-17 .000 .000 . .

(Constant) 2.281E-11 .000 .000 1.000

Cubic
Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

1.000 1.000 1.000 .000

The independent variable is Piece.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Piece 7.000 .000 1.000 9.860E6 .000

Piece ** 2 2.197E-16 .000 .000 . .

Piece ** 3 -4.252E-20 .000 .000 . .

(Constant) 1.193E-10 .000 .000 1.000

Growth
Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.942 .888 .874 .248

The independent variable is Piece.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Piece .001 .000 .942 7.970 .000

(Constant) 7.879 .153 51.431 .000

The dependent variable is ln(Amt).

Exponential
Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.942 .888 .874 .248

The independent variable is Piece.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Piece .001 .000 .942 7.970 .000

(Constant) 2641.239 404.629 6.528 .000

The dependent variable is ln(Amt).

Summary
2
Model R
Linear Y=a+bx 1.000
Logarithmic y=ab x 0.888
Quadratic Y=a+bx+c x 2 1.000
Cubic Y=a x 3+b x 2+cx+d, a≠0 1.000
Growth Y=ax /b+ x 0.888
Exponential Y=ae bx 0.888

Analysis & Interpretation:

From the above table we can interpret that linear, quadratic & cubic models are best fitted for
trend of G 060.

G 062

Considering the average price of euro as 63.40 per Indian rupee and converting the rates into
Indian rupees.

Linear

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.339 .115 -.062 .700

The independent variable is Pieces.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces -6.612E-5 .000 -.339 -.806 .457

(Constant) 26.553 .638 41.648 .000

Logarithmic
 Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.432 .186 .024 .671

The independent variable is Pieces.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

ln(Pieces) -.425 .397 -.432 -1.070 .334

(Constant) 29.781 3.463 8.601 .000

Quadratic

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.770 .594 .390 .530

The independent variable is Pieces.

 Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces .000 .000 -4.823 -2.307 .082

Pieces ** 2 7.242E-8 .000 4.537 2.170 .096

(Constant) 28.363 .964 29.432 .000

Cubic

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.775 .601 .401 .525

The independent variable is Pieces.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces .000 .000 -2.712 -2.420 .073

Pieces ** 3 3.724E-12 .000 2.473 . .

(Constant) 27.768 .729 38.066 .000

Growth

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.339 .115 -.062 .027

The independent variable is Pieces.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces -2.544E-6 .000 -.339 -.806 .457

(Constant) 3.279 .025 133.670 .000

The dependent variable is ln(Rate).

Exponential

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.339 .115 -.062 .027

The independent variable is Pieces.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces -2.544E-6 .000 -.339 -.806 .457

(Constant) 26.552 .651 40.764 .000

The dependent variable is ln(Rate).

Summary
2
Model R
Linear Y=a+bx 0.115
Logarithmic y=ab x 0.186
Quadratic Y=a+bx+c x 2 0.594
Cubic Y=a x 3+b x 2+cx+d, a≠0 0.601
Growth Y=ax /b+ x 0.115
Exponential Y=ae bx 0.115
Analysis & Interpretation:
From the above table we can interpret that cubic model is best fitted for trend of G 062.

S 002

Linear
Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.303 .092 -.021 2.010
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces .001 .001 .303 .901 .394
(Constant) 39.044 1.432 27.260 .000

Logarithmic

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.215 .046 -.073 2.060
The independent variable is Pieces.
 Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
ln(Pieces) .755 1.212 .215 .623 .551
(Constant) 34.641 8.948 3.872 .005

Quadratic

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.434 .189 -.043 2.031
The independent variable is Pieces.
 Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces -.003 .004 -1.390 -.736 .485
Pieces ** 2 9.131E-7 .000 1.721 .912 .392
(Constant) 41.808 3.358 12.449 .000

Cubic

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.507 .257 -.115 2.100
The independent variable is Pieces.
 Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces -.015 .017 -7.213 -.891 .407
Pieces ** 2 8.087E-6 .000 15.245 .831 .438
Pieces ** 3 -1.228E-9 .000 -7.871 . .
(Constant) 47.793 8.790 5.437 .002

Growth

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.309 .095 -.018 .050
The independent variable is Pieces.
 Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces 1.632E-5 .000 .309 .919 .385
(Constant) 3.663 .036 102.627 .000
The dependent variable is ln(Rate).

Exponential

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.309 .095 -.018 .050
The independent variable is Pieces.
 Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces 1.632E-5 .000 .309 .919 .385
(Constant) 38.993 1.392 28.014 .000
The dependent variable is ln(Rate).

Summary
2
Model R
Linear Y=a+bx 0.092
Logarithmic y=ab x 0.046
Quadratic Y=a+bx+c x 2 0.189
Cubic Y=a x 3+b x 2+cx+d, a≠0 0.257
Growth Y=ax /b+ x 0.095
Exponential Y=ae bx 0.095

Analysis & Interpretation:

From the above table we can interpret that cubic model is best fitted for trend of S 002.
T 001
Linear
Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.343 .118 -.008 5.021
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces .004 .004 .343 .966 .366
(Constant) 19.118 9.685 1.974 .089

Logarithmic

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.361 .130 .006 4.985
The independent variable is Pieces.
 Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
ln(Pieces) 9.186 8.966 .361 1.025 .340
(Constant) -43.787 70.411 -.622 .554

Quadratic

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.632 .400 .200 4.472
The independent variable is Pieces.
 Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces .164 .096 15.938 1.716 .137
Pieces ** 2 -3.200E-5 .000 -15.604 -1.680 .144
(Constant) -175.000 115.845 -1.511 .182

Cubic

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.632 .400 .200 4.472
The independent variable is Pieces.
 Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces .085 .049 8.267 1.749 .131
Pieces ** 3 -4.267E-9 .000 -7.942 . .
(Constant) -111.000 77.914 -1.425 .204

Growth

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.343 .118 -.008 .169
The independent variable is Pieces.
 Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces .000 .000 .343 .966 .366
(Constant) 3.021 .326 9.270 .000
The dependent variable is ln(Rate).

Exponential

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.343 .118 -.008 .169
The independent variable is Pieces.
 Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces .000 .000 .343 .966 .366
(Constant) 20.511 6.684 3.069 .018
The dependent variable is ln(Rate).

Summary
2
Model R
Linear Y=a+bx 0.118
Logarithmic y=ab x 0.130
Quadratic Y=a+bx+c x 2 0.400
Cubic Y=a x 3+b x 2+cx+d, a≠0 0.400
Growth Y=ax /b+ x 0.118
Exponential Y=ae bx 0.118

Analysis & Interpretation:

From the above table we can interpret that quadratic & cubic models are best fitted for trend
of T 001.
Year 2012
B 151
Limitation:
Due to rate & pieces being same for constant demand there is no model formulation.

G 060
Due to rate being constant for five years we have made analysis by comparing amount and
pieces.

Linear
Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

1.000 1.000 1.000 .000

The independent variable is Pieces.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces 7.000 .000 1.000 . .

(Constant) -2.083E-13 .000 . .

Logarithmic

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.976 .952 .947 583.828

The independent variable is Pieces.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

ln(Pieces) 4475.394 334.263 .976 13.389 .000

(Constant) -23829.006 2144.141 -11.114 .000

Quadratic

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

1.000 1.000 1.000 .000

The independent variable is Pieces.

 Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces 7.000 .000 1.000 . .

(Constant) -2.083E-13 .000 . .

Cubic

Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

1.000 1.000 1.000 .000

The independent variable is Pieces.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces 7.000 .000 1.000 . .

(Constant) -2.083E-13 .000 . .

Growth
Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.976 .952 .947 .127

The independent variable is Pieces.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces .001 .000 .976 13.389 .000

(Constant) 7.321 .085 86.005 .000

The dependent variable is ln(Amt).

Exponential
Model Summary

Adjusted R Std. Error of the

R R Square Square Estimate

.976 .952 .947 .127

The independent variable is Pieces.

Coefficients

Standardized
Unstandardized Coefficients Coefficients

B Std. Error Beta t Sig.

Pieces .001 .000 .976 13.389 .000

(Constant) 1512.374 128.746 11.747 .000

The dependent variable is ln(Amt).

Summary
2
Model R
Linear Y=a+bx 1.000
Logarithmic y=ab x 0.952
Quadratic Y=a+bx+c x 2 1.000
Cubic Y=a x 3+b x 2+cx+d, a≠0 1.000
Growth Y=ax /b+ x 0.952
Exponential Y=ae bx 0.952
Analysis & Interpretation:

From the above table we can interpret that linear quadratic & cubic models are best fitted for
trend of G 060.
G 062

Considering the average price of euro as 69.53 per Indian rupee and converting the rates into
Indian rupees.

But rate is constant there is no model formulation.

S 002
Linear
Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.522 .273 -.091 .522
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces .000 .001 -.522 -.866 .478
(Constant) 43.636 1.056 41.312 .001
Logarithmic

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.498 .248 -.127 .531
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
ln(Pieces) -.760 .935 -.498 -.813 .502
(Constant) 48.339 6.879 7.027 .020
Quadratic

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.577 .333 -1.000 .707
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces .003 .010 2.394 .247 .846
Pieces ** 2 -1.000E-6 .000 -2.926 -.302 .814
(Constant) 41.500 7.228 5.741 .110
Cubic

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.577 .333 -1.000 .707
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces ** 2 7.308E-7 .000 2.138 .196 .877
Pieces ** 3 -3.846E-10 .000 -2.687 . .
(Constant) 42.654 2.643 16.140 .039
Growth

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.522 .273 -.091 .012
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces -1.283E-5 .000 -.522 -.866 .478
(Constant) 3.776 .025 151.931 .000
The dependent variable is ln(Rate).
Exponential

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.522 .273 -.091 .012
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces -1.283E-5 .000 -.522 -.866 .478
(Constant) 43.649 1.085 40.234 .001
The dependent variable is ln(Rate).
Summary
2
Model R
Linear Y=a+bx 0.273
Logarithmic y=ab x 0.248
Quadratic Y=a+bx+c x 2 0.333
Cubic Y=a x 3+b x 2+cx+d, a≠0 0.333
Growth Y=ax /b+ x 0.273
Exponential Y=ae bx 0.273

Analysis & Interpretation:

From the above table we can interpret that quadratic & cubic models are best fitted for trend
of S 002.

T 001
Linear
 Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.557 .310 .138 5.085
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces .006 .005 .557 1.342 .251
(Constant) 13.966 12.130 1.151 .314

Logarithmic
Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.577 .333 .167 5.000
The independent variable is Pieces.
 Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
ln(Pieces) 15.904 11.248 .577 1.414 .230
(Constant) -94.704 88.218 -1.074 .343

Quadratic
Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.745 .556 .259 4.714
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces .140 .104 12.565 1.345 .271
Pieces ** 2 -2.667E-5 .000 -12.019 -1.287 .289
(Constant) -148.333 126.652 -1.171 .326
Cubic
Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.745 .556 .259 4.714
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces .074 .053 6.662 1.399 .256
Pieces ** 3 -3.556E-9 .000 -6.125 . .
(Constant) -95.000 85.440 -1.112 .347
Growth

Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.557 .310 .138 .171
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces .000 .000 .557 1.342 .251
(Constant) 2.848 .408 6.977 .002
The dependent variable is ln(Rate).
Exponential
Model Summary
Adjusted R Std. Error of
R R Square Square the Estimate
.557 .310 .138 .171
The independent variable is Pieces.

Coefficients
Unstandardized Standardized
Coefficients Coefficients
B Std. Error Beta t Sig.
Pieces .000 .000 .557 1.342 .251
(Constant) 17.246 7.039 2.450 .070
The dependent variable is ln(Rate).

Summary
2
Model R
Linear Y=a+bx 0.310
Logarithmic y=ab x 0.333
Quadratic Y=a+bx+c x 2 0.556
Cubic Y=a x 3+b x 2+cx+d, a≠0 0.556
Growth Y=ax /b+ x 0.310
Exponential Y=ae bx 0.310

Analysis & Interpretation:

From the above table we can interpret that quadratic & cubic models are best fitted for trend
of T 001.