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

What was the original price of the coat before tax, Nick paid $68.25 for a ...

Nick paid $68.25 for a coat, including sales tax of 5%. What was the original price of the coat before tax? Since 5% sales tax was added to the cost of the coat, $68.25 is 105%

Shares and dividend, a man in rested rupee 800 is buying rupee 5 shares and...

a man in rested rupee 800 is buying rupee 5 shares and then are selling at premium of rupee 1.15. He sells all the shares.find profit

Properties of vector arithmetic, Properties of Vector Arithmetic If v, ...

Properties of Vector Arithmetic If v, w and u are vectors (each with the same number of components) and a and b are two numbers then we have then following properties. v →

Triangle, in triangle abc ab=ac and d is a point on side ac such that bc*bc...

in triangle abc ab=ac and d is a point on side ac such that bc*bc=ac*cd. prove that bc=bd

One-sided limits, One-sided limits: We do this along with one-sided limits...

One-sided limits: We do this along with one-sided limits.  As the name implies, with one-sided limits we will just looking at one side of the point in question.  Following are the

I want to learn mathematics, I was never really good at mathematics what is...

I was never really good at mathematics what is the best way? I am reading Math better explained but is there anything else I can do? I want to study advanced topics and get a good

Polar coordinates - parametric equations & polar coordinates, Polar Coordin...

Polar Coordinates Till this point we've dealt completely with the Cartesian (or Rectangular, or x-y) coordinate system.  Though, as we will see, this is not all time the easie

Derivatives, application of derivatives in engg.

application of derivatives in engg.

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