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

Operation research, details about criticl part time & pert method

details about criticl part time & pert method

What is unreducing fractions, Q, Did you know that you can unreduce a fract...

Q, Did you know that you can unreduce a fraction? Ans. Remember, you reduce a fraction by dividing the numerator and denominator by the same numbers. Here we divide

Characteristic, mention the characteristic of mathematic

mention the characteristic of mathematic

Determining Proportionality, Assume Jim had executed 15 "Splits" before his...

Assume Jim had executed 15 "Splits" before his last split of 20 seconds. If his eventual time in the road race is 4:05, what was the average time for one of his earlier splits?

Operations with rational numbers, larry spends 3/4 hours twice a day walkin...

larry spends 3/4 hours twice a day walking and playing with his dog. He spends 1/6 hours twice a day feeding his dog. how much time does larry spend on his dog each day?

Unit circle, Unit circle: The unit circle is one of the most valuable tool...

Unit circle: The unit circle is one of the most valuable tools to come out in trig.  Unluckily, most people don't study it as well. Below is the unit circle with just the first

Linear Programming, A garden shop wishes to prepare a supply of special fer...

A garden shop wishes to prepare a supply of special fertilizer at a minimal cost by mixing two fertilizers, A and B. The mixture is to contain at least 45 units of phosphate at lea

Proof of various limit properties, PROOF OF VARIOUS LIMIT PROPERTIES In...

PROOF OF VARIOUS LIMIT PROPERTIES In this section we are going to prove several of the fundamental facts and properties about limits which we saw previously. Before proceeding

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