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 radicals in exponent form, Evaluate following.               ...

Evaluate following.                √16 and Solution To evaluate these first we will convert them to exponent form and then evaluate that since we already know how to

Divergence test - sequences and series, Divergence Test Once again...

Divergence Test Once again, do NOT misuse this test.  This test only says that a series is definite to diverge if the series terms do not go to zero in the limit.  If the

The definition of the derivative, The Definition of the Derivative : In t...

The Definition of the Derivative : In the previous section we saw that the calculation of the slope of a tangent line, the instantaneous rate of change of a function, and the ins

find an explicit formula, (a) The generating function G(z) for a sequence ...

(a) The generating function G(z) for a sequence g n is given by G(z) = 1 - 2z/(1 + 3z)3 Give an explicit formula for g n . (b) For the sequence gn in the previous part co

Whta is truth table, What is a truth table? Distinguish between Tautology &...

What is a truth table? Distinguish between Tautology & Contradiction?

Find the area irrigated by this system, An irrigation system uses a straigh...

An irrigation system uses a straight 30m sprinkler pipe which is capped at one end and arranged so that all water is released directly downwards and pivots around a central point.

Find out the value of the subsequent summation, Using the formulas and prop...

Using the formulas and properties from above find out the value of the subsequent summation. c The first thing that we require to do here is square out the stuff being summe

Fractions Word Problem, 1/8 of the passengers of a train were children.If t...

1/8 of the passengers of a train were children.If there were 40 children travelling in the train on a certain day,how many adults were there in that train that day?

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