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

Inventory record, a) Complete the inventory record below for an FOQ of 100 ...

a) Complete the inventory record below for an FOQ of 100 units. b) Talk about weaknesses of MRP. List at least 3 and describe each in a sentence or two. Item: A

Function notation, Now we need to move onto something called function notat...

Now we need to move onto something called function notation. Function notation will be utilized heavily throughout most of remaining section and so it is important to understand i

Derivatives to physical systems, Derivatives to Physical Systems: A st...

Derivatives to Physical Systems: A stone is dropped into a quiet lake, & waves move within circles outward from the location of the splash at a constant velocity of 0.5 feet p

Write down the first few terms of the sequences, Write down the first few t...

Write down the first few terms of each of the subsequent sequences. 1. {n+1 / n 2 } ∞ n=1 2. {(-1)n+1 / 2n} ∞ n=0 3. {bn} ∞ n=1, where bn = nth digit of ? So

Determine the measure of a base angle, The angle calculate of the base angl...

The angle calculate of the base angles of an isosceles triangle are shown by x and the vertex angle is 3x + 10. Determine the measure of a base angle. a. 112° b. 42.5° c.

Basic mathematics, what is 5x - 14x + 7x =

what is 5x - 14x + 7x =

Sum of a number of terms in a.p., We know that the terms in an ...

We know that the terms in an A.P. are given by a, a + d, a + 2d, a + 3d, ........ a + (n - 2)d, a + (n - 1)d The sum of all t

Earth geometry, calculate the shortest distance between A and B 40degrees w...

calculate the shortest distance between A and B 40degrees west and 50 degrees east respectively laying along 57 degrees north

Factors, write down all the factors of 36

write down all the factors of 36

.shortiest form, 6 7/10+8 9/4

6 7/10+8 9/4

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages