Microsoft Excel 12.
0 Answer Report
Worksheet: [nme curve fitting.xlsx]Sheet1
Report Created: 22/10/2016 12:52:01 AM
Target Cell (Value Of)
Cell
Name
$I$67 a Y1 - Y2
Original Value Final Value
160 -2.80356E-007
Adjustable Cells
Cell
Name
$C$68 A
$F$68 b B
$A$63 SIMPLE CURVE
$B$58 x
$B$59 x
$B$60 x
$B$61 x
$B$62 x
$B$63 x
Original Value
3
4
6
2
4
5
6.5
8
10
Constraints
Cell
Name
$I$68 b Y1 - Y2
Cell Value
Formula
9.7849352E-008 $I$68=0
Final Value
1.9592694678
-0.2987453584
5.0733275631
2.0034028649
3.8120939387
4.7164394692
6.0729577684
7.4294760864
9.2381671542
Status
Not Binding
Slack
0
1. STRAIGTH LINE (Y=ax+b
1
2
3
4
5
6
total
N
Y1
Y-Y1
(Y-Y1)2
Y2
Y1 - Y 2
(Y1 - Y2)2
2
4
5
6.5
8
10
50
56
58
60
70
79
35.5
373
-12.16667
-6.166667
-4.166667
-2.166667
7.833333
16.83333
-
148.0278
38.02778
17.36111
4.694444
61.36111
283.3611
552.833
48.178 13.98867 195.6828
55.316 6.850667 46.93163
58.885 3.281667 10.76934
64.2385 -2.071833 4.292493
69.592 -7.425333 55.13558
76.73 -14.56333 212.0907
0.0605 524.903
a
b
3.569
41.04
0.949477
6
62.16667
2nd DEGREE PARA
1
2
3
4
5
6
total
N
Y1
Y-Y1
(Y-Y1)2
Y2
Y1 - Y 2
(Y1 - Y2)2
2
4
5
6.5
8
10
50
56
58
60
70
79
35.5
373
-12.16667
-6.166667
-4.166667
-2.166667
7.833333
16.83333
-
148.0278
38.02778
17.36111
4.694444
61.36111
283.3611
552.833
50.43
54.664
57.495
62.634
68.844
78.79
-
11.73667
7.502667
4.671667
-0.467333
-6.677333
-16.62333
0.143
137.7493
56.29001
21.82447
0.2184
44.58678
276.3352
537.004
6
62.16667
a
b
c
r
0.238
0.689
48.1
0.971367
EXPONEN
1
2
3
4
Y-Y1
(Y-Y1)2
2
4
5
6.5
50
56
58
60
-12.16667
-6.166667
-4.166667
-2.166667
148.0278
38.02778
17.36111
4.694444
Y2
Y1 - Y 2
(Y1 - Y2)2
49.24812 12.91855 166.8888
55.08466 7.08201 50.15486
58.25741 3.909261 15.28232
63.36244 -1.195771 1.429868
5
6
total
N
Y1
8
10
70
79
35.5
373
7.833333 61.36111 68.91482 -6.748151 45.53755
16.83333 283.3611 77.08211 -14.91544 222.4705
552.833
1.05045 501.764
6
62.16667
a
b
r
44.03
0.056
0.907622
SIMPL
1
2
3
4
5
6
total
N
Y1
Y-Y1
(Y-Y1)2
Y2
Y1 - Y 2
(Y1 - Y2)2
50
4
5
6.5
8
10
56
58
60
70
79
35.5
373
-12.16667
-6.166667
-4.166667
-2.166667
7.833333
16.83333
-
148.0278
38.02778
17.36111
4.694444
61.36111
283.3611
552.833
1.6923
1.7413
1.7658
1.80255
1.8393
1.8883
-
60.47437
60.42537
60.40087
60.36412
60.32737
60.27837
362.27
3657.149
3651.225
3648.265
3643.827
3639.391
3633.481
21873.3
6
62.16667
A
B
1.6433
a
0.0245 b
r
43.9845
1.058
39.56588
RAIGTH LINE (Y=ax+b)
straight line
100
80
f(x) = 3.5692618807x + 41.0485338726
R = 0.9496151974
60
Axis Title
Column C
Linear (Co
40
20
0
1
10 11
Axis Title
2nd DEGREE PARABOLA (Y=ax+bx+c)
parabola curve
400
f(x) = 0.2383854981x^2 + 0.6894904359x + 48.1037
R = 0.9998736574
y
300
Axis Title
Lin
200
Po
Po
100
0
0
10
15
20
25
30
35
40
Axis Title
EXPONENTIAL CURVE
exponential curve
100
80
60
Axis Title
40
20
f(x) = 44.0345789194 exp( 0.056345186 x )
R = 0.9681099849
Line
Exp
100
80
f(x) = 44.0345789194 exp( 0.056345186 x )
R = 0.9681099849
60
Axis Title
40
Line
Exp
20
0
1
10 11
Axis Title
SIMPLE CURVE
Y
xY
1.69897
1.748188
1.763428
1.778151
1.845098
1.897627
10.73146
3.39794
6.992752
8.81714
11.55798
14.76078
18.97627
64.50287
SIMPLE CURVE
x
4
16
25
42.25
64
100
251.25
400
300
Axis Title
f(x) = 20.1928908258 x^0.7100502121
R = 0.8248224127
200
100
0
0
10
15
20
Axis Title
25
30
35
40
ne
85338726
Column C
Linear (Column C)
10 11
urve
+ 0.6894904359x + 48.1037855321
y
Linear (y)
Polynomial (y)
Polynomial (y)
30
35
40
l curve
xp( 0.056345186 x )
y
Linear (y)
Exponential (y)
xp( 0.056345186 x )
y
Linear (y)
Exponential (y)
10 11
CURVE
x^0.7100502121
le
Power (y)
Power (y)
25
30
35
40
