Instruction 14-12
the Executive Vice-President of a Drug Manufacturing Firm

question 32

Short Answer

Instruction 14-12
The executive vice-president of a drug manufacturing firm believes that the demand for the firm's most popular drug has been evidencing an exponential trend since 1995.She uses Microsoft Excel to obtain the partial output below.The dependent variable is the log base 10 of the demand for the drug,while the independent variable is years,where 1995 is coded as 0,1996 is coded as 1,etc.
SUMMARY OUTPUT
Regression Statistics
$\begin{array} { l r } \text { Multiple R } & 0.996 \\ \text { R Square } & 0.992 \\ \text { Adjusted R Square } & 0.991 \\ \text { Standard Error } & 0.02831 \end{array}$
Observations $\quad \quad \quad \quad \quad \quad \quad \quad$ 12
$\quad \quad \quad \quad \quad \quad$ Coefficients
$\begin{array} { l r } \text { Intercept } & 1.44 \\ \text { Coded Year } & 0.068 \end{array}$
-Referring to Instruction 14-12,the fitted exponential trend equation to predict Y is ________.

---

Definitions:

Futures Contracts

Standardized legal agreements to buy or sell something at a predetermined price at a specified time in the future, often used for commodities or financial instruments.

Troy Oz

A unit of measure for precious metals, where one troy ounce equals approximately 31.1035 grams.

Futures Contracts

Legal agreements to buy or sell a particular commodity or asset at a predetermined price at a specified time in the future.

Domestic Sugar

Sugar produced and consumed within a country's borders, not involving any international trade.