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

How many teachers are there at russell high, There are 81 women teachers at...

There are 81 women teachers at Russell High. If 45% of the teachers in the school are women, how many teachers are there at Russell High? Use the proportion part/whole = %/100.

Decimal representations of some basic angles, Decimal representations of so...

Decimal representations of some basic angles: As a last quick topic let's note that it will, on occasion, be useful to remember the decimal representations of some basic angles. S

Intermediate value theorem, Intermediate Value Theorem Suppose that f(x...

Intermediate Value Theorem Suppose that f(x) is continuous on [a, b] and allow M be any number among f(a) and f(b).   There then exists a number c such that, 1. a 2. f (

the comic book, a) The first comic book is of shakitman was sold in 1938. ...

a) The first comic book is of shakitman was sold in 1938. In 2010, the estimated price for this comic book in good condition was about $500,000. This represented a return of 25 per

SHOPPERS`STOP, 3. How are Indian customers visiting Shoppers’ Stop any diff...

3. How are Indian customers visiting Shoppers’ Stop any different from customers of developed western countries? 4. How should Shoppers’ Stop develop its demand forecasts?

Matrix, how to solve for x

how to solve for x

Some definitions of exponential e, Some Definitions of e 1. ...

Some Definitions of e 1. 2.   e is the unique +ve number for which 3. The second one is the significant one for us since that limit is exactly the limit

Algebra, Solve 2x^2 + 5x + 36

Solve 2x^2 + 5x + 36

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