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

Project, elliptical path of celestial bodies

elliptical path of celestial bodies

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.

Percentage of values will fall in the normal group, If the normal range is ...

If the normal range is 65-10 mg/dl, then what percentage of values will fall in the normal group?

Evaluating a function, Evaluating a Function You evaluate a function by...

Evaluating a Function You evaluate a function by "plugging in a number". For example, to evaluate the function f(x) = 3x 2 + x -5 at x = 10, you plug in a 10 everywhere you

TRIGONOMETRY, EXPLAIN ME ABOUT ITS FUNCTIONS.

EXPLAIN ME ABOUT ITS FUNCTIONS.

Mode, how to work out mode

how to work out mode

Examples on probability, 1. A machine comprises of three transformers A, B ...

1. A machine comprises of three transformers A, B and C. Such machine may operate if at least 2 transformers are working. The probability of each transformer working is given as di

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