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

Example of multiplication of matrix, Given So calculate AB. Sol...

Given So calculate AB. Solution The new matrix will contain size 2 x 4. The entry in row 1 and column 1 of the new matrix will be determined by multiplying row 1 of

Brownian motion, How do I find the density of a square of a brownian motion...

How do I find the density of a square of a brownian motion .

Fractions, how do you multiply fractions

how do you multiply fractions

Integers, What are some equations for 36?

What are some equations for 36?

Pert, define algorithm of pert and pert with suitable examples

define algorithm of pert and pert with suitable examples

Find out indegree, Question: Consider a digraph D on 5 nodes, named x0...

Question: Consider a digraph D on 5 nodes, named x0, x1,.., x4, such that its adjacency matrix contains 1's in all the elements above the diagonal A[0,0], A[1,1], A[2,2],.., e

Explain simplifying rational expressions, Explain Simplifying Rational Expr...

Explain Simplifying Rational Expressions ? A rational expression, or algebraic fraction, is an expression in which you have a polynomial divided by a polynomial. Sometimes it

Fraction, how do you learn about equivelant fractions

how do you learn about equivelant fractions

Gravity, There is a list of the forces which will act on the object. Gr...

There is a list of the forces which will act on the object. Gravity, F g The force because of gravity will always act on the object of course. Such force is F g = mg

Geometry, what shapes can go into a triangular prism

what shapes can go into a triangular prism

Write Your Message!

Name

Email id

Message

Verfication Code

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

User Account

All Pages