Filter
Top Products
E-49
Command Calculation Formula
Estimated Value
m
m =
lnb
lny – lna
Estimated Value
n
n = ab
x
Power Regression
Command Calculation Formula
Regression Formula
Constant Term a
a
=
exp
()
n
Σlny
i
– b
.
Σ
lnx
i
Regression Coeffi cient b
b =
n
.
Σ
(
ln
x
i
)
2
–
(
Σlnx
i
)
2
n
.
Σ
lnx
i
ln
y
i
– Σlnx
i
.
Σ
lny
i
Correlation Coeffi cient r
r =
{n
.
Σ
(
ln
x
i
)
2
–
(
Σlnx
i
)
2
}{n
.
Σ
(
ln
y
i
)
2
–
(
Σlny
i
)
2
}
n
.
Σ
lnx
i
ln
y
i
– Σlnx
i
.
Σ
lny
i
Estimated Value
m
m = e
b
ln y – ln a
Estimated Value
n
n = ax
b
Inverse Regression
Command Calculation Formula
Regression Formula
Constant Term a
a =
n
Σy
i
– b
.
Σ
x
i
–1
Regression Coeffi cient b
b =
Sxx
Sxy
Correlation Coeffi cient r
r =
Sxx
.
Syy
Sxy
However,
Sxx = Σ(x
i
–1
)
2
–
Syy = Σy
i
2
–
Sxy = Σ(x
i
–1
)y
i
–
n
(Σx
i
–1
)
2
n
Σx
i
–1
.
Σy
i
n
(Σy
i
)
2
Sxx = Σ(x
i
–1
)
2
–
Syy = Σy
i
2
–
Sxy = Σ(x
i
–1
)y
i
–
n
(Σx
i
–1
)
2
n
Σx
i
–1
.
Σy
i
n
(Σy
i
)
2