TABLE 16-7
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
Multiple R 0.996
R Square 0.992
Adjusted R Square 0.991
Standard Error 0.02831
Observations 12
Coefficients
Intercept 1.44
Coded Year 0.068
-Referring to Table 16-7, the fitted exponential trend equation to predict Y is ________.

Question

Quizplus · Accepted Answer

The Answer of TABLE 16-7
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
Multiple R 0.996
R Square 0.992
Adjusted R Square 0.991
Standard Error 0.02831
Observations 12
Coefficients
Intercept 1.44
Coded Year 0.068
-Referring to Table 16-7, the fitted exponential trend equation to predict Y is ________.

TABLE 16-7 The Executive Vice-President of a Drug Manufacturing Firm Believes That