Explore BrainMass
Share

# Predicting sales using linear regression line estimation

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

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.

Year Sales
(t) (Y)
1 5.4
2 6.2
3 12.7
4 20.6
5 28.4
6 44.9

https://brainmass.com/statistics/linear-regression/predicting-sales-using-linear-regression-line-estimation-198827

#### Solution Preview

Please see the attached file for complete solution. Work done with the help of equation writer and graph may not print here.

Solution

Year Sales
X (Y) X^2 Y^2 XY
1 5.4 1 29.16 5.4
2 6.2 4 38.44 12.4
3 ...

#### Solution Summary

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.

\$2.19