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

Sample of proportion program., help me with how to write sample of proport...

help me with how to write sample of proportion using visual basic

Matrix, how to find eigen value for the given matrix 122 021 -122

how to find eigen value for the given matrix 122 021 -122

Derive expressions for the mean and variance, On each day t of n days, N cu...

On each day t of n days, N customers of a supermarket were sampled and the number Xt expressing dissatisfaction was recorded. The results suggested that there were good and bad day

Compute the total and annual return on the investment, 1. Calculate the ann...

1. Calculate the annual interest that you will receive on the described bond-A $500 Treasury bond with a current yield of 4 .2% that is quoted at 106 points? 2. Compute the tota

Times, teach me how to o times 7s

teach me how to o times 7s

Polynomials, find a quadratic polynomial whose zeroes are 2 and -6.verify t...

find a quadratic polynomial whose zeroes are 2 and -6.verify the relationship between the coefficients and zeroes of the polynomial

Ratios, 450 students. if there are 50 more boys than girls, how many boys a...

450 students. if there are 50 more boys than girls, how many boys and girls are there?

Index of summation - sequences and series, Index of summation - Sequences a...

Index of summation - Sequences and Series Here now, in the i is termed as the index of summation or just index for short and note that the letter we employ to represent

Error in measurement, what is actual error and how do you calculate percen...

what is actual error and how do you calculate percentage error

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