Forecasting by using least squares, Mathematics

Assignment Help:

Forecasting By Using Least Squares

Data have been kept of sales over the last seven years

Year	1	2	3	4	5	6	7
Sales (in '000 units	14	17	15	23	18	22	27
It is required to forecast the sales for the 8^th year

Solution

Years (x)	Sales (y)	xy	x²
1	14	14	1
2	17	34	4
3	15	45	9
4	23	92	16
5	18	90	25
6	22	132	36
7	27	189	49
Σx=28	Σy = 136	Σxy=596	Σx²= 140

136 = 7a + 28b

596 = 28a + 140b

∴b = 1.86

And substituting in one of the equations we acquire

a = 12

∴ Regression line = y = 12 + 1.86x

Or, Sales in ('000s of units) = 12.00 + 1.86 (no of years)

We utilize this expression for forecasting, for 8^th year sales = 12 + 1.86 (8)

=26.88 that is 26,888 units.

Related Discussions:- Forecasting by using least squares

How many white marbles does the jar contain? , A jar contains 54 marbles e...

A jar contains 54 marbles each of which is blue , green or white. The probability of selecting a blue marble at random from the jar is 1/3 and the probability of selecting a green

Credit and invoice, mr ouma bought two sets of spanners for sh 300per set ...

mr ouma bought two sets of spanners for sh 300per set two machanic vice at sh 1000each three set of screw driver at sh 115 per set and tool box for sh 300

Value of the game-game theory, Value Of The Game The game value refers ...

Value Of The Game The game value refers to the average pay off per play of the game over an extended period of time

Binomial theorem, 1/(1-z)(1-z)(1-z)(1-z)

1/(1-z)(1-z)(1-z)(1-z)

Polar coordinates, THE CURVE C HAS POLAR EQUATION R=[X^1/2][E^X^2/PI]. WHER...

THE CURVE C HAS POLAR EQUATION R=[X^1/2][E^X^2/PI]. WHERE X IS GREATER THAN OR EQUAL TO 0 BUT LESS THAN OR EQUAL TO PI. THE AREA OF THE FINITE REGION BOUNDED BY C AND THE LINE X EQ

Territories never was a venitian possesion, Which of those territories neve...

Which of those territories never was a Venitian possesion? Cyprus Morea Crete Sicily

Computer programming, program sample for proportion

program sample for proportion

Applications of derivatives rate change, Application of rate change Bri...

Application of rate change Brief set of examples concentrating on the rate of change application of derivatives is given in this section. Example Find out all the point

Find out primes of each denominator, Find out primes of each denominator: ...

Find out primes of each denominator: Add 1/15 and 7/10 Solution: Step 1: Find out primes of each denominator. 15 = 5 x 3 10 = 5 x 2 Step 2:

Question, Hi I have a maths question related to construction as its a cons...

Hi I have a maths question related to construction as its a construction management course...i could send some example sheets too...could it be done?

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages