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

Polynomial time algorithm - first order query, For queries Q 1 and Q 2 , w...

For queries Q 1 and Q 2 , we say Q 1 is contained in Q 2 , denoted Q 1 ⊆ Q 2 , iff Q 1 (D) ⊆ Q 2 (D) for every database D. The container problem for a fixed Query Q 0 i

Common fractions order of operations BODMAS, were can get this please

were can get this please

Build a fine automaton which accept all words, Build a Fine Automaton which...

Build a Fine Automaton which accept all words which have different first and last letters (that is if the word starts with an "a" to be accepted it should end with "b" and vice ver

Precalculus help, tsunami equation A sin (b * t) + k what is b supposed t...

tsunami equation A sin (b * t) + k what is b supposed to be if t is time a is amplitude and k is average water level (not exact value of b just what is it)

Setup the mass balance equation - linear system method, Two tanks initially...

Two tanks initially contain 100 liter liquid each. Their initial concentration are listed in the Figure below. At time zero, the input and output valves are opened simultaneously w

Exponential and logarithmic fuctions, How long does it take for an amount o...

How long does it take for an amount of money P to double itself if it is invested at 8% interest compounded 4 times a year?

Segmentation, what is segmentation and how to used as per the market with e...

what is segmentation and how to used as per the market with example?

Trignometry, tan50-sec50

tan50-sec50

Important formulas of functions , Important formulas d (a b )/ dx = 0...

Important formulas d (a b )/ dx = 0 This is a constant d ( x n ) / dx = nx n -1 Power Rule d (a x ) / dx = a x l

Rational numbers, rational number as decimal and check

rational number as decimal and check

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages