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

Progressions, We will look at three types of progressions called Ar...

We will look at three types of progressions called Arithmetic, Geometric and Harmonic Progression. Before we start looking at the intricacies of these let us unders

Decision theory, DECISION THEORY People constantly make decision...

DECISION THEORY People constantly make decisions in their private lives as well as in their work. Some decisions are qualitative in terms of their implications and signi

Ratio proportion unitary method, Find The Ratio Of : 2 dozens to a score

Find The Ratio Of : 2 dozens to a score

Differential equations, Verify Liouville''s formula for y "-y" - y'' + y = ...

Verify Liouville''s formula for y "-y" - y'' + y = 0 in (0, 1) ?

Determine the transfer function, A digital filter has zero at z=a and poles...

A digital filter has zero at z=a and poles at z=b andz=c, where a, b, c are the real constants. Determine the transfer function and the frequency response function of the filter an

Mental math, i dint get how to do math promblems

i dint get how to do math promblems

Solving decimal equations, The distance around a square photograph is 12.8 ...

The distance around a square photograph is 12.8 centimeters. What is the langth of each side of the fotograph?

Solve the limit problem, Solve the Limit problem as stated Limit x tends...

Solve the Limit problem as stated Limit x tends to 0 [tanx/x]^1/x^2 is ? lim m tends to infinity [cos (x/m)] ^m is? I need the procedure of solving these sums..

Determine the average bit rate - huffman codebook, 1. Consider a source wi...

1. Consider a source with 4 symbols {a,b,c,d}. The probability of the 4 symbols are P(a)=0.4, p(b) = 0.1, p(c)=0.2, p(d)= 0.3. a. Design a Huffman codebook for these symbols.

Properties of cross product - vector, Properties of Cross product If u,...

Properties of Cross product If u, v and w are vectors and c is a number then u → * v → = -v → * w → (cu → ) * v → =

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages