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 8th year

Solution

Years (x)

Sales (y)

xy

x2

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

    Σx2= 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 8th year sales = 12 + 1.86 (8)

=26.88 that is 26,888 units.


Related Discussions:- Forecasting by using least squares

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

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

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!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd