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

Circles, how to find equations of circles when given equations of centres o...

how to find equations of circles when given equations of centres on which it lies?

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

Inverse function, how to solve the equation of an inverse function

how to solve the equation of an inverse function

Calculus!, x+2y^2=63 and 4x+y^2=0; Find the area of the regions enclosed by...

x+2y^2=63 and 4x+y^2=0; Find the area of the regions enclosed by the lines and curves.

Cenamatic, a tire placed on a balancing machine in a service station starts...

a tire placed on a balancing machine in a service station starts from rest an d turns through 4.7 revolutions in 1.2 seconds before reaching its final angular speed Calculate its a

How many feet is the width of the deck, A pool is surrounded through a deck...

A pool is surrounded through a deck that has the similar width all the way around. The total area of the deck only is 400 square feet. The dimensions of the pool are 18 feet throug

Evaluating a function, Evaluating a Function You evaluate a function by...

Evaluating a Function You evaluate a function by "plugging in a number". For example, to evaluate the function f(x) = 3x 2 + x -5 at x = 10, you plug in a 10 everywhere you

Decimals, 0.875 of a number is 2282. What is the number ?

0.875 of a number is 2282. What is the number ?

Given the hypotenuse of a right triangle, Given the hypotenuse of a right t...

Given the hypotenuse of a right triangle: Given that the hypotenuse of a right triangle is 18" and the length of one side is 11", what is the length of another side? a 2 +

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