# Unit 8/9 help

Options
Registered Posts: 144 Dedicated contributor 🦉
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?

• Registered, Moderator Posts: 2,034 mod
Options
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
Sandy
sandy@sandyhood.com
www.sandyhood.com
• Registered Posts: 144 Dedicated contributor 🦉
Options
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?