ACT Networks, Inc. develops, markets, manufactures, and sells integrated wide-area network access products. The following are annual sales data (in millions of dollars) from 2002 to 2007. Based on this data develop a linear trend equation for this time series. What is the firm's average increase in sales per year? Provide a forecast for sales for 2008.
Please see the attached file for complete solution. Work done with the help of equation writer and graph may not print here.
X (Y) X^2 Y^2 XY
1 5.4 1 29.16 5.4
2 6.2 4 38.44 12.4
Solution describes the steps in findind linear trend line using least square method. It also how linear estimated line can be used to forcast sales.