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

Right angle triangle, If the points for a right angle triangle are XYZ wher...

If the points for a right angle triangle are XYZ where do I mark the points?

Describe independent events in maths, Describe Independent Events in maths?...

Describe Independent Events in maths? Events are independent if the outcome of one event does not affect the outcome of the second event. If A represents one independent event

Integers, The set of whole numbers also does not satisfy all our requ...

The set of whole numbers also does not satisfy all our requirements as on observation, we find that it does not include negative numbers like -2, -7 and so on. To

Determine the average bit rate - huffman codebook, 1. Consider a source wi...

1. Consider a source with 4 symbols {a,b,c,d}. The probability of the 4 symbols are P(a)=0.4, p(b) = 0.1, p(c)=0.2, p(d)= 0.3. a. Design a Huffman codebook for these symbols.

Constants of integration, CONSTANTS OF INTEGRATION Under this section w...

CONSTANTS OF INTEGRATION Under this section we require to address a couple of sections about the constant of integration. During most calculus class we play pretty quick and lo

Give an example of numerator and denominator, Give an example of Numerator ...

Give an example of Numerator and Denominator? Fractions represent parts of a whole object. Fractions are written using a horizontal line, with one number on top of the line and

Variation of parameters, In this case we will require deriving a new formul...

In this case we will require deriving a new formula for variation of parameters for systems.  The derivation now will be much simpler than the when we first noticed variation of pa

How to plot line graphs, Q. How to plot Line Graphs? Ans. Line gra...

Q. How to plot Line Graphs? Ans. Line graphs can be useful in analyzing data. They are particularly helpful when you are interpolating or extrapolating information from y

RATIO, 3 years to 104 weeks,express answer in ratio

3 years to 104 weeks,express answer in ratio

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