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

Numerical analysis, just give me some tips to submit a good asignments

just give me some tips to submit a good asignments

Cycloid - parametric equations and polar coordinates, Cycloid The param...

Cycloid The parametric curve that is without the limits is known as a cycloid. In its general form the cycloid is, X = r (θ - sin θ) Y = r (1- cos θ) The cycloid pre

Integer., How do we add integers

How do we add integers

PROBABILITY.., Urn A contains 1 white,2 black and 3 red balls;Urn B contain...

Urn A contains 1 white,2 black and 3 red balls;Urn B contains 2 white,1 black and 1 red balls;and Urn C contains 4 white,5 black and 3 red balls.One urn is chosen at random and two

Compute standard and variance deviation, A firm is manufacturing 45,000 uni...

A firm is manufacturing 45,000 units of nuts. The probability of having a defective nut is 0.15 Compute the given i. The expected no. of defective nuts ii. The standard an

Rate and ratio, express 4:24 as fraction in lowest term

express 4:24 as fraction in lowest term

Finite and infinite sets, What is the Definition of Finite and infinite set...

What is the Definition of Finite and infinite sets?

Tangent, construction of tangent when center not known

construction of tangent when center not known

Calculate zeros in the denominator of rational expressions, About Zeros in ...

About Zeros in the Denominator of Rational Expressions One thing that you must be careful about when working with rational expressions is that the denominator can never be zero

Detemine multiplying a polynomial by a monomial, Detemine Multiplying a Pol...

Detemine Multiplying a Polynomial by a Monomial? To multiply a polynomial by a monomial, use the distributive property. Let's start by talking about ordinary numbers. Say th

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages