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

Triangle and its properties, in a triangle angle a is 70 and angle b is 50 ...

in a triangle angle a is 70 and angle b is 50 what is angle c.

Two circles c(o, Two circles C(O, r) and C 1 (O 1 , r 1 ) touch each other ...

Two circles C(O, r) and C 1 (O 1 , r 1 ) touch each other at P, externally or internally.  Construction: join OP and O 1 P . Proof : we know that if two circles touch each

Pre-calculus, finding the vertex for the function of the form f(x)=ax^2+bx...

finding the vertex for the function of the form f(x)=ax^2+bx+c

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

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

How long will the board be after he makes the cut, Tom is cutting a piece o...

Tom is cutting a piece of wood to form a shelf. He cut the wood to 3.5 feet, but it is too long to fit in the bookshelf he is forming. He decides to cut 0.25 feet off the board. Ho

Project, report on shares and dovidend using newspaer

report on shares and dovidend using newspaer

Integers, The set of whole numbers also does not satisfy all our requ...

The set of whole numbers also does not satisfy all our requirements as on observation, we find that it does not include negative numbers like -2, -7 and so on. To

Theorem to computer the integral, Use green's theorem to computer the integ...

Use green's theorem to computer the integral F . dr where F = ( y^2 + x, y^2 + y) and c is bounded below the curve y= - cos(x),, above by y = sin(x) to the left by x=0 and to the r

Trig, cot functions

cot functions

Curve tracing, how to curve trace? and how to know whether the equation is ...

how to curve trace? and how to know whether the equation is a circle or parabola, hyperbola ellipse?

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