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

Simple equations, three times the first of the three consecutive odd intege...

three times the first of the three consecutive odd integers is 3 more than twice the third integer. find the third integer.

Explain graphing equations with a negative slope, Explain Graphing Equation...

Explain Graphing Equations with a Negative Slope? If the slope is a negative fraction, place the negative sign on either the numerator or the denominator. Example graph y = -2/

Probability and statistics, f Y is a discrete random variable with expected...

f Y is a discrete random variable with expected value E[Y ] = µ and if X = a + bY , prove that Var (X) = b2Var (Y ) .

Square of a number added to 25 equals 10 times the number, The square of a ...

The square of a number added to 25 equals 10 times the number. What is the number? Let x = the number.  The statement, "The square of a number added to 25 equals 10 times the n

Ratio, the ratio of dogs to cats is 2 to 9.if there are 10 dogs how many ca...

the ratio of dogs to cats is 2 to 9.if there are 10 dogs how many cats are there?

Differentiate y = x x using implicit differentiation, Differentiate y = x ...

Differentiate y = x x Solution : We've illustrated two functions similar to this at this point. d ( x n ) /dx = nx n -1                                 d (a x ) /dx= a

Geometry, can i get some triangle congruence proofs help?

can i get some triangle congruence proofs help?

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