Forecasting by using least squares, Mathematics

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.

Posted Date: 2/16/2013 7:49:36 AM | Location : United States







Related Discussions:- Forecasting by using least squares, Assignment Help, Ask Question on Forecasting by using least squares, Get Answer, Expert's Help, Forecasting by using least squares Discussions

Write discussion on Forecasting by using least squares
Your posts are moderated
Related Questions
Find the largest possible positive integer that will divide 398, 436, and 542 leaving remainder 7, 11, 15 respectively. (Ans: 17) Ans: The required number is the HCF of the n

prove angle MJL is congruent to angle KNL


Maria has a slice of pizza that is1/6 the pizza. Ben has a slice of pizza that is 1/3 of the pizza . Maria''s slice is bigger .draw pizzas to show how this possible .

in 2000,nearly 18% of cars in north America were sliver. what percent of the cars sold were not sliver?

The lower portion of a hay stack is an inverted cone frustum and the upper part is a cone find the total volume of the hay stack.

Add 1011 and 1101 in base 2

Consider the following linear equations. x1-3x2+x3+x4-x5=8 -2x1+6x2+x3-2x4-4x5=-1 3x1-9x2+8x3+4x4-13x5=49

Chain Rule : Assume that we have two functions f(x) & g(x) and they both are differentiable. 1.   If we define F ( x ) = ( f o g ) ( x ) then the derivative of F(x) is,

Bikes are on sale for 30% off the original price. What percent of the original price will the customer pay if he gets the bike at the sale price? The original price of the bike