Unit 8/9 help

Terdoo

A computer program has used a linear regression to analysis, using quarter number 30 is the first quarter of yr 2000) the sales trend has being detemine as
Sales Trend (in£) = (Quarter Number * £1200) + £83000
and here they have quarter 1, 2, 3, & 4, using the data calculate the forcast of sales in £s for each quarter 2003.

How do they know that quarter 2003 is 42 and the next quarter is 43? how do you calculate the quarter to come to this?

Could someone help with an explained answer please?

Thanks in advance

SandyHood

Year/Quarter......2000/1...2000/2..2000/3.2000/4..2001/1......2002/1.....2003/1...2003/2..2003/3.2003/4
Quarter No.............30.......31........32.......33........34..............38........42..........43.........44........45

Sales
Trend..............(30 x £1,200)
......................+ £83,000
....................£119,000

Terdoo

Re unit 8/9

Thanks for the quick reply. Sandyhood, could you pls help with this,

Average seasonal variation in turnover were:


Q1 Q2 Q3 Q4

2005 -28 -3 -21 +53

2006 -31 0 -22 +52

Total -59 -3 -43 +10

Average 29.5
How do you calculate the average?
thanks in advance

SandyHood

59/2 = 29.5

2 years worth of data, so add the two values together and divide by 2