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

Fraction word problem, castor brought 6 3/4 carat cakes to share with 26 st...

castor brought 6 3/4 carat cakes to share with 26 students. did castor bring enough for each student to have 1/4 of cake?

Rolles theorem, Rolle's Theorem Assume f(x) is a function which satis...

Rolle's Theorem Assume f(x) is a function which satisfies all of the following. 1. f(x) is continuous in the closed interval [a,b]. 2. f(x) is differentiable in the ope

Define number line, Q. Define Number Line? Ans. A number line is a...

Q. Define Number Line? Ans. A number line is a nice way to visualize and examine the ordering of the positive and negative numbers. Every positive and negative number that

Word Problem, One box can hold 5 1/2 lbs of nuts and 3 lb 6oz of bolts. Wha...

One box can hold 5 1/2 lbs of nuts and 3 lb 6oz of bolts. What is the total weight for one box?

Derivative with polar coordinates - parametric equations, Derivative with P...

Derivative with Polar Coordinates dy/dx = (dr/dθ (sin θ) + r cos θ) / (dr/dθ (cosθ) - r sinθ) Note: Rather than trying to keep in mind this formula it would possibly be easi

Solve sin (a /7) =0 trig function, Solve sin (α /7) =0 . Solution B...

Solve sin (α /7) =0 . Solution By Using a unit circle it isn't too difficult to see that the solutions to this equation are, α /7 = 0 + 2 ? n ⇒ α = 14 ? n

Inverse laplace transforms, Determining the Laplace transform of a function...

Determining the Laplace transform of a function is not terribly hard if we've found a table of transforms opposite us to use as we saw in the previous section. What we would want t

College Algebra, Find the center and radius of the circle whose equation is...

Find the center and radius of the circle whose equation is 3 x^2 - 8 x+ 3 y^2+ 4 y+ 2 = 0

Initial value problem, An IVP or Initial Value Problem is a differential eq...

An IVP or Initial Value Problem is a differential equation with an appropriate number of initial conditions. Illustration 3 : The subsequent is an IVP. 4x 2 y'' + 12y' +

Prove that rb is a tangent to the circle, QR is the tangent to the circle w...

QR is the tangent to the circle whose centre is P. If QA || RP and AB is the diameter, prove that RB is a tangent to the circle.

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages