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

Scalar equation of plane - three dimensional spaces, Scalar Equation of Pla...

Scalar Equation of Plane A little more helpful form of the equations is as follows. Begin with the first form of the vector equation and write a vector for the difference. {

Changing the base of the index, Changing The Base Of The Index For com...

Changing The Base Of The Index For comparison reasons if two series have different base years, this is difficult to compare them directly. In such cases, it is essential to ch

Lpp, A paper mill produces two grades of paper viz., X and Y. Because of ra...

A paper mill produces two grades of paper viz., X and Y. Because of raw material restrictions, it cannot produce more than 400 tons of grade X paper and 300 tons of grade Y paper i

Rounding off, how to round off 42,999,523

how to round off 42,999,523

Problem solving, if you start a business and john creates 6 t shirts more t...

if you start a business and john creates 6 t shirts more than pedro and pedro four t shirts less than eva and between the three of then made 22 tshirts, how many t-shirts made each

Summation notation, SUMMATION NOTATION Under this section we require to...

SUMMATION NOTATION Under this section we require to do a brief review of summation notation or sigma notation. We will start out with two integers, n and m, along with n a

Fermats theorem, Fermat's Theorem If f(x) has a relative extrema at x...

Fermat's Theorem If f(x) has a relative extrema at x = c and f′(c) exists then x = c is a critical point of f(x). Actually, this will be a critical point that f′(c) =0.

Unique rhombus, IS SQUARE A UNIQUE RHOMBUS?

IS SQUARE A UNIQUE RHOMBUS?

Which of the subsequent represents the cost y of phone call, A telephone co...

A telephone company charges $.35 for the first minute of a phone call and $.15 for each additional minute of the call. Which of the subsequent represents the cost y of a phone call

Unitary method, what is history of Unitary method

what is history of Unitary method

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages