Exhibit 18

question 58

Short Answer

Exhibit 18.7.The following table shows the annual revenues (in millions of dollars)of a pharmaceutical company over the period 1990-2011. The autoregressive models of order 1 and 2, and ,were applied on the time series to make revenue forecasts.The relevant parts of Excel regression outputs are given below.
Model AR(1): Model AR(2): Refer to Exhibit 18.7.Using AR(2)model,find the company revenue forecast for 2012.

---

Definitions:

Rotate Cell Contents

Rotate Cell Contents is a function in spreadsheet software that allows the user to change the orientation of text within a cell, typically from horizontal to vertical alignment or vice versa.

Cell's Indent

The spacing applied from the cell's border to its content, typically used in spreadsheets to organize information visually.

Orientation Button

A control in software applications used to change the layout of a page between portrait and landscape modes.

Alignment Group

A set of tools in software applications that lets users arrange and line up text, objects, or other elements to appear organized.