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

Properties of integer exponents, Note that there are two possible forms for...

Note that there are two possible forms for the third property. Usually which form you use is based upon the form you want the answer to be in. Note as well that several of these

Set builder notation, A={2,3,5,7,11} B={1,3,5,7,9} C={10,20,30,40,......100...

A={2,3,5,7,11} B={1,3,5,7,9} C={10,20,30,40,......100} D={8,16,24,32,40} E={W,O,R,K} F={Red,Blue,Green} G={March,May} H={Jose,John,Joshua,Javier} I={3,6,9,12,15}

Área de un rectangulo, calcula el área de la región sombreada de un rectáng...

calcula el área de la región sombreada de un rectángulo cuya base es 12.6 cm y su altura es 8.4

Find relative extrema f ( x ) = x2 on [-2, Recognizes the absolute extrema...

Recognizes the absolute extrema & relative extrema for the given function.  f ( x ) = x 2        on                  [-2, 2] Solution Following is the graph for this fun

Triangles, The sides of a triangle are x^(2 )+x+1, 2x+1,x^2-1, prove that t...

The sides of a triangle are x^(2 )+x+1, 2x+1,x^2-1, prove that the largest angle is 120 degrees, and find range of x. Ans) The biggest side is x^(2) + x + 1 so findout the angl

Help me help me!, A 65 ohm resistor is connected to a power supply , a curr...

A 65 ohm resistor is connected to a power supply , a current of 2.4 amperes is drawn. what is the output voltage?

Kotler, Marketing management,Analysis,planning and implementation

Marketing management,Analysis,planning and implementation

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