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

Product and brand management, core competency vs diversification

core competency vs diversification

Understand the terms quotient and remainder, What other activities can you ...

What other activities can you suggest to help a child understand the terms 'quotient' and 'remainder'? Once children understand the concept and process of division, with enough

????????, ?????? ?????? ?? ???? ??????? ???????? ?????? 3.5 ?? ??? ???? ???...

?????? ?????? ?? ???? ??????? ???????? ?????? 3.5 ?? ??? ???? ???? ????? 50??/???? ??????20??/???? ???? ?? ?? ?????? ???????? ??? ??? ?? ??????? ??????? ? ?? ????? ????

Quadratic equation, find a quadratic equation whose roots are q+1/2 and 2p-...

find a quadratic equation whose roots are q+1/2 and 2p-1 with p+q=1

Solving math problems to the second power, -10b2*-5b2=

-10b2*-5b2=

Determine the total area of the land, John is planning to buy an irregularl...

John is planning to buy an irregularly shaped plot of land. Referring to the diagram, determine the total area of the land. a. 6,400 m 2 b. 5,200 m 2 c. 4,500 m 2 d.

Solve 6 sin ( x/2)= 1 on [-20, Solve 6 sin ( x/2)= 1 on [-20,30] Soluti...

Solve 6 sin ( x/2)= 1 on [-20,30] Solution Let's first work out calculator of the way since that isn't where the difference comes into play. sin( x/2)= 1/6 ⇒x/2= sin

Operations research, What is modi method?

What is modi method?

Initial value problem, An IVP or Initial Value Problem is a differential eq...

An IVP or Initial Value Problem is a differential equation with an appropriate number of initial conditions. Illustration 3 : The subsequent is an IVP. 4x 2 y'' + 12y' +

Logarithmic form and exponential form, Logarithmic form and exponential for...

Logarithmic form and exponential form ; We'll begin with b = 0 , b ≠ 1. Then we have y= log b x is equivalent to x= b y The first one is called

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages