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 1999.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 1999 is coded as 0,2000 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 trend value for 1999 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 1999.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 1999 is coded as 0,2000 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 trend value for 1999 is ________.

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