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

Quadratic Equations, how to find minimum value of quadratic equation?

how to find minimum value of quadratic equation?

Find the values of a and b, The midpoint of the line joining (2a, 4) and (...

The midpoint of the line joining (2a, 4) and (-2, 3b) is (1, 2a +1).Find the values of a & b. (Ans: a = 2, b = 2) Ans :   A(2a, 4)           P(1, 2a + 1)                 B(-2,

What is inductive reasoning, What is Inductive Reasoning ? Sometimes we...

What is Inductive Reasoning ? Sometimes we draw conclusions based on our observations. If we observe the same results again and again, we conclude that the event always has the

Scalar multiplication - vector arithmetic, Scalar Multiplication - Vector a...

Scalar Multiplication - Vector arithmetic Another arithmetic operation that we wish to look at is scalar multiplication. Specified the vector a → = (a 1 , a 2 , a 3 ) and any

Simplification, If 3/5=5,4/7=8,8/7=6 then, what should 9/6 be ?

If 3/5=5,4/7=8,8/7=6 then, what should 9/6 be ?

Compounding and Simple Interest, A painting was purchased 11 years ago for ...

A painting was purchased 11 years ago for $26900. It has just been sold for $78000. Calculate the flat rate of appreciation p.a.

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