32
Advertisement expenses: x
Effectiveness: y (%)
18
38
35
54
40
59
21
40
19
38
minX
20.
maxY
141.
45 y
133.2
180 x
135.
Operation
Display (Lower)
Display (Upper)
Logarithmic, Exponential, Power, and Inverse Regression Formulas
Logarithmic Regression : y = A + Blnx
Exponential
Regression : y
=
Ae
Bx
(lny = lnA + Bx)
Power
Regression
: y
=
Ax
B
(lny = lnA + Blnx)
Inverse
Regression
: y
=
A+Bx
-1
Quadratic Regression
The quadratic regression is in relation to the formula:
y = A + Bx + Cx
2
Example:
ABC company investigated the effectiveness of the
advertisement expenses in coded units, the following data were
obtained:
Please calculate the correlation coefficient; use the regression to
estimate the effectiveness (estimate the value of y) if the
advertisement expenses x = 30, and estimate the advertisement
expenses level (estimate the value of x
1
, x
2
) for the effectiveness y=50
(Minimum Investment)
(Maximum Yield)
(Yield%)
(Investment unit)
(Quad Regression)
- - - - - - - - - - - -