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

Absolute convergent, Find out if each of the subsequent series are absolute...

Find out if each of the subsequent series are absolute convergent, conditionally convergent or divergent. Solution: (a) The above is the alternating harmonic ser

Properties of triangle, In triangle ABC, cosecA(sinB.sinC+cosB.sinC) is equ...

In triangle ABC, cosecA(sinB.sinC+cosB.sinC) is equal to..?

Transportation problem, matlab code for transportation problem solved by vo...

matlab code for transportation problem solved by vogel''s approximation method

Draw tangent graph y = tan ( x ), Graph y = tan ( x ). Solution In...

Graph y = tan ( x ). Solution In the case of tangent we need to be careful while plugging x's in since tangent doesn't present wherever cosine is zero (remember that tan x

Vector form of the equation of a line, Vector Form of the Equation of a Lin...

Vector Form of the Equation of a Line We have, → r = → r 0 + t → v = (x 0 ,y 0 ,z 0 ) + t (a, b, c) This is known as the vector form of the equation of a line.  The lo

Mr, Probability of A is 85% Probability of B is 45% Probability A and B 56%...

Probability of A is 85% Probability of B is 45% Probability A and B 56% What is the probability of not either A or B?

Polynomial time algorithm - first order query, For queries Q 1 and Q 2 , w...

For queries Q 1 and Q 2 , we say Q 1 is contained in Q 2 , denoted Q 1 ⊆ Q 2 , iff Q 1 (D) ⊆ Q 2 (D) for every database D. The container problem for a fixed Query Q 0 i

Areas of a rectangle, a rectangular field with a path around it measures 1...

a rectangular field with a path around it measures 120m by 50m.if the path is 1m wide all around,(a)find the length of the outer edge of the path.(b)find the area of the path

SHARES AND DIVIDEND, i am a student of class 10 and need help for making my...

i am a student of class 10 and need help for making my project on shares and dividend

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