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

Modi method, why modi method is used in operation research

why modi method is used in operation research

#title.calculus., find dy/dx of cosx

find dy/dx of cosx

Business math, David invests $17,000 into an account and at the end of 7 ye...

David invests $17,000 into an account and at the end of 7 years, his account has a balance of $ 26,417.77. What is the interest rate (assuming annual compounding)?

Prove that a tree with n vertices has n - 1 edges, Prove that A tree with n...

Prove that A tree with n vertices has (n - 1) edges. Ans: From the definition of a tree a root comprise indegree zero and all other nodes comprise indegree one. There should

#title.heat loss in a cylindrical pipe., briefly explain how the famous equ...

briefly explain how the famous equation for the loss of heat in a cylindrical pipe is derived

Infinite interval - improper integrals, Infinite Interval - Improper Inte...

Infinite Interval - Improper Integrals In this type of integral one or both of the limits that is upper limit and lower limit of integration are infinity. In these cases the

Complex number 1pi in polar form, Whlie solving complex number 1pi in polar...

Whlie solving complex number 1pi in polar form.In book they have taken theta =-pi/4 why not 7pi/4 because the point lie in fourth quadrant and the theta is given by 2pi-angle(alpha

Rebecca is 12.5% taller than debbie how tall is rebecca, Rebecca is 12.5% t...

Rebecca is 12.5% taller than Debbie. Debbie is 64 inches tall. How tall is Rebecca? Because Rebecca is 12.5% taller than Debbie, she is 112.5% of Debbie's height (100% + 12.5%

Numeration, which of these is between 5,945,089 and 5,956,108

which of these is between 5,945,089 and 5,956,108

Question, If X = {a, e, i, o, u} and Y = {a, b, c, d, e}, then what is Y - ...

If X = {a, e, i, o, u} and Y = {a, b, c, d, e}, then what is Y - X ?

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages