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

Compound interest, some experts estimate that the cost of education in the ...

some experts estimate that the cost of education in the US increases by 6% p.a. An Ivy League college currently costs $24,502 for one year''s study today. Using compound interest r

Trignometry, Sin3x ? Solution) THE FORMULA IS RIGHT ,SO sin3x=3sin...

Sin3x ? Solution) THE FORMULA IS RIGHT ,SO sin3x=3sinx-4sin 3 x

Recognize the importance of famous numbers, Activity This activity will ...

Activity This activity will help you recognize the importance of some very famous numbers, as well as learn more about approximations. Directions Using the Internet, provi

Cross product - vector, Cross Product In this last section we will loo...

Cross Product In this last section we will look at the cross product of two vectors.  We must note that the cross product needs both of the vectors to be three dimensional (3D

Service marketing, assignment of marketing mix on healthservices

assignment of marketing mix on healthservices

Some simple equation, divide 50 into two parts such that if 6 is subtracted...

divide 50 into two parts such that if 6 is subtracted from one part and 12 is added to the second part,we get the same number?

Implicit - explicit solution, It's easier to describe an explicit solution,...

It's easier to describe an explicit solution, in this case and then tell you what an implicit solution is not, and after that provide you an illustration to demonstrate you the dif

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