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

Determine the number of blue balls in the bag, A bag contains 5 red balls a...

A bag contains 5 red balls and some blue balls. If the probability of drawing a blue ball is double that of a red ball , determine the number of blue balls in the bag.

Steps for radio test - sequences and series, Steps for Radio test Assum...

Steps for Radio test Assume we have the series ∑a n Define, Then, a. If L b. If L>1 the series is divergent. c. If L = 1 the series might be divergent, this i

How far is balloon from the shore, Steve Fossett is going the shores of Aus...

Steve Fossett is going the shores of Australia on the ?rst successful solo hot air balloon ride around the world. His balloon, the Bud Light Spirit of Freedom, is being escorted

MATLAB, Program of "surface of revolution" in MATLAB

Program of "surface of revolution" in MATLAB

How many multiplication required to calculate matrix product, (a) Assume th...

(a) Assume that A is a m 1 ×m 2 matrix and B is a m 2 ×m 3 matrix. How many multiplications are required to calculate the matrix product AB? (b) Given that A 1 is a 20 × 50 m

Modeling , A plastic manufacturer has 1200 boxes of transparent wrap in sto...

A plastic manufacturer has 1200 boxes of transparent wrap in stock at one factory and 1000 boxes at his second factory.The manufacturer has order for this product from 3 different

#title, how do you do hard math!!!

how do you do hard math!!!

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