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

Probability., an insurance salesman sells policies to 5 men, all of identic...

an insurance salesman sells policies to 5 men, all of identical age in good health. the probability that a man of this particular age will be alive 30 years hence is 2/3.Find the p

Sequencing, jobs a b c d e f 1 15 8 6 14 6 26 ...

jobs a b c d e f 1 15 8 6 14 6 26 2 17 7 9 10 15 22 3 21 7 12 9 11 19 4 18 6 11 12 14 17

Houses having the floor , Suppose you are in the market for a new home and ...

Suppose you are in the market for a new home and are interested in a new housing community under construction in a another city. a) The sales representative informs you that the

Between that two call numbers should she place the book, A librarian is ret...

A librarian is returning library books to the shelf. She uses the call numbers to denote while the books belong. She requires placing a book about perennials along with a call numb

Computed the total cost y of a ride which was x miles, A ride in a taxicab ...

A ride in a taxicab costs $1.25 for the first mile and $1.15 for each additional mile. Which of the following could be used to computed the total cost y of a ride which was x miles

Fractions rates and ratios, In 6th grade I am learning about ratios rates a...

In 6th grade I am learning about ratios rates and fractions. I am working on vmathlive.com and need serious.

He would such as to leave 20% tip how much should he leave, Mr. Pelicas too...

Mr. Pelicas took his family out to dinner. The bill was $65.00. He would such as to leave a 20% tip. How much should he leave? Find 20% by multiplying $65 through the decimal e

Derive the marshalian demand functions, (a) Derive the Marshalian demand fu...

(a) Derive the Marshalian demand functions for the following utility function: u(x 1 ,x 2 ,x 3 ) = x 1 + δ ln(x 2 )       x 1 ≥ 0, x 2 ≥ 0 Does one need to consider the is

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