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

Evaluate the volume of cylinder, If the diameter of a right cylinder is dou...

If the diameter of a right cylinder is doubled and the height is tripled, its volume is a. multiplied by 12. b. multiplied by 2. c. multiplied by 6 d. multiplied by 3.

rational nmber, every rational nmber is expressible either as a_________or...

every rational nmber is expressible either as a_________or as a____________decimal.

Compound interest, principal=2000 rate=5% time=2 years find compound intere...

principal=2000 rate=5% time=2 years find compound interest

Determine the range of given algorithm, The division algorithm says that wh...

The division algorithm says that when a is divided by b, a unique quotient and remainder is obtained. For a fixed integer b where b ≥ 2, consider the function f : Z → Z given by f(

Advantages and limitations of game theory, Advantages And Limitations Of Ga...

Advantages And Limitations Of Game Theory Advantage Game theory assists us to learn how to approach and understand a conflict condition and to develop the decision making

How many pages are not advertisements, The first section of a newspaper has...

The first section of a newspaper has 16 pages. Advertisements take up (3)3/8 of the pages. How many pages are not advertisements? Subtract the number of pages of advertisements

Point of intersection, Equation of line joining(0,0)and point of intersecti...

Equation of line joining(0,0)and point of intersection of X2+Y2+2XY=4 , 3x2+5y2-xy=7 is solution) The two equations above represent pair of straight lines. We can complete the sq

Minimizing the sum of two distances, The value of y that minimizes the sum ...

The value of y that minimizes the sum of the two distances from (3,5) to (1,y) and from (1,y) to (4,9) can be written as a/b where a and b are coprime positive integers. Find a+b.

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