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

Parameters of the poisson mixture model, Using R function nlm and your code...

Using R function nlm and your code from Exercise E1.2, write an R function called pois.mix.mle to obtain MLEs of the parameters of the Poisson mixture model.

NOWA method, solve the equation 540+115 using the NOWA method

solve the equation 540+115 using the NOWA method

Describe the types of triangles, Describe the Types of triangles ? Tria...

Describe the Types of triangles ? Triangles can be classified according to the lengths of the sides or the measures of the angles. 1. Naming triangles by sides An

Calculate the probability, Calculate the Probability A bag contains 80...

Calculate the Probability A bag contains 80 balls of such 20 are red, 25 are blue and 35 are white. A ball is picked at random what is the probability that the ball picked is

ADAM, SQUARE 12 IN

SQUARE 12 IN

Markov chain, The Video Club Martin rents movies at "regular price" andat ...

The Video Club Martin rents movies at "regular price" andat "half price". Usually if the films are regularly priced one day, they will be at regular price the next day with probab

Fractions, Mr. And Mrs. samuel visited Florida and purchased 120 oranges. ...

Mr. And Mrs. samuel visited Florida and purchased 120 oranges. They gave 1/4 of them to relatives, ate 1/12 of them in the hotel, and gave 1/3 of them to friends. The shipped the

Optimization, The power

The power

Find the height of the tower, The angle of elevation of the top of a tower ...

The angle of elevation of the top of a tower standing on a horizontal plane from a point A is α .After walking a distance d towards the foot of the tower the angle of elevation is

Rounding, how do you round to the nearest dollars?

how do you round to the nearest dollars?

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages