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

Determine matrix of transformation for orthogonal projection, Determine the...

Determine the matrix of transformation for the orthogonal projection onto the line L that passes through the origin and is in the direction Û=(3/13 , 4/13 , 12/13). Determine the r

Geometric mean-geometric progression, Geometric mean - It is a measure ...

Geometric mean - It is a measure of central tendency normally utilized to measure industrial increases rates. - It is explained as the nth root of the product of 'n' observa

Find the area of the rhombus, Show that the points (3, 0), (4, 5), (-1, 4) ...

Show that the points (3, 0), (4, 5), (-1, 4) and (-2, -1) taken in order are the vertices of a rhombus. Also find the area of the rhombus.

COMPUTERISED PAYROLL PACKAGES, TYPES OF COMPUTERISED PAYROLL PACKAGES

TYPES OF COMPUTERISED PAYROLL PACKAGES

Draw the digraph for the partial order, 1. Consider the relation on A = {1,...

1. Consider the relation on A = {1, 2, 3, 4} with relation matrix: Assume that the rows and columns of the matrix refer to the elements of A in the order 1, 2, 3, 4. (a)

the comic book, a) The first comic book is of shakitman was sold in 1938. ...

a) The first comic book is of shakitman was sold in 1938. In 2010, the estimated price for this comic book in good condition was about $500,000. This represented a return of 25 per

1, 5 hockey pucks and three hockey sticks cost $23. 5 hockey pucks and 1 ho...

5 hockey pucks and three hockey sticks cost $23. 5 hockey pucks and 1 hockey stick cost $20. How much does 1 hockey puck cost?

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.

Rounding, what is the nearest ten thousand of 92,892?

what is the nearest ten thousand of 92,892?

Math, i need help in math

i need help in math

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages